search

emmtte / list

Google Sheets automatic creation with Google Apps Script (GAS) for managing a cryptocurrency tracking spreadsheet with multi exchanges
262 stars 77 forks source link

Sheet showing #NUM! #26

Closed Tosko4 closed 6 years ago

Tosko4 commented 6 years ago

Next to the Gains and Total value, it should show a percentage. But now it just shows #NUM!

Any idea? screenshot 2018-03-19 at 15 47 12

emmtte commented 6 years ago

Please update template sheet and main.js

Tosko4 commented 6 years ago

@ManuCart it's a newly installed Spreadsheet, I am using the latest code you provided on Github

emmtte commented 6 years ago

The latest code for template and main.js just updated for you 5 mins ago May be I'm too fast

Tosko4 commented 6 years ago

@ManuCart nope, same issue.

What i did just now:

Downloaded new template, followed the instructions you provide in your README, and still:

screenshot 2018-03-19 at 17 18 30

Update: I use the Binance API code (maybe it helps?)

emmtte commented 6 years ago

Need to put something on DEPOSIT cell. DEPOSIT is the total you spend to buy cryptos

Tosko4 commented 6 years ago

@ManuCart Alright, that I didnt do. The NUM dissapeared. But the next thing that popped up in my mind is. How does the excel sheet know how much profit I have actually made?

Lets say, 50 euro investment in a market where 1 BTC was 1000 dollar, is different than 50 euro investment when 1 BTC was 20.000 $

emmtte commented 6 years ago

It's a very simple calculation. The sheet just do a multiply with actual price by quantity for all cryptos And do a substraction from your DEPOSIT Just an indication were we are winner or loser

Tosko4 commented 6 years ago

Alright, well in that case, I raised a feature request xD You may close this issue though!