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