Hello and thanks for your time.
On TASE (TLV stock exchange) website - you can download an excel sheet containing Market data of last business day of all stocks, bond, etc. (Market data as Prices, Change, Volume, etc,..) which I need to update every day.
So the deal is as the following:
1. First, the file when I open the link I get this message "The file you are trying to open 'Data.xls' is in a different format then specified by the file extension. verify the the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now? "
Clicking yes, will open the excel file as a Web Page.
2. Second, need to "Save As" in order to change the file extension to excel extension.
So on each day, I'm doing this frustrating process, hoping that I won't forget doing this on the next day and loose the fluent data history one day.
Is there any automate this? even only automating option #1 would help me but I prefer both
Location of the link for the exact file is here:
http://www.tase.co.il/_layouts/Tase...ype=&SecondaryClass=&searchTerm=&ExportType=1
Thank you!
On TASE (TLV stock exchange) website - you can download an excel sheet containing Market data of last business day of all stocks, bond, etc. (Market data as Prices, Change, Volume, etc,..) which I need to update every day.
So the deal is as the following:
1. First, the file when I open the link I get this message "The file you are trying to open 'Data.xls' is in a different format then specified by the file extension. verify the the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now? "
Clicking yes, will open the excel file as a Web Page.
2. Second, need to "Save As" in order to change the file extension to excel extension.
So on each day, I'm doing this frustrating process, hoping that I won't forget doing this on the next day and loose the fluent data history one day.
Is there any automate this? even only automating option #1 would help me but I prefer both

Location of the link for the exact file is here:
http://www.tase.co.il/_layouts/Tase...ype=&SecondaryClass=&searchTerm=&ExportType=1
Thank you!