Create google sheets sparklines out of historical price data

I need several Google Apps Scripts that read out the data from crypto-exchanges with data interfaces like APIs, websockets and web scraping approaches into a google sheets spreadsheet and analyse it within Google Sheets with different types of data-analysis approaches like linear regression, moving averages and others.

This will be an ongoing job based on Milestones Briefings and Milestone payments.

Your proposal should be based on the following specific request (this will be Milestone 1):

- Read out data for a predefined list of coinpairs from the platform cryptocompare (or similar cost-free cross exchange historical and realtime data providers)

- Read out 6 datasets per predefined coinpair:

Timeinterval = Timeperiod


1day = 2 years

720min = 1 year

120min = 2 months

45min = 21 days

5min = 3 days

1min = 10 Stunden

Collect data sets for each timeframe and create a sparkline for each of them. Example you get the price for each day for the last 2 years for timeinterval “1day”. Price from every 720min within the last 1 year for “720min” etc.

- Auto-apply the same approach to all predefined coin pairs, so we end up with 6 columns filled with sparklines

- Add a "sparkline settings" menu element that opens a typical google sheets dialog on the right with those options:

- Update all data feeds

- Edit general timeinterval and timeperiod values used to define data sets

IMPORTANT question that need to be answered with your monetary proposal

- Are you aware of existing google sheets data feed add ons like spread street? If yes would you use them for the task or will you be only use your custom made code for more flexibility?

- Please describe which approaches you take to avoid google sheets "request limitations", so that in your solution there will not be any "out of limit" errors.

- Please list price data sources you allready know that provide cost-free historical and realtime crypto data feeds

- Are you able to integrate those data feeds from the realtime (websocket) output from bitfinex without triggering the google sheets "out of limit" error ?

- What are your experiences with data analysis for stock/cryptomarket price movements ?

Compétences : Saisie de Données, Traitement de Données, Excel, Javascript, Web Scraping

en voir plus : create google news sitemap, create google street map, historical price data, sparkline bar chart google sheets, google sheets sparkline stocks, multiple sparklines in one cell google sheets, google sheets stock sparkline, sparkline formula, google sheets sparkline examples, multiple sparklines in one cell, sparkline google finance, create google map mysql data, google earth kml nmea data, create google data xml feed, google maps xml window data, google maps search xml data feed, data entry accuracy important problems data inaccuracy, create sheets excel column data vba, google maps api retrieving data mysql, google maps import location data

Concernant l'employeur :
( 1 commentaire ) Hamburg, Germany

Nº du projet : #17511663

Décerné à:


Hi, I have experience with google sheets with custom script code earlier and I feel your requirement will be better suited with a nodejs/mongodb application with vidualizations. The major limitation I see will be rate Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% EUR en 15 jours
(3 Commentaires)

9 freelance font une offre moyenne de €150 pour ce travail


Hello, I can help with you in your project Create google sheets sparklines out of historical price data I have more than 5 years of experience in Data Entry, Data Processing, Excel, Javascript, Web Scraping. We h Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(292 Commentaires)

Hello Germany! My Successfully Completed Google Sheets API Projects on Freelancer.com: https://www.freelancer.com/projects/php/Write-script-Google-Spreadsheet-import/ https://www.freelancer.com/projects/javascrip Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(69 Commentaires)

I define myself as a perfectionist. Who competes to beat his very own performance and then celebrates. This is something that brings me immense pleasure in the , I used to say, "I am a business student and intend to ho Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(12 Commentaires)

Hello, sir, I read your project description. I would like to work on your project. I'll finish with that google sheets job. And my typing speed was 40 wpm. Regards

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)