Crypto coinmarketcap historical information into google sheets vis API
Budget: $30 – $250 AUD
Hi! I am looking to fetch and integrate the price and market cap data and some other column information of all crypto coins which are in the market into Google Sheets using coinmarketcap APIs. I require the technical expertise to get this large amount of data accurately and quickly into a few google spreadsheet tabs. I need to track the current prices and market capitalization of each coin. This information will be used to produce reports on the performance of the coins and the overall market performance. So, if you are an experienced programmer who understands how to use Crypto APIs to gain access to market data then please do apply to this project.
please read the brief below-
google sheets link - https://docs.google.com/spreadsheets/d/1Jiruz86daKgWtVEfxM294ip33RW17b3UY49aHR6du50/edit?usp=sharing
Project Brief,
You must know about cryptocurrency, coinmarketcap, the coinmarketcap API, google sheets and have a good understanding I what I am looking for. If you don’t have these requirements, please don’t send me a bid.
Project-
Use coinmarketcap and the coinmarketcap API to pull relevant crypto token information into google sheets. It only has to pull the information once to populate the required information into the sheets.
I am looking for historical information for 5 dates on all the available crypto tokens that were listed on coinmarketcap on these dates—
1- 30 August 2015
2- 17 December 2017
3- 06 September 2020
4- 14 November 2021
5- 30 April 2023
There are 6 tabs on my google sheets file. The tabs are named -
1- Historical Snapshot - 30 August 2015
2- Historical Snapshot - 17 December 2017
3- Historical Snapshot - 06 September 2020
4- Historical Snapshot - 14 November 2021
5- Historical Snapshot - 30 April 2023
6- Compare chart
I want the crypto information populated for all available crypto tokens that were listed on coinmarketcap on these date tabs
1- Historical Snapshot - 30 August 2015
2- Historical Snapshot - 17 December 2017
3- Historical Snapshot - 06 September 2020
4- Historical Snapshot - 14 November 2021
5- Historical Snapshot - 30 April 2023
And inputted similar to what I have put in these sheets as an example for you. There will be thousands of tokens for each date sheet tab most likely.
On the 5 tabs I want the information pulled in from the API populated and displayed in each sheet according to the market cap of the cryptocurrency. As mentioned there will be thousands of tokens.
In the 6th tab called ‘compare chart’, this is the most important tab. I want the crypto information for all crypto tokens available on 30th April 2023 from coinmarketcap, put In this sheet and pulled in from the api in columns A to J sorted by the Market Cap though. There could potentially be 12 thousand tokens or more.
Then I want the price values in columns K, L, M and N added to the sheet but the column values in these 4 columns K, L,M and N will have to match up with the crypto token name from columns B or C whichever is more accurate. The values must be accurate for each token name and the extra K, L, M and N price columns. There is a possibility that some token prices for the dates of –
1- 30 August 2015
2- 17 December 2017
3- 06 September 2020
4- 14 November 2021
may actually be missing, as some of these tokens may not have been created in these earlier dates that appear on the later date of the 30 April 2023 column.
That is about all. Please let me know if you have questions.
Regards
Matt G
please read the brief below-
google sheets link - https://docs.google.com/spreadsheets/d/1Jiruz86daKgWtVEfxM294ip33RW17b3UY49aHR6du50/edit?usp=sharing
Project Brief,
You must know about cryptocurrency, coinmarketcap, the coinmarketcap API, google sheets and have a good understanding I what I am looking for. If you don’t have these requirements, please don’t send me a bid.
Project-
Use coinmarketcap and the coinmarketcap API to pull relevant crypto token information into google sheets. It only has to pull the information once to populate the required information into the sheets.
I am looking for historical information for 5 dates on all the available crypto tokens that were listed on coinmarketcap on these dates—
1- 30 August 2015
2- 17 December 2017
3- 06 September 2020
4- 14 November 2021
5- 30 April 2023
There are 6 tabs on my google sheets file. The tabs are named -
1- Historical Snapshot - 30 August 2015
2- Historical Snapshot - 17 December 2017
3- Historical Snapshot - 06 September 2020
4- Historical Snapshot - 14 November 2021
5- Historical Snapshot - 30 April 2023
6- Compare chart
I want the crypto information populated for all available crypto tokens that were listed on coinmarketcap on these date tabs
1- Historical Snapshot - 30 August 2015
2- Historical Snapshot - 17 December 2017
3- Historical Snapshot - 06 September 2020
4- Historical Snapshot - 14 November 2021
5- Historical Snapshot - 30 April 2023
And inputted similar to what I have put in these sheets as an example for you. There will be thousands of tokens for each date sheet tab most likely.
On the 5 tabs I want the information pulled in from the API populated and displayed in each sheet according to the market cap of the cryptocurrency. As mentioned there will be thousands of tokens.
In the 6th tab called ‘compare chart’, this is the most important tab. I want the crypto information for all crypto tokens available on 30th April 2023 from coinmarketcap, put In this sheet and pulled in from the api in columns A to J sorted by the Market Cap though. There could potentially be 12 thousand tokens or more.
Then I want the price values in columns K, L, M and N added to the sheet but the column values in these 4 columns K, L,M and N will have to match up with the crypto token name from columns B or C whichever is more accurate. The values must be accurate for each token name and the extra K, L, M and N price columns. There is a possibility that some token prices for the dates of –
1- 30 August 2015
2- 17 December 2017
3- 06 September 2020
4- 14 November 2021
may actually be missing, as some of these tokens may not have been created in these earlier dates that appear on the later date of the 30 April 2023 column.
That is about all. Please let me know if you have questions.
Regards
Matt G