In Progress

Simple Google Spreadsheet with Google Form to save historical price and data for Bitcoin

I want to do a Simple Google Spreadsheet with inputs from a Google Form.

The Form should ask me for the amount of USD, that I have today.

This is the only value which will be entered manually.

Then the result should go in a Google Sheets table and using =GOOGLEFINANCE, =CRYPTOFINANCE or any other way to calculate AND SAVE the following values:

- Bitcoin price today

- The value of the USD in Bitcoin

- Bitcoin marketcap

- Total crypto marketcap

Please don't be afraid if you are not familiar with Cryptocurencies, since there is nothing to do with them.

The Google Sheet functions =GOOGLEFINANCE and =CRYPTOFINANCE seems to be very simple.

For example if you write in a cell =GOOGLEFINANCE("BTCUSD") you immediately get the current price.

The problem is that I want to take the price in the moment when the form was filled

Forgot to write that the new rows should be at the top, not at the bottom of the Spreadsheet.

This is a kind of demo
https://docs.google.com/spreadsheets/d/1V5qiE3bexBiotinmXBeg28s_ngnMzSD0lB8MdOSPiDA/edit?usp=sharing

Skills: Data Entry, Excel, Javascript, PHP, Software Architecture

See more: i need a data entry job online where i don t have to pay to register, historical price data mutual funds, historical price data mutual funds 1969, psd form save data google doc spreadsheet, html form data saved google doc spreadsheet, simple spreadsheet data entry, simple chat project save chat data xmlasp net , foreclosure data spreadsheet form, excel form owc spreadsheet default save, find historical hourly stock price data, create contact details form save data visual basic, simple validation form javascript show data, joomla create form save data, simple php spreadsheet form, asp form save data csv, facileforms form save data mysql, collecting price data spreadsheet, historical price data

About the Employer:
( 2 reviews ) Plovdiv, Bulgaria

Project ID: #16137060

Awarded to:

prateeksinghv9

all work will be handled promptly and professionally. i have experience in crypto and have a google sheets portfolio tracker myself

$15 USD in 1 day
(1 Review)
0.0

11 freelancers are bidding on average $25 for this job

hemsingh1

Excel, Googlesheets expert with over 5 years of experience. Can help in delivering a solution as needed. Thanks

$35 USD in 1 day
(70 Reviews)
5.4
mahisha123

Hi, I’ve gone through your requirement . I am very much interested to work with you on this project. I do have expertise in the specified area. I can start the project right away and can complete as soon as possible. More

$25 USD in 1 day
(26 Reviews)
4.6
mvvaghela

yes i worked with google app script for spread sheet for sending emails.. so i can do this task............

$25 USD in 1 day
(10 Reviews)
3.5
abdulkarim97

Hello sir i seen your project and if you want then i can do it i will give you quality work so if you want then please message me

$25 USD in 1 day
(4 Reviews)
2.7
jalileng

A proposal has not yet been provided

$33 USD in 3 days
(1 Review)
0.0
errafiqulalam43

Hi sir/ madam we reviewed your job description and have capability to do confidently your project as your [login to view URL] are got more than 5 years of experienced in web.\app dveloping wih major project. short Projec More

$28 USD in 1 day
(0 Reviews)
0.0
$24 USD in 1 day
(0 Reviews)
0.0
attiaqamarr

I will complete your order in a perfect way within time.I will offer you unlimited revisions until you satisfied.

$25 USD in 1 day
(0 Reviews)
0.0
$20 USD in 1 day
(0 Reviews)
0.0
nayaksubhadarshi

A proposal has not yet been provided

$20 USD in 1 day
(0 Reviews)
0.0