Specification
I require an API that links MT5 Data to Excel
1. Data I would like to link is hourly price data for OHLC for Indices and Forex.
2. Ability to input date range. So if I select 2 days and hourly data for GBPUSD, the table will populate in excel (Via an Add-in /API) with 24 rows of which the bottom row is the current live OHLC and hence subject to change until the bar closes
3. I guess this will be via GoogleSheets in terms of linking as in order to have it working when my PC is closed, I will need to have it via a VPS where both my MT5 Platform and GoogleSheets will be open. So the API is working real time
If this can be quoted on. It doesn't seem a crazy difficult job and probably something is out there already. Just haven't looked thoroughly!
Thanks
Vimal