Google Finance to Excel ........
Thanks to Ramdas for his site - > http://niftyfno.forums-free.com/google-realtime-intraday-backfill-data-t40.html ....... where he has given all the URLs of Google from which data can be obtained.
Google Realtime feed can be obtained in three ways. I shall discuss them later. RTG3.xlsm fetches Google RT feed from this URL:-
"http://finance.google.com/finance/info?client=ig&q=NSE:IDFC,NSE:ACC"
you can just add more script ,NSE:ScriptName
I compared the time lag in Realtime quotes from each source and found that the above URL gives quotes within a time lag of 2-3 seconds which I feel is quite acceptable. There is no limit to the number of scrips that can be monitored. Realtime Quotes of other exchanges can also be obtained.
There are three down sides -
1. FnO quotes are not available.
2. Volume is not available through this URL
3. Data comes in text format. It has to be processed. Hence there is some processing overhead. I have kept the time interval for refreshing at 5 seconds. Users having lot of scrips may find that Copy/paste is not working when Google RT feed is running. In that case, they will have to increase the refresh interval.
Thanks to Ramdas for his site - > http://niftyfno.forums-free.com/google-realtime-intraday-backfill-data-t40.html ....... where he has given all the URLs of Google from which data can be obtained.
Google Realtime feed can be obtained in three ways. I shall discuss them later. RTG3.xlsm fetches Google RT feed from this URL:-
"http://finance.google.com/finance/info?client=ig&q=NSE:IDFC,NSE:ACC"
you can just add more script ,NSE:ScriptName
I compared the time lag in Realtime quotes from each source and found that the above URL gives quotes within a time lag of 2-3 seconds which I feel is quite acceptable. There is no limit to the number of scrips that can be monitored. Realtime Quotes of other exchanges can also be obtained.
There are three down sides -
1. FnO quotes are not available.
2. Volume is not available through this URL
3. Data comes in text format. It has to be processed. Hence there is some processing overhead. I have kept the time interval for refreshing at 5 seconds. Users having lot of scrips may find that Copy/paste is not working when Google RT feed is running. In that case, they will have to increase the refresh interval.