Topic: AltSheets AltFolio = AltCoin PortFolio - auto-updating spreadsheet & dataserver - page 5. (Read 19131 times)

Altcoin Newspaper Stand
edition v01 is ready



please retweet: https://twitter.com/altsheets/status/612042042110308352

AltSheets was interviewed at #supernetradio #SNRN



recording is at https://soundcloud.com/supernetradio/altsheets#t=2:48
all mentioned URLs are in the comments!

updated:

* AAsset OP
* AAssetNXT issuance info
* webpage /aassetnxt/
* twitter @AAssetNXT
* AltFolio OP
* cryptocointalk new post
* my other threads on BCT

AAssetNXT issued!



(preliminary) webpage: http://altsheets.ddns.net/aassetnxt/ with how to buy, etc.

my asset thread "[ANN][AAssetHZ/AAssetNXT] AltSheets Asset on HZ/NXT"


Please retweet this: https://twitter.com/AAssetNXT/status/608027512275378176

Bold move. Best in other venues!
https://diasp.eu/u/altsheets

Freedom!

Poll

AltCoinTraders, tell me:

Which daily routine tasks
in altcoin trading
you think could be automated,
or supported by datacollection?


Thx.

AltFolio just got better ... new version v51.

I implemented many suggestions - thanks to you, dear users!




Free trial at: http://altfolio.ddns.net/

...sorry, it was at the end of a 14 hour fully concentrated working day, until v50 was finally launched.


This is the correct link:

thx 

Please retweet:

http://altsheets.ddns.net/img/Altfolio-new-release-v50-CEO-overview.png

Thx!

New AltFolio version v50 released !

More details soon, but this is the shortest possible summary of the myriad of small and big improvements:

v50:

* 7 days price evolution images !!!
* each coin linked to WCI for more detailed charts.

* MENU ... combine rows, solves two problems at once:
** combined purchases automatically calculated average buy price
** staking results = free coins, lowering buy price

* btc-e added (e.g. NMC, PPC)
* btc-e fiat prices (5 fiatcurrencies)

* fiat conversion now not only USD but
** bitstamp USD
** btce USD EUR GBP CNH RUR

* colored instructions
* much updated instructions
* much updated history

* exchanges now alphabetically
* donations DRK --> DASH
* serialkey input: ""contact us at ...""
* one more balance column --> incremented all constants in script

* MENU ...delete one row - solves all dangers, because only safe deletes are allowed
* MENU ... insert one more row - profiling, then optimized version which is a bit faster


googlesheet frontend is ~800 lines of GoogleAppsScript code, plus the spreadsheet of course;
dataserver backend code is ~3800 lines of Python now.

---

Existing customers: See your welcome email, make a new copy of mastersheet https://docs.google.com/spreadsheets/d/1naASx..., input your serial code. Ready.

New customers: http://altsheets.ddns.net/customer/new.html

Newsflash:



Soon there will be little 7 days price images for each coin in AltFolio !

New Design of the Homepage:
intermediate ... Photo Backgrounds



I have now put some of my own photographs into the backgrounds of most pages ...

... check them out: http://altsheets.ddns.net


And the other happy news is:

• this is only intermediate, temporary
• because a gifted designer is starting to work on the pages.

 

This is the present version of AltFolio:

This is conceivable for a future version:
(for security/trust issues, also see this posting).


And now, with this recent breakthrough ...

... I have today done the first baby step into that direction.

Much work because every exchange API is a little different. But me, I wanted to see how to do it - so here is a small preview, I have finished the first one, bittrex.

Sample output:

~0.4252 BTC:     361.2002 COV     @ 0.00117716 BTC/coin (not-in-orders     124.6582, pending       0.0000)
~0.2603 BTC:   16796.7700 QTL     @ 0.00001550 BTC/coin (not-in-orders    8600.7800, pending       0.0000)
~0.1091 BTC:   15585.9375 NIRO    @ 0.00000700 BTC/coin (not-in-orders   15585.9375, pending       0.0000)
~0.0657 BTC:   69879.0000 BAY     @ 0.00000094 BTC/coin (not-in-orders   69879.0000, pending       0.0000)
~0.0001 BTC:   10000.0000 ECASH   @ 0.00000001 BTC/coin (not-in-orders   10000.0000, pending       0.0000)

Yes, QTL has crossed the 1500 Satoshi price, first time in ages. Wondering when the next Quatloo Trader version comes out. Who believes in NIRO?
I don't know why I still keep on hodling my BAY ... the hot coin at the moment definitely COV! N.B.: Do your own research. Trading can mean loosing all.

Now, getting this information automatically onto my dataserver is a big step, but only half of the game - how to get the results into the AltFolio GoogleSheet is another challenge. Plus your APIsecret is so hypersensitive, that it needs quite some more caution from the user's side, too. Just to be 100% clear --> I might not implement this into AltFolio in the near future.

AltFolio is already quite functional in the current version. Input all your coin balances once manually is a few minutes - the later updates take only seconds.

--> Get your free trial today.

Successful 1st attempt at privateAPI access, on all 3 exchanges:

My "MJcoins April 2015" results, automatically compiled:


output:

CCN
( 2 trades)   poloniex -0.10452381 btc  +3127.9603 altcoin
( 6 trades)    bittrex +0.04171401 btc  -3127.9503 altcoin
             combined: -0.06280980 btc     +0.0100 altcoin

POT
(16 trades)    cryptsy -0.10503751 btc  +22428.5586 altcoin
( 5 trades)   poloniex +0.05097084 btc  -11814.6141 altcoin
( 5 trades)    bittrex +0.04923291 btc  -10613.8925 altcoin
             combined: -0.00483376 btc     +0.0520 altcoin

CANN
( 2 trades)    cryptsy +0.00846980 btc     +0.0000 altcoin
( 7 trades)    bittrex +0.03487244 btc     +0.0000 altcoin
             combined: +0.04334224 btc     +0.0000 altcoin

STV
( 7 trades)    bittrex +0.07293827 btc  -7502.9194 altcoin
             combined: +0.07293827 btc  -7502.9194 altcoin

THC
( 7 trades)    bittrex -0.02818735 btc     +0.0000 altcoin
             combined: -0.02818735 btc     +0.0000 altcoin

MARYJ
( 2 trades)    bittrex +0.07378937 btc  -2999.7999 altcoin
             combined: +0.07378937 btc  -2999.7999 altcoin

DOPE
( 6 trades)    bittrex +0.02630784 btc     +0.0000 altcoin
             combined: +0.02630784 btc     +0.0000 altcoin


BTC results, gathered from cryptsy, poloniex, and bittrex:
  CCN: -0.06280980 BTC
  THC: -0.02818735 BTC
  POT: -0.00483376 BTC
 DOPE: +0.02630784 BTC
 CANN: +0.04334224 BTC
  STV: +0.07293827 BTC
MARYJ: +0.07378937 BTC

BTC total:
0.120546814


EDIT: newer version 23/4/2015 = print #trades; only show when #trades>0; cleaning up sourcecode


All trading fees are already included. The small amounts (like "+0.0100 altcoin") are withdrawal fees when I transferred coins from one exchange to the other.

As you can see above, I had some STV and MARYJ still lying around, which I had probably bought on ccex, long ago (and ccex is not implemented yet). Really happy to have finally been able to sell them. Subtract circa 0.06 BTC for those ...

... and I end up with an amazing 13 dollars plus in total :-) At least not a minus, which considering the big losses in CCN is actually a surprise to me. I had bought CCN much too late, when it was already expensive, and then I did not sell them early enough.

Looks like 410 is the new 420.


Anyways, the main message of the above is not "Yey, profits!" ... but that I have started my first quickNdirty attempts at parsing the privateAPI output now. Of course, it only works when I provide my personal APIkey and APIsecret for each of the exchanges.

Now really useful helper software becomes possible. Automatic profit calculations, and even across exchanges - pretty cool, ain't it?  

I am not sure yet how to call this module. Work in progress name is "tradesgetter.py", but probably it should better be called "privapi.py".

new giveback license v03 - http://altsheets.ddns.net/give/

"Stacked".
i.e. at each x-position, all the y-positions are added up, on top of each other.

In this type of graph, you can easily see how much these 7 coins moved in unisono. If all peaks had been at the exact same moment, then the maximum would have been 7 = 700%

yes, exactly. All true.

OK, got it, sorry for misunderstanding - but again a thing which you can make easily clear to users. If they want to give you that trust, is another thing. If it would be an option, they could choose. Maybe just manually putting in the required password each time they want to. And if they later distrust your software with that, maybe it is possible for them to just change the pass at Poloniex?

Interesting graphs, how did you do the second one? I don't seem to understand this (I understand the first).