Google Docs Spread Sheet for BTC-e and now Cryptsy

[SteveW]

Hi guys,

Now I can post in the big boys forum I thought i would share my Google Docs Spreadsheet.

I find it is great for getting a quick update on prices without having to use any of your login details so if your on a public network you can still keep track of your investments.

http://www.apoaps.com/cryptotablev2.html

As always, looking for ways to make this better.

Cheers Steve

[nahtnam]

Hi guys,

Now I can post in the big boys forum I thought i would share my Google Docs Spreadsheet.

I find it is great for getting a quick update on prices without having to use any of your login details so if your on a public network you can still keep track of your investments.

http://www.apoaps.com/cryptotable.html

As always, looking for ways to make this better.

Cheers Steve

Congrats on your new homepage. I recommend you reduce the news section because its wayyy to big and obtrusive!

[SteveW]

Just updated the spreadsheet base on some comments received, the original version is still available.

Version 2 is at:

www.apoaps.com/cryptotablev2.html

Cheers

SteveW

[nahtnam]

Just updated the spreadsheet base on some comments received, the original version is still available.

Version 2 is at:

www.apoaps.com/cryptotablev2.html

Cheers

SteveW

Nice! Does it get the latest prices or is it static?

[SteveW]

So Nahtnam,

The way it works is when you use the menu I added and go Data Collection > Update Prices it updates them, just you saying that makes me think maybe I should make the update happen whenever we open the document what do you think about that?  (This is very easy to implement just one extra line of code) The only down side is that you can't see the change in values you need to remember what it was the last time you open it, perhaps I should also add a new column that is the change in price?  (This would be a little bit harder but ultimately more useful.)

Cheers Steve

[nahtnam]

So Nahtnam,

The way it works is when you use the menu I added and go Data Collection > Update Prices it updates them, just you saying that makes me think maybe I should make the update happen whenever we open the document what do you think about that?  (This is very easy to implement just one extra line of code) The only down side is that you can't see the change in values you need to remember what it was the last time you open it, perhaps I should also add a new column that is the change in price?  (This would be a little bit harder but ultimately more useful.)

Cheers Steve

Ya. There are two possible ways I think you can handle it. If it is possible add a big blue button that says update prices, or a new column. I prefer the update prices button! If you can, you should make it so that the rows that not have been modified update.

[SteveW]

So I have included an update price button which makes it a bit easier to use as you just need to click it and the scripts will run.

[nahtnam]

So I have included an update price button which makes it a bit easier to use as you just need to click it and the scripts will run.

This is great!

[schonkeren]

Thank you for programming, I just found your project cryptotable v2.

I copied it to my google docs and pressed the update prices button.

First time I had to allow access, but no credentials were asked.

When the script almost finishes, this error appears:
TypeError: Cannot call method "split" of undefined

Also, the Quantities of cryptsy are not auto-updated, I suppose it should do that?

I have no BTC-e account active.

Also, LOT Lottocoin is not yet in the pull-down menus...

Let me know if you still support this project and if there's something I could do to make it work.

If not - thank you anyways

[SteveW]

Bugs have been fixed and new thread for v3 and new features added.

https://bitcointalk.org/index.php?topic=453419.0