Create Calculations in excel sheet for Crypto Index

Job ID: 33774633

Budget: $30 – $250 USD

I need to track the holdings in a crypto index on an excel sheet and calculate and track the NAV for members. The idea candidate will have experience-

-Excel formulas
-Be able to grab price data using an API
-Understand NAV

I am attaching a spreadsheet, which will explain all that is needed. Please create the final spreadsheet based on this example.

If you have questions please ask.

Free API for prices- https://www.coingecko.com/en/api