Wednesday, December 26, 2012

yogi_Pull Google Finance Value For Specified Entrity And Attribute For Latest Market Open Date On Or Prior To Specified Date


                                          Google Spreadsheet   Post  #941
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Dec 26, 2012
user EuDave said:()
Issue while getting historical data through Google finance 
I use google spreadsheet on a google chrome browser, and use the google finance function to get the stock symbol's historical data. Since last week, GoogleFinance("NIFTY","High",12/22/2012) is returning the high of the Symbol from 23rd Dec till today, where as It was returning the high from 22nd(mentioned date) to today's date previously.
---------------------------------------------------------------------------------------------
following is a solution to the problem