Greetings to all.
Attached Macro-enabled-Excel imports data and shows content for a single query (through manual operation).
Can somebody change code (macro) so that Excel imports data for ALL the query elements available in the Excel sheet.
Data has to import without manual intervention (not like giving each and every query names in the textbox and fetching data, but Excel macro has to take each and every query elements' names, fetch and store in the same Excel). This is initiated by clicking on a Button in the Excel (without giving any query element name manually).
COMPLETE URL AS API (SAMPLE):
http://www.google.com/finance/getprices?q=TAJGVK&x=NSE&i=1800&p=1d&f=d,c
DESCRIPTION OF THE URL:
http://www.google.com/finance/getprices?
'q -> stock symbol on Google finance - ALL THE STOCK SYMBOL NAMES' DATA (GIVEN IN THE EXCEL) HAVE TO BE IMPORTED
q=TAJGVK&
'x -> exchange symbol
x=NSE&
'i -> interval (here 60 means 60 sec [1 minute interval])
i=1800&
'p -> period (here 5d denotes 5 days of data)
p=1d&
'f -> parameters (day [d], close [c], open [o], high [h], low [l] and volume [v]) - I TAKE VALUES OF 'D' & 'C' ALONE HENCE REMAINING SKIPPED (o, h, l, v)
f=d,c
Please see the attached image for what my expectation is and how I expect result to be: Excel format.png
Thanks for your patience and attention.
Eagerly waiting for a complete macro enabled Excel.
Bookmarks