Feed Statistics

[wasthatawolf]

Looks like there's an issue with the feed from bitsharesblocks.com so I stopped the trigger from updating any further.  There's just about a weeks worth of data.

@Bytemaster - let me know if you think this Google Sheet and script is useful and I can send you over the original project.

What's the issue? Seems to be working for me.

BTC and GOLD feeds are missing, http://joelooney.org/btsblocks/test.php

Indeed, found an issue and fixed it, should work now.

Great!  I've started collecting data again in a new spreadsheet...

https://docs.google.com/spreadsheets/d/170QMcBj35e84h3TMogo61fFIeeCpZ7T57TS9fDvRP1k/edit?usp=sharing


Last week's data can be found here:
https://docs.google.com/spreadsheets/d/1gkXcRmpxFXv485A4ppIC0meG7DRyjBu8hQnpj6nuNxE/edit?usp=sharing

[Mysto]

Love the stats 

[Mysto]

Your graph is flipping us off. I hope that's not an omen 

LOL I died! XD

[CLains]

Love the stats 

[santaclause102]

This is great data and shows the feed can be off by up to 2% in either direction (so far).

Can that be a problem (in that traders or shorters could profit from this without risk) or does the feed only serve as rails here to not allow to short bitusd to zero?

[svk]

Looks like there's an issue with the feed from bitsharesblocks.com so I stopped the trigger from updating any further.  There's just about a weeks worth of data.

@Bytemaster - let me know if you think this Google Sheet and script is useful and I can send you over the original project.

What's the issue? Seems to be working for me.

BTC and GOLD feeds are missing, http://joelooney.org/btsblocks/test.php

Indeed, found an issue and fixed it, should work now.

[wasthatawolf]

Looks like there's an issue with the feed from bitsharesblocks.com so I stopped the trigger from updating any further.  There's just about a weeks worth of data.

@Bytemaster - let me know if you think this Google Sheet and script is useful and I can send you over the original project.

What's the issue? Seems to be working for me.

BTC and GOLD feeds are missing, http://joelooney.org/btsblocks/test.php

[svk]

Looks like there's an issue with the feed from bitsharesblocks.com so I stopped the trigger from updating any further.  There's just about a weeks worth of data.

@Bytemaster - let me know if you think this Google Sheet and script is useful and I can send you over the original project.

What's the issue? Seems to be working for me.

[wasthatawolf]

Looks like there's an issue with the feed from bitsharesblocks.com so I stopped the trigger from updating any further.  There's just about a weeks worth of data.

@Bytemaster - let me know if you think this Google Sheet and script is useful and I can send you over the original project.

[wasthatawolf]

Calculated min and max feed to market price variances based on this past week's data...

https://docs.google.com/spreadsheets/d/1gkXcRmpxFXv485A4ppIC0meG7DRyjBu8hQnpj6nuNxE/pubhtml?gid=813917438&single=true

[wasthatawolf]

I've created live normal distribution curves for both BTC and USD data sets... 

BTC - Normal Distribution Curve
https://docs.google.com/spreadsheets/d/1gkXcRmpxFXv485A4ppIC0meG7DRyjBu8hQnpj6nuNxE/pubchart?oid=587515421&format=interactive

USD - Normal Distribution Curve
https://docs.google.com/spreadsheets/d/1gkXcRmpxFXv485A4ppIC0meG7DRyjBu8hQnpj6nuNxE/pubchart?oid=421419303&format=interactive

[bytemaster]

This is great data and shows the feed can be off by up to 2% in either direction (so far). 

[wasthatawolf]

Thanks to @svk I have a much more reliable data feed from the BTS blockchain.  I've also modified the price feed from Coinmarketcap.  The two feeds now capture live data every 5 minutes within seconds of one another.

I've reset the data and it's now running comparison data for BTC and USD.

BTC live histogram
https://docs.google.com/spreadsheets/d/1gkXcRmpxFXv485A4ppIC0meG7DRyjBu8hQnpj6nuNxE/pubchart?oid=313553473&format=interactive

USD live histogram
https://docs.google.com/spreadsheets/d/1gkXcRmpxFXv485A4ppIC0meG7DRyjBu8hQnpj6nuNxE/pubchart?oid=805422327&format=interactive

Data
https://docs.google.com/spreadsheets/d/1gkXcRmpxFXv485A4ppIC0meG7DRyjBu8hQnpj6nuNxE/edit?usp=sharing

[wasthatawolf]

Here's a link to the live chart, updated every 5 min:
 
https://docs.google.com/spreadsheets/d/1gkXcRmpxFXv485A4ppIC0meG7DRyjBu8hQnpj6nuNxE/pubchart?oid=313553473&format=interactive

Last 24hrs...

[wasthatawolf]

Good job! I'll see if i can get a feed going tomorrow for you cause that scraper is throwing off my google analytics stats..

Sweeeet, my wishlist for the API is...

-current median price feed for BitBTC and BitUSD
-current bid and ask for BitBTC and BitUSD