Sheet showing #NUM!

[emmtte]

Sheet showing #NUM!

[emmtte]

Please update template sheet and main.js

[Tosko4]

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

[emmtte]

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

[Tosko4]

@ManuCart nope, same issue.

What i did just now:

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

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

[emmtte]

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

[Tosko4]

@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]

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]

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