Hi hanover,
Hope all is well.
Would you know how to get a closing daily price of e.g. eur/usd automatically into a spreadsheet cell, please? What I'd like to achieve is for a spreadsheet cell to change the value of the fx pair based on the daily closing price - this means that the cell's value would get overwritten every day. I have intraday prices working in my spreadsheet fine (importing it live from e-rates.com), but need the closing prices of the previous day to calculate changes between x-pairs. I appreciate I can input the closing prices manually to do the job, but trying to limit the number of manual data input steps.
Many thanks,
Rob
Hope all is well.
Would you know how to get a closing daily price of e.g. eur/usd automatically into a spreadsheet cell, please? What I'd like to achieve is for a spreadsheet cell to change the value of the fx pair based on the daily closing price - this means that the cell's value would get overwritten every day. I have intraday prices working in my spreadsheet fine (importing it live from e-rates.com), but need the closing prices of the previous day to calculate changes between x-pairs. I appreciate I can input the closing prices manually to do the job, but trying to limit the number of manual data input steps.
Many thanks,
Rob