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