search

chrisek / PT_Tracker

12 stars 0 forks source link

'Price that day' is not working #12

Closed m4rc3l closed 6 years ago

m4rc3l commented 6 years ago

In the Deposit all prices in that column are the same but the dates are all different.

m4rc3l commented 6 years ago

OK, got the Problem, but dont have a solution yet. Cryptofinance need it in this format: =CRYPTOFINANCE(C10&"/"&CONFIG!$C$8, "price","2017-12-07")

So I guess if you want to put in a cell number for the date, that have to be in the plain text format. When there is an error somehow, the output will give you the actual price

m4rc3l commented 6 years ago

LOL, OK... Simple as that:

The cells in the Date column have to be formated as "plain Text"
Format>Number>Plain Text

inoxi commented 6 years ago

Still not working for me... Tried your solution but price is inaccurate. Same price for two different days.

capture

m4rc3l commented 6 years ago

You can check my sheet and see if there is a difference ...

https://docs.google.com/spreadsheets/d/1VbZ96H4QN9secuA-Tw21DjGQ677f39uyuW0TPNPFSFM/edit?usp=sharing

m4rc3l commented 6 years ago

The formula has to be like this : =CRYPTOFINANCE(C8 & "/" &CONFIG!$C$8, "price", B8)

inoxi commented 6 years ago

All good now. Thank you! There are some extra spaces. My formula was =CRYPTOFINANCE(C8&"/" &CONFIG!$C$8, "price", B8) with no spaces between C8 and & and "/"

But now it's working fine. Thanks again!

chrisek commented 6 years ago

@inoxi Do you still need assistance ?

inoxi commented 6 years ago

@chrisek all good now. The formula pasted by @m4rc3l works very good.