Create a fully functional Google Sheet that automatically retrieves and updates cryptocurrency data (trading volume for 7 days, percentage change in volume, price change over 24 hours and 7 days) using the CoinMarketCap API.

Scope of Work:

API Integration:
- Use the CoinMarketCap API to retrieve cryptocurrency data.
- Obtain the following metrics for 30 cryptocurrencies:
  - Trading volume for 7 days (USD).
  - Percentage change in volume (calculate based on data from the previous week).
  - Price change over 24 hours (%).
  - Price change over 7 days (%).
Google Sheets Integration:
- Record data obtained through the API directly into Google Sheets.
- Create columns for:
  - Cryptocurrency symbol.
  - Trading volume for 7 days.
  - Percentage change in volume.
  - Price change over 24 hours (%).
  - Price change over 7 days (%).
- Ensure that the data automatically updates previous values with each request.
Script Automation:
- Create a Google Apps Script for automatic requests to the API and updating data in the sheet.
- Set up an hourly trigger to automatically update the data every hour.
Testing and Debugging:
- Ensure the script runs without errors.
- Verify that all cryptocurrencies are processed and the data is correctly updated in the sheet.
Deliverables:
1. A working Google Sheet integrated with the CoinMarketCap API.
2. A working Google Apps Script that:
  - Retrieves data for 30 cryptocurrencies.
  - Updates the sheet hourly with the latest values.
3. Documentation that includes:
  - Instructions for running and testing the script.
  - Instructions for adding or removing cryptocurrencies from the list.

Deadline: 1 day

Proposals 6 Rejected 2

Oleksandr R.

44 0

Projects 37
Rating -
Rating 2 912

Budget: 200 EUR Deadline: 1 day

Good day.
I can implement
---------------------------------------

Maksym P.

2 1

Projects -
Rating -
Rating 217

Budget: 100 EUR Deadline: 1 day

Good day, I am interested in your project and ready to complete it within one day. I have experience in writing scripts in AppsScript for Google Sheets and connecting various services to it using API. Please message me privately for detailed discussion about the project!

Mihaylo Zubchenko

4 1

Projects 4
Rating -
Rating 336

Budget: 50 EUR Deadline: 1 day

Good afternoon, I am ready to start the task now. Do you have an API key? I have partially tested the API functionality already. However, the free plan does not provide access to historical data. If you have an API key, I can provide what is needed in an hour or two.

Vladislav S.

Winning proposal

102 0

Budget: 50 EUR Deadline: 1 day

Good evening. I will be happy to help. I will complete everything quickly and efficiently!

Tetyana S.

75 4

Budget: 110 EUR Deadline: 1 day

Good day! I have some experience, so I can complete your task! Feel free to reach out!!!!!!!

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Current freelance projects in the category Cryptocurrency & Blockchain

QA engineer + technical writer | crypto exchange | documentation from scratch + large volume of tests

Testing & QA 15 proposals 2:19

250 USD
I am looking for a trader.

7 proposals 27 July

Not specified

Art Tj
Riga, Latvia
Fourline

Projects 147
Contests 2
Rating -
Rating 2 016

Setting up Google Sheets integration with the CoinMarketCap API

Client's review of cooperation with Vladislav S.

Setting up Google Sheets integration with the CoinMarketCap API

5.0

Art Tj

Freelancer's review of cooperation with Art Tj

Setting up Google Sheets integration with the CoinMarketCap API

5.0

Vladislav S.

Goal:

Scope of Work:

Deliverables:

Oleksandr R.

Maksym P.

Mihaylo Zubchenko

Vladislav S.

Tetyana S.

Proposals are currently absent

Proposals concealed

Current freelance projects in the category Cryptocurrency & Blockchain

QA engineer + technical writer | crypto exchange | documentation from scratch + large volume of tests

I am looking for a trader.