EXCEL (OR GOOGLE SHEET) DASHBOARD ...
Budget: $30 – $250 AUD
EXCEL (OR GOOGLE SHEET) DASHBOARD PROJECT
I am looking for a freelancer to create an Excel or Google Sheet dashboard that will track specific data and metrics.
Bring multiple info from the web into a spreadsheet in table form then converting to line chart. Will have to happen in stages as the data and info builds.
Data into tables tables into charts that need to be modifiable. I'm looking for data from the OECD, CFTC and then OHLC data which I can get the historical but not sure how you would have the most recent keep updating.
Essentially I want 5 lines plus price itself for each currency pair so that I can back test and look for anomalies or which one price likes to stick with an when.
1. 20 years interest rate data from OECD
2. 20 years of PPP purchasing power of parities compared with monthly mean price.
3. 20 years of moving average price monthly, weekly and daily O/H/2
4. 20 years of seasonality data which should be able to be derived from the above.
5. 20 years of COT report data
See attached file.
I am looking for a freelancer to create an Excel or Google Sheet dashboard that will track specific data and metrics.
Bring multiple info from the web into a spreadsheet in table form then converting to line chart. Will have to happen in stages as the data and info builds.
Data into tables tables into charts that need to be modifiable. I'm looking for data from the OECD, CFTC and then OHLC data which I can get the historical but not sure how you would have the most recent keep updating.
Essentially I want 5 lines plus price itself for each currency pair so that I can back test and look for anomalies or which one price likes to stick with an when.
1. 20 years interest rate data from OECD
2. 20 years of PPP purchasing power of parities compared with monthly mean price.
3. 20 years of moving average price monthly, weekly and daily O/H/2
4. 20 years of seasonality data which should be able to be derived from the above.
5. 20 years of COT report data
See attached file.