Create Calculations in excel sheet for Crypto Index

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- [login to view URL]

Skills: Excel, Financial Forecasting, Financial Modeling, API Testing

About the Client:
( 44 reviews ) stockton, United States

Project ID: #33774633

Awarded to:


I have worked on similar projects. I can get the live prices data from Binance or Coingecko using api into excel using power queries and can make the required calculations. Thanks.

$80 USD in 4 days
(13 Reviews)

21 freelancers are bidding on average $142 for this job


Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power More

$40 USD in 1 day
(167 Reviews)

"Sir, I am Excel, Finance, Accounting, Excel Calculations, Excel Formulas Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant with mor More

$99 USD in 1 day
(166 Reviews)

Hi, I am an Excel Expert with Professional experience working with Excel. I believe I can do great work for you and ensure your quality. I have more than 5 years of experience with excel. Complete a lot of jobs on Free More

$299 USD in 1 day
(76 Reviews)
(26 Reviews)
(42 Reviews)

Hi There, I have done similar project in Google sheet for Crypto data update from WazirX API. Let us discuss for some more details. I am sure that I can develop the application easily with 100% perfection. Please co More

$100 USD in 2 days
(31 Reviews)

hello I devour your demand that you’re viewing Create Calculations in excel sheet for Crypto Index I provide creative, proactive and high-tech solutions to your development needs. I have solid experience in HTML, Jav More

$30 USD in 1 day
(7 Reviews)
(2 Reviews)

Hello, I am a PhD Industrial Engineer and have experience in data science,and can work on projects in the following fields: Data Modeling, Data Analysis, Flow Chars, ERD Diagrams, Data Entry, IoT, Industrial IoT, Power More

$200 USD in 7 days
(8 Reviews)

--------I CAN DO IT RIGHT AWAY-------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VB, building an excel file, excel dashboard, pivot tables, charts, v More

$100 USD in 2 days
(13 Reviews)
(7 Reviews)
(1 Review)
(1 Review)

Hi sir/madam, I'm very active and interested to work with you. My time up to you. You could award your project to me and enjoy it. With best regards

$250 USD in 2 days
(3 Reviews)

I will do the work before the timeline give me a chance and we will work nearly in future. Have a great day

$250 USD in 2 days
(0 Reviews)

Customer service means a lot to me. Making sure that customers must feel that they are valued, they feel appreciated and that can be done through warm welcome with them. Customers service is also about making sure that More

$140 USD in 7 days
(0 Reviews)

Programming, networker. Experienced in excel, Word, power point and access I'm a hard worker and I'm open to learning anything new

$250 USD in 3 days
(0 Reviews)

Hello, I have good experience MS Word, MS Excel, And Using very well calculation and engineering formula's. I'm ready to discuss with you any details of your project in chat at any time. Thanks

$100 USD in 1 day
(0 Reviews)

I hold more than 10 years of professional experience in multiple countries clients. so I know very well how to behave with clients as well as good expertise in the field of Excel, Pivot Tables, Power point, file conver More

$30 USD in 1 day
(1 Review)

I am experience graduate  student of bs hons accounting & finance. I am competent with Microsoft Office applications (Word, Excel, Outlook and Power point) and I have used have fast, accurate copy (30wpm) and oral (25w More

$90 USD in 7 days
(0 Reviews)