Hi,
Teach a man to fish..... unfortunately we're given fish ie.. free RT quote softwares, the only downside of it is, we miss out on knowledge that helps us do things more customised for ourselves, most of the 'free' sheet providers keep their macros locked, thank you very much.
After much head banging ive come to find the following works well for yahoo, if anyone has query strings for Google pls post.
Yahoo query string for RT data :
for Excel :
qurl = http://download.finance.yahoo.com/d/quotes.csv?s=ABAN.NS,ALBK.NS
etc, add about 50 stocks in one go....
With ActiveSheet.QueryTables.Add(Connection:="URL;" & qurl, Destination:=DataSheet.Cells(3, 3))
This will paste query result to Cell C3
--------------------
So far i have the following on Google but not sure if its workable, the download format is too complex
http://finance.google.com/finance/info?client=ig&q=NSE:ABB,ABAN
http://finance.google.com/finance/info?client=ig&q=NASDAQ:MSFT,IBM
not even sure if its RT or EOD.
Does anyone have usable query strings for Google RT data ? Pls post, exchange and learn.
Thanks
Teach a man to fish..... unfortunately we're given fish ie.. free RT quote softwares, the only downside of it is, we miss out on knowledge that helps us do things more customised for ourselves, most of the 'free' sheet providers keep their macros locked, thank you very much.
After much head banging ive come to find the following works well for yahoo, if anyone has query strings for Google pls post.
Yahoo query string for RT data :
for Excel :
qurl = http://download.finance.yahoo.com/d/quotes.csv?s=ABAN.NS,ALBK.NS
etc, add about 50 stocks in one go....
With ActiveSheet.QueryTables.Add(Connection:="URL;" & qurl, Destination:=DataSheet.Cells(3, 3))
This will paste query result to Cell C3
--------------------
So far i have the following on Google but not sure if its workable, the download format is too complex
http://finance.google.com/finance/info?client=ig&q=NSE:ABB,ABAN
http://finance.google.com/finance/info?client=ig&q=NASDAQ:MSFT,IBM
not even sure if its RT or EOD.
Does anyone have usable query strings for Google RT data ? Pls post, exchange and learn.
Thanks
