Aha .. thx

=VALUE(LEFT(Index(ImportHTML("https://coinplorer.com/PTS/Addresses/<PTSaddress>","table",1),3,2),4))

Quote from: xeroc on August 08, 2014, 06:42:27 PM
Ui .. can i see it?

It may not be clean but it works.

Ui .. can i see it?

Quote from: xeroc on August 08, 2014, 06:33:44 PM
ui .. parsing html tags .. thats .. time and bandwidth consuming .. I get my price from cryptocoincharts .. the only thing 'ugly' is that i need to manually adjust balances of addresses ..

its a one-liner.
adjusting for different currency takes less than a 10sec.
bandwidth is on google , the refresh every few hours.

ui .. parsing html tags .. thats .. time and bandwidth consuming .. I get my price from cryptocoincharts .. the only thing 'ugly' is that i need to manually adjust balances of addresses ..

Quote from: xeroc on August 08, 2014, 12:40:17 PM
Hu? They have an open api now?

no but you can parse the normal site in a function and update cell contents.
I can share it once I get home.

Hu? They have an open api now?

Quote from: xeroc on August 08, 2014, 11:13:06 AM
@emski: you are related to coinplorer?

No. I just submitted a bug report and they shortly replied with that info.
I just use their service in a google docs spreadsheet function to automatically calculate all my cyptocurrencies's value. I was puzzled when it calculated way more than expected.

Quote from: emski on August 06, 2014, 02:12:18 PM
I just noticed a (significant) difference in the balance reported by my synchronized BitShares-PTS wallet and https://coinplorer.com/.
The difference is ~50% so anyone should be careful.
I believe the issue is with the coinplorer.com and the Bitshares-PTS client is OK.
I've reported the bug to coinplorer and I'll post when I know more.

Please check with this block explorer: http://ptsexplorer.cloudapp.net/chain/BitShares-PTS

@emski: you are related to coinplorer?

Their response was that due to servers upgrade some information will take time to rebuild. It should be ok soon.

coinplorer has that issue ..
doublicated transactions (you can check .. if txid is the same its one and the same tx .. but counted twice)

I just noticed a (significant) difference in the balance reported by my synchronized BitShares-PTS wallet and https://coinplorer.com/.
The difference is ~50% so anyone should be careful.
I believe the issue is with the coinplorer.com and the Bitshares-PTS client is OK.
I've reported the bug to coinplorer and I'll post when I know more.