The enclosed sample excel ‘Chart’ is about plotting charts of intra-day quotes from Google finance.
In RTData sheet, we get such data with an interval of 60 sec (1 min)
In RTCal sheet, =IF(RTData!="",NA(),RTData!) is used to avoid zero data.
However,
In chart at sheet RTG, the closing price falls to zero for the data that is to be uploaded.
Can someone please help me to rectify this error ?
Again, the Y-Axis range (which is set ‘Auto’) became too large…
It should be +/- 20 from closing price’s high and lows. (any help on this too ??)
Bookmarks