AltSheets AltFolio = AltCoin PortFolio - auto-updating spreadsheet & dataserver

[altsheets]

Which MJcoins will pump for 420 - what is your guess?

But in the history of the coins the 20th Oct. seems to be more significant.

yes, the October 2014 data is clear. All 7 MJcoins pumped ... until just before 20/10/2014.
April 2014 not so clear. But that is probably mainly because on 2014 April 20th, some were still young, or did not existed at all.

the 20th Oct. seems to be more significant.
However, I would like to understand this as well, I did not find any hint on that.  

Me too. I understand '420'.
But where did a '1020' collective pump come from? Anyone?

I have just crossposted to the What is the Best MJ Coin? thread - perhaps someone will tell us.

[altsheets]

I had another look at October 20th:





... are both linking to the now new page http://altsheets.ddns.net/altprices .

[Hubus]

the 20th Oct. seems to be more significant.
However, I would like to understand this as well, I did not find any hint on that.  

Me too. I understand '420'.
But where did a '1020' collective pump come from? Anyone?

I have just crossposted to the What is the Best MJ Coin? thread - perhaps someone will tell us.

Good idea, we have the answer:

It was all due to the CANN whales pumping it when the first dispensary started accepting CANNdy for crypto on Oct. 20 2014.

http://cointelegraph.com/news/112748/cannabiscoin-officially-redeemable-for-1-gram-starting-october-20-interview-with-founder

If it is still 1 CANN = 1 g of cannabis, then cannabis seems to be cheap?

[Hubus]

I had another look at October 20th:





... are both linking to the now new page http://altsheets.ddns.net/altprices .

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

[Hubus]

I am not sure if I understood everything. Would that give the user full control over your sheet?

No, different story, completely different. The other way around - it would give me some control, over their trading account.
If you give me your poloniex API key & secret, I can get your current coin balances
--> import them into AltFolio.future.version, all done fully automatic. Coin balances would update as soon as you buy or sell coins.

Did I get it right? Would this give you COMPLETE CONTROL over the user's account, meaning you could withdraw coins from there?

No.

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?

[altsheets]

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?

yes, exactly. All true.

[altsheets]

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

"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%

[altsheets]

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

[altsheets]

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".

[altsheets]

This is the present version of AltFolio:

PrivateAPI access is NOT part of the current AltFolio version. Coin balances are updated manually.

This is conceivable for a future version:

If you give me your poloniex API key & secret, I can get your current coin balances
--> import them into AltFolio.future.version, all done fully automatic.
Coin balances would update as soon as you buy or sell coins.

(for security/trust issues, also see this posting).


And now, with this recent breakthrough ...

Successful 1st attempt at privateAPI access ...be called "privapi.py".

... 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.

[altsheets]

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.

 

[altsheets]

Newsflash:



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

[altsheets]

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

yiehah!

[altsheets]

Please retweet:

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

Thx!

[altsheets]

...

Please retweet:

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

Thx!

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


This is the correct link:

Please retweet:
https://twitter.com/altsheets/status/600483858950270976

thx 

[altsheets]

AltFolio just got better ... new version v51.

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




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

[altsheets]

Poll

AltCoinTraders, tell me:

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


Thx.

[altsheets]

Freedom!

[mavigro]

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

[altsheets]

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