Support Board

Date/Time: Fri, 20 Sep 2024 06:42:58 +0000

Post From: SC Historical Data Feed with Spreadsheet Quotes

[2014-09-13 12:13:14] Link To Thread - Link To Post [Go To First Post]
Trint - Posts: 113
That's understandable. It was thanks to Tobi mentioning the Currency Indices that I started using them. I hope you and he won't mind me utilising the calculations provided in the spreadsheet for any data feed I wanted to connect to. One last thing I did want to run by you, with regard to the Currency Indice calculation (if I was to implement it with a particular data feed). Using the Indice calculations I can calculate the OPEN and LAST in the spreadsheet (for columns K3 and N3) but how would I go about calculating the HIGH and LOW..? (for columns L and M) as it's obviously relative to price between the OPEN and LAST for that time period. The formula I have in column K3 for OPEN, say for AUD Currency Index is: =ROUND(((14000-(706.1/B3)-(860.6/AB3)-(756.5/AN3)-(64160/AZ3)-(1209/BL3)-(506.48BX3)-(485.58CJ3))/7), 2) (where each of the B3, AB3.... represents the OPEN for the other currency crosses) I'm very new to Spreadsheets......Is there a particular function where I can grab the abosolute HIGH or LOW between the OPEN and LAST for a specific period as I can't seem to find it.....OR is the HIGH and LOW calculated slightly differently using all the other AUD Currency Crosses...? I was hoping you might provide me the answer as to how you do it. Thanks again. Date Time Of Last Edit: 2014-09-13 12:14:14