finansu
finansu copied to clipboard
getting #value error
Hi,
I am getting #value error , every time i try to pull the history quotes for BSE/NSE, be it from Bloomberg or Google. for example:Mothersumi(NSE) and BOM:517334(BSE) is the id for Motherson Sumi on google and i am getting #value error for it. formula used is -
=QuoteHistory("mothersumi","g",DATE(2012,1,1),DATE(2012,12,31),"y","h",TRUE,TRUE)