Hi,
Can anybody tell me whether it's possible to auto-refresh the Excel file that Sharekhan's 'Speedrade' saves?
Speedtrade has an option to save the realtime data in Excel, however one needs to save it again and again to get latest data.
I need the same Excel file to refresh automatically, say in every 1 min or so.
I think macro or some other feature in excel will do the job, however I don't have much idea about Excel. So, if anybody can provide the steps, in layman's language, I'll be grateful.
I am attaching the excel file that is saved from Sharekhan.
Please note that the original file that Speedtrade saves is in .csv format which I have changed to .xls format to be able to upload here.
Thanks in advance.
Dan
Can anybody tell me whether it's possible to auto-refresh the Excel file that Sharekhan's 'Speedrade' saves?
Speedtrade has an option to save the realtime data in Excel, however one needs to save it again and again to get latest data.
I need the same Excel file to refresh automatically, say in every 1 min or so.
I think macro or some other feature in excel will do the job, however I don't have much idea about Excel. So, if anybody can provide the steps, in layman's language, I'll be grateful.
I am attaching the excel file that is saved from Sharekhan.
Please note that the original file that Speedtrade saves is in .csv format which I have changed to .xls format to be able to upload here.
Thanks in advance.
Dan