Can anyone help me in providing historical data of FTSE 100(UK) NIKKEI 225(Japan) NYSE composite (USA) BSE Sensex for time period 2000-2019. In yahoo finance, data is downloading in unknown file type , which is not opening in excel or e-views.
Sometimes you can force Excel to open a file by manually adding a dot xls file extension to the unknown file type. Another way is to read it into Notepad and save as a plain text file. Excel can usually open plain text files, which you can then parse into separate fields. Yet another way can be to read it in with Power Query under Excel's data tab. Hopefully at least one of these methods will work for you.