I am in need proficient in Excel and Tableau to create an advanced dashboard using marketing data
Budget: $2 – $8 USD
1. Create excel file with a number of sheets connecting to the deribit API and download the historical deribit data from https://docs.tardis.dev/historical-data-details/deribit
a. BTC PERP (perpetual)
i. Create a sheet for the BTC perpetual contract
ii. Data required is daily data of Open, High, Low, Close, Volume
b. ETH PERP (perpetual)
i. Create a sheet for the BTC perpetual contract
ii. Data required is daily data of Open, High, Low, Close, Volume
c. BTC options
i. Create sheets for all BTC options chains calls and puts.
ii. As new chains are created and old ones expire insert new chain into sheet
iii. Data points required are Volume, Price, Open Interest
d. ETH options
i. Create sheets for all BTC options chains calls and puts.
ii. As new chains are created and old ones expire insert new chain into sheet
iii. Data points requires are Volume, Price, Open Interest
Finally this should connect to the API daily and update the data.
a. BTC PERP (perpetual)
i. Create a sheet for the BTC perpetual contract
ii. Data required is daily data of Open, High, Low, Close, Volume
b. ETH PERP (perpetual)
i. Create a sheet for the BTC perpetual contract
ii. Data required is daily data of Open, High, Low, Close, Volume
c. BTC options
i. Create sheets for all BTC options chains calls and puts.
ii. As new chains are created and old ones expire insert new chain into sheet
iii. Data points required are Volume, Price, Open Interest
d. ETH options
i. Create sheets for all BTC options chains calls and puts.
ii. As new chains are created and old ones expire insert new chain into sheet
iii. Data points requires are Volume, Price, Open Interest
Finally this should connect to the API daily and update the data.