Fundamental Analysis Excel Dashboard
Budget: $8 – $15 USD
I have a particular need for an Excel dashboard to visualize fundamental analysis. Key areas of interest include:
EXCEL (OR GOOGLE SHEET) DASHBOARD PROJECT
I am looking for a freelancer to create a DASHBOARD in Excel, Google Sheet, Power BI, Microsoft Dynamics or Tableau (for the latter pls keep in mind I dont have Tableau ) that will track specific data and metrics as per below links.
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
1. https://data.oecd.org/interest/long-term-interest-rates.htm
2. https://data.oecd.org/conversion/purchasing-power-parities-ppp.htm
3. https://www.cftc.gov/
4. https://www.cftc.gov/
5. https://www.cftc.gov/MarketReports/CommitmentsofTraders/index.htm
EXCEL (OR GOOGLE SHEET) DASHBOARD PROJECT
I am looking for a freelancer to create a DASHBOARD in Excel, Google Sheet, Power BI, Microsoft Dynamics or Tableau (for the latter pls keep in mind I dont have Tableau ) that will track specific data and metrics as per below links.
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
1. https://data.oecd.org/interest/long-term-interest-rates.htm
2. https://data.oecd.org/conversion/purchasing-power-parities-ppp.htm
3. https://www.cftc.gov/
4. https://www.cftc.gov/
5. https://www.cftc.gov/MarketReports/CommitmentsofTraders/index.htm