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

[idiomatik]

good work 
reserved

[altsheets]

good work 

Thanks, it was a lot of fun doing it too.

Anyone who wants a free trial, PM me!

[altsheets]

DEV UPDATE

Just an update on some of the activities outside this "AltFolio Software" thread 978804:

• you can like my facebook fanpage
  - two of my postings: in CCC and in the MultiCoinTipping group - please you leave comments there.
  - beautiful user review of my software!
  - lots of fb PMs (and emails which I prefer), of new users trying out my software. GET YOUR FREE TRIAL NOW (PM ME here in BCT)
• The newly started twitter account already gets quite some followers, favoriting, and even retweets.
• Suggestions for you retweeting my message are on the first page of this thread.
  
  
• nxtforum topic 8580: I am parsing the asset markets, writing my own software for that!
• bitcointalk HZ thread posting
  #1133: which could perhaps also be sold.
• #1084: and with it, I even already found a bug!
• #1147: and could identify odd situations ...
  
  
• I will parse all assets in HZ (and NXT) markets,
  to prepare my own asset launch in the best possible way.
  See my AltSheets AltFolio Asset (AAA) thread 981128.
  

[altsheets]

Please retweet: https://twitter.com/altsheets/status/578620265376190464 Thx ;-)

[altsheets]

The BitcoinGarden twitter invited me to BitcoinGarden.tk to present my product there.

... and tweeted about it, which is causing quite some retweets. Very happy!

(TODO: Screenshot)

[altsheets]

On diaspora now (diasp.eu pod): https://diasp.eu/people/84e1e620b16d01321e8f5404a6b20780

[altsheets]

assetparser.py
Make sure you have all the available information  before  you invest into an asset.

I have created an assetparser.py to analyze the existing asset markets on HZ and NXT.
It is intended to help me to analyze the situation better when creating my own asset.


The first results are out there, in form of a teaser table. May this information be useful for your trading!


retweet please: https://twitter.com/altsheets/status/579393281290829824 Thx ;-)

[altsheets]

Bitcointalk Signature Bonus

add

ALTcoin portFOLIO: with auto-updated prices and coinmarketcap data - try #altsheets 'AltFolio' for free

or (if you are a newbie and cannot have longer signatures)

try #altsheets AltFolio for free

to your bitcointalk signature - and earn weeks of serial code validity for AltFolio.

[altsheets]

A new tweet:



https://twitter.com/altsheets/status/579841306698080256 - please retweet this useful picture.


Play with compound interest ... in my interactive funproject GoogleSheet "YachtCalculator":

--> http://2020.fm/yachtcalculator ... Menu ... File ... Make a copy ...
(you have to be logged into your gmail/googleaccount to use googlesheets)

[altsheets]

new tweet: assetparser last mystery solved


https://twitter.com/altsheets/status/581270222348398592

[altsheets]

.
----------------


Horizon Asset launched
asset id: 8101260088962758269
"AAssetHZ" = 'Altsheets ASSET on HoriZon'

quantity: 5,000,000 (5 million)
decimals: 0 (whole shares are traded)

launched: 2015 March 28th
issued by: NHZ-XDWX-VLTM-FUFZ-CTT54 (alias 'AAssetHZissuer')

Description:

AAssetHZ is the first AltSheets Asset on Horizon. 5,000,000 AAssetHZ shares are issued, representing 5% of all future profits of AltSheets software (like AltFolio - the auto-updating altcoin portfolio solution; and assetparser.py - which compares all assets in many observables, and works on two platforms). Objectives of AAssetHZ are: To develop and improve software, to finance marketing to increase sales - and to reward investors by sharing 1% of all profits from the #AltSheets software sales per each 1,000,000 AAssetHZ; paid as regular dividends to AAssetHZ holders. Check asset ID and issuer ID (NHZ-XDWX-VLTM-FUFZ-CTT54) before trading, there may be copycat assets! Buyers please convey an email address for updates. More infos at http://AAssetHZ.ddns.net and twitter @AAssetHZ


----------------
more info: "[ANN][AAssetHZ] AltSheets Asset on HoriZon - newtoday - software profits sharing"
how to buy:  "how to buy assets on horizon - the complete process, explained for newbies"


.

[altsheets]

Today:

25 bitcointalk postings (TWNTYFVE)
2 bitcointalk PMs
1 email, only? Strange.
NO TWEET. I didn't tweet today, what's wrong?
4 facebook chats, 2 of them really long
1 group chat session
1 hour of marketing research
2 new googledocs
1 coinmarketcap submission
1 data source problem solved fabulously, using 3 different channels
1 closed thread :-)


Good night, everybody!

[altsheets]

good argument:

with AltFolio I check the price charts less often than before

[altsheets]

Thanks to the buyers of #AAssetHZ,
we can now afford paid marketing.

Here are preliminary banners, linked to the preliminary landing pages:


AltFolioBanner01.png  --> dedicated landing page --> get trial serial

AAssetHZ_logo_250x250  --> bitcointalk "how to buy assets ..., example: 8101260088962758269 ..."

AltFolio_logo_250x250.png (not final!)  --> dedicated landing page --> get trial serial


Please give feedback!

Thx.


P.S.: Have a look at the very first banner advertising on cryptocoincharts.info

[altsheets]

AltFolio - possible extension: Asset prices

If you can get the asset price from servers like http://coinmarketcap.com/assets/ , then maybe it's possible to integrate assets also into your altsheets portfolio sheet? Then it would offer a nice overwiev over assets and coins. Would be cool   .

Yes, for sure, asset inclusion is definitely planned for one of the next versions.

I have already put considerable time into studying the API, and how to do it.  By the way, a fun fact: That was my original intention, to just get the last-price out of the Nxt/HZ platform API, and pull that data into AltFolio ... which made me look so much deeper, that a whole new product came out of it (assetparser.py) in the end. I wanted just prices, and got the whole asset marketplace ;-)


For HZ&Nxt I don't even have to go through aggregators like CMC, because by now I know the Nxt/HZ well enough to extract directly what I need.

Now I just have to take the time to program (and then debug :-) ) it.

Open question: Design how?

What I still don't know is how to handle the suddenly more base currencies.
Because Horizon assets are traded in HZ, counterparty assets in XCP, etc. - and the asset owners know their prices, but only in that base currency.


At the moment my frontend is all done in BTC.
(Plus one dollar column, just to offer an intuitive number.)

But imagine, we will have HZ, and NXT, and MSC, and XCP, and XAI ... and now NEM, for all the asset marketplaces.
That would cause more columns, and clutter up the interface a lot.

I am almost decided to internally recalculate all asset prices to BTC.
That however, is going against the intuition of the "I only look at one platform" people.

But other sites have started to to that too, at least with volume.

Open question for me, really:
Continue to base everything in BTC (and let my dataserver handle all such complications - just return a BTC price, regardless);
or add more columns into the frontend, for all the new base currencies ? ? ?


coin and asset acronyms

P.S.: I just saw that the assets seem to have an abbreviation/symbol like the coins (e.g. the asset Supernet has the symbol "UNITY").

Yes, and I have just done this here for you:

Code:

$MINE, $MINEW, $MINEZ, 10K, 42, 66, ABC2, ABY, AC, ACH, ACOIN, ADD, ADN, AGS, AID, ALF, ALI, ALN, AM, AMBER, AMC, 
ANAL, ANC, APC, APEX, ARCH, ARG, ARI, ASC, ASN, ATOMIC, AU, AUR, AXR, BALLS, BANX, BAT, BAY, BBR, BCENT, BCF, BCN, BCR, 
BCX, BDC, BDSM, BEAR, BEL, BELA, BEN, BET, BGR, BILS, BITB, BITBTC, BITCNY, BITGOLD, BITS, BITSILVER, BITUSD, BITZ, BLC, 
BLK, BLOCK, BLU, BNCR, BOB, BOOM, BOST, BQC, BRIT, BSTY, BTB, BTC, BTCD, BTCRY, BTCS, BTE, BTG, BTM, BTMI, BTQ, BTS, 
BUK, BUN, BURST, BVC, BYC, C2, CACH, CAGE, CAIx, CAM, CANN, CAP, CASH, CAT, CATC, CBX, CCC, CCN, CCS, CDN, CELL, CENT, 
CESC, CFC2, CFN, CGA, CHA, CHASH, CHILD, CIN, CINNI, CKC, CLAM, CLOAK, CLR, CNC, CND, CNL, CNMT, COINO, COL, COMM, 
CON, COOL, CORG, CRACK, CRAIG, CRAVE, CRC, CRT, CRW, CRYPT, CSC, CSD, CTM, CURE, CV2, CXC, CYC, CZC, CZR, DARK, 
DASH, DBL, DEBUNE, DEM, DEX, DGB, DGC, DGD, DICE, DIEM, DIG, DIME, DMD, DOGE, DOGED, DON, DOPE, DORCS, DOT, DP, 
DRKC, DRS, DSB, DSH, DT, DTC, DUCK, DVC, EAC, EAGS, ECASH, ECC, EFL, ELC, ELP, ELT, EMC2, EMD, ENRG, ERM, ETC, 
EUPH, EVENT, EXCL, EXE, EZC, FAIL, FAIR, FC2, FCN, FETISH, FFC, FIBRE, FIMK, FLAP, FLDC, FLO, FLT, FOOD, FRAC, FRC, FRK, 
FRSH, FSC2, FST, FTC, GAIA, GAP, GB, GCN, GDC, GDN, GEMZ, GEO, GHC, GIVE, GLC, GLD, GLIDE, GLYPH, GMC, GME, GML,
GNS, GOOD, GP, GRC, GRCX, GRE, GRID, GRN, GRS, GSM, GSX, GUA, GUE, GUN, HAL, HAM, HBN, HEX, HIRO, HLC, HRL, 
HRNXT, HTML5, HUC, HVC, HYP, HYPER, HZ, I0C, ICASH, ICB, ICN, IFC, ILT, IOC, IPC, IXC, J, JBS, JINN, JKC, JLH, JPC, JUDGE, 
KARM, KDC, KEY, KGC, KOBO, KORE, KRN, KRYP, KTK, KUMA, LAB, LDOGE, LEAF, LGD, LIMX, LIQUID, LIT, LKY, LMR, LOG, 
LOT, LSD, LTB, LTBC, LTC, LTCD, LXC, LYC, MAC, MACD, MAIA, MAID, MAL, MARYJ, MAX, MCN, MCZ, MEC, MED, MEM, MEOW, 
METAL, MGW, MIL, MIN, MINT, MLS, MMC, MMNXT, MMXIV, MNC, MNE, MNTA, MONA, MOON, MRC2, MRKT, MRS, MRY, MSC, 
MTC, MTR, MUE, MWC, MYR, MYST, MZC, NAN, NAS, NAUT, NAV, NBE, NBL, NBT, NEC, NEM, NEOS, NET, NKA, NKT, NLG, 
NMB, NMC, NOBL, NODE, NOO, NOTE, NOXT, NRB, NRS, NSR, NTC, NTR, NVC, NXE, NXT, NXTcoinsco, NXTI, NXTMOVIE, 
NXTprivacy, NXTSCO, NXTTY, NXTV, NYAN, NYC, OC, OCTO, OCUPY, OMA, OMC, OPAL, OPALTKN, ORB, ORO, OSC, PANGEA, 
PEN, PFC, PHO, PHS, PIGGY, PIMP, PINK, PLANET, PLC2, PLNC, PMP, PND, POP, POT, POW, PPC, PRC, Privatebet, PROZ, PRT, 
PSEUD, PTC, PTS, PXC, PXI, PYC, QB, QBK, QCN, QORA, QRK, QSLV, QTL, QUIT, RBBT, RBR, RBT, RBY, RDD, RED, RIC, RIN, 
RIPO, RISK, ROOT, ROS, ROX, RPC, RT2, RZR, SAK, SAT2, SBC, SCSY, SDC, SEED, SF0, SFR, SHA, SHADE, SHIBE, SHLD,
SILK, SJCX, SKC, SKYNET, SLFI, SLG, SLM, SLR, SMAC, SMBR, SMC, SMLY, SOL, SOLE, SONG, SOON, SPA, SPHERE, SPR,
SPT, SPUDS, SRC, SSD, SSV, START, STK, STR, STV, SUPER, SWARM, SWIFT, SXC, SYNC, SYS, TAC, TAG, TAK, TCO, 
TECH, TEK, TES, TGC, THC, TIPS, TIT, TIX, TOP, TOR, TRC, TRI, TRICK, TRK, TRL, TRUST, TTC, TTY, TWIST, U, UCI, UFO,
UIS, ULTC, UNAT, UNB, UNC, UNITY, UNO, URC, URO, UROD, USDe, USDT, UTC, UTIL, VCOIN, VDO, VGC, VIA, VIOR, 
VMC, VNL, VOOT, VOYA, VPN, VRC, VTA, VTC, VTR, VTX, VULT, WATER, WBB, WDC, WETK, WKC, WLF, WOC, XAI, XAP, 
XAU, XBC, XBOT, XBS, XC, XCASH, XCH, XCN, XCO, XCP, XCPSCO, XCR, XDE, XDN, XDP, XDQ, XEM, XGR, XJO, XLB, 
XMG, XMR, XNC, XPB, XPD, XPL, XPM, XPY, XQN, XRC, XRP, XSI, XSL, XST, XTC, XTR, XWC, XWT, XXX, YAC, YBC, 
YUM, ZCC, ZED, ZEIT, ZET, ZIRK, ZRC, ZS

All these should be accepted - by the coinmarketcap columns generator. I have not compared them yet against all 51 assets that CMC is supporting - are they all in there?

So is it just possible to fill in the symbol in your sheet and then the asset will be treated like coin in the spreadheet?

Yes, should be, please report back what you find out!


All feedback very welcome, always.

Then my request would be unnecessary.

Not at all. Please continue to ask.

I hope I now finally find the time to go through you suggestions in your long email. Can I publish my answers publicly? Thanks!

Just fill in the letters and that would be it.

Jep. Please you try that out.

Plus we have to get last-price data for the assets. I could allow "cmc" in the "get-price-from" column (orange column decides about --> first green column).

[altsheets]

New AltFolio Banner "Skyscraper 120x600"




altsheets.ddns.net/img/AltFolioSkyscraperBanner01.png
--> dedicated landing page
--> get trial serial

[altsheets]

Earn crypto with adspace on your website - really easy now!

I checked all the sites which have adspaces for nxtad.
Some sites are rubbish faucet banner graveyards, but
some of them high quality sites. For now, I advertise on these:

http://www.cryptocoincharts.info (!)
http://freenxt.org
http://coincreator.de
http://www.cryptoblog.org.uk
http://doge.br22.com
http://www.bitcoinfacile.it
http://www.bestfaucetsfor.me/

I would love to advertise on more & better sites, and
preferably with the beautifully implemented NXTAD system.
It even accepts deposits of NXT, BTC, BTCD, DASH, LTC, and DOGE now.

If you know website owners - please tell them how easy NXTAD is to implement!

- Register. Add your website to a list. Create ad space = some HTML code is generated. Put that into your page. Done.
- Within ~1 hour, your website can make money.
- Then tell me, and I will book my banners onto your site!

[Hubus]

That would cause more columns, and clutter up the interface a lot.

Open question for me, really:
Continue to base everything in BTC (and let my dataserver handle all such complications - just return a BTC price, regardless);
or add more columns into the frontend, for all the new base currencies ? ? ?

I don't know if I understand. What about one column with the original coincurrence and one for BTC (+ US $ and €     ).

Yes, and I have just done this here for you:

Code:

$MINE, $MINEW, $MINEZ, 10K, 42, 66, ABC2, ABY, AC, ACH, ACOIN, ADD, ADN, AGS, AID, ALF, ALI, ALN, AM, AMBER, AMC, 
ANAL, ANC, APC, APEX, ARCH, ARG, ARI, ASC, ASN, ATOMIC, AU, AUR, AXR, BALLS, BANX, BAT, BAY, BBR, BCENT, BCF, BCN, BCR, 
BCX, BDC, BDSM, BEAR, BEL, BELA, BEN, BET, BGR, BILS, BITB, BITBTC, BITCNY, BITGOLD, BITS, BITSILVER, BITUSD, BITZ, BLC, 
BLK, BLOCK, BLU, BNCR, BOB, BOOM, BOST, BQC, BRIT, BSTY, BTB, BTC, BTCD, BTCRY, BTCS, BTE, BTG, BTM, BTMI, BTQ, BTS, 
BUK, BUN, BURST, BVC, BYC, C2, CACH, CAGE, CAIx, CAM, CANN, CAP, CASH, CAT, CATC, CBX, CCC, CCN, CCS, CDN, CELL, CENT, 
CESC, CFC2, CFN, CGA, CHA, CHASH, CHILD, CIN, CINNI, CKC, CLAM, CLOAK, CLR, CNC, CND, CNL, CNMT, COINO, COL, COMM, CON, 
COOL, CORG, CRACK, CRAIG, CRAVE, CRC, CRT, CRW, CRYPT, CSC, CSD, CTM, CURE, CV2, CXC, CYC, CZC, CZR, DARK, DASH, DBL, DEBUNE, 
DEM, DEX, DGB, DGC, DGD, DICE, DIEM, DIG, DIME, DMD, DOGE, DOGED, DON, DOPE, DORCS, DOT, DP, DRKC, DRS, DSB, DSH, DT, DTC, 
DUCK, DVC, EAC, EAGS, ECASH, ECC, EFL, ELC, ELP, ELT, EMC2, EMD, ENRG, ERM, ETC, EUPH, EVENT, EXCL, EXE, EZC, FAIL, FAIR, FC2, 
FCN, FETISH, FFC, FIBRE, FIMK, FLAP, FLDC, FLO, FLT, FOOD, FRAC, FRC, FRK, FRSH, FSC2, FST, FTC, GAIA, GAP, GB, GCN, GDC, GDN, 
GEMZ, GEO, GHC, GIVE, GLC, GLD, GLIDE, GLYPH, GMC, GME, GML, GNS, GOOD, GP, GRC, GRCX, GRE, GRID, GRN, GRS, GSM, GSX, GUA, 
GUE, GUN, HAL, HAM, HBN, HEX, HIRO, HLC, HRL, HRNXT, HTML5, HUC, HVC, HYP, HYPER, HZ, I0C, ICASH, ICB, ICN, IFC, ILT, IOC, IPC, IXC, 
J, JBS, JINN, JKC, JLH, JPC, JUDGE, KARM, KDC, KEY, KGC, KOBO, KORE, KRN, KRYP, KTK, KUMA, LAB, LDOGE, LEAF, LGD, LIMX, LIQUID, LIT, 
LKY, LMR, LOG, LOT, LSD, LTB, LTBC, LTC, LTCD, LXC, LYC, MAC, MACD, MAIA, MAID, MAL, MARYJ, MAX, MCN, MCZ, MEC, MED, MEM, MEOW, 
METAL, MGW, MIL, MIN, MINT, MLS, MMC, MMNXT, MMXIV, MNC, MNE, MNTA, MONA, MOON, MRC2, MRKT, MRS, MRY, MSC, MTC, MTR, MUE, 
MWC, MYR, MYST, MZC, NAN, NAS, NAUT, NAV, NBE, NBL, NBT, NEC, NEM, NEOS, NET, NKA, NKT, NLG, NMB, NMC, NOBL, NODE, NOO, NOTE, 
NOXT, NRB, NRS, NSR, NTC, NTR, NVC, NXE, NXT, NXTcoinsco, NXTI, NXTMOVIE, NXTprivacy, NXTSCO, NXTTY, NXTV, NYAN, NYC, OC, OCTO, 
OCUPY, OMA, OMC, OPAL, OPALTKN, ORB, ORO, OSC, PANGEA, PEN, PFC, PHO, PHS, PIGGY, PIMP, PINK, PLANET, PLC2, PLNC, PMP, PND, POP, 
POT, POW, PPC, PRC, Privatebet, PROZ, PRT, PSEUD, PTC, PTS, PXC, PXI, PYC, QB, QBK, QCN, QORA, QRK, QSLV, QTL, QUIT, RBBT, RBR, RBT, 
RBY, RDD, RED, RIC, RIN, RIPO, RISK, ROOT, ROS, ROX, RPC, RT2, RZR, SAK, SAT2, SBC, SCSY, SDC, SEED, SF0, SFR, SHA, SHADE, SHIBE, 
SHLD, SILK, SJCX, SKC, SKYNET, SLFI, SLG, SLM, SLR, SMAC, SMBR, SMC, SMLY, SOL, SOLE, SONG, SOON, SPA, SPHERE, SPR, SPT, SPUDS, 
SRC, SSD, SSV, START, STK, STR, STV, SUPER, SWARM, SWIFT, SXC, SYNC, SYS, TAC, TAG, TAK, TCO, TECH, TEK, TES, TGC, THC, TIPS, 
TIT, TIX, TOP, TOR, TRC, TRI, TRICK, TRK, TRL, TRUST, TTC, TTY, TWIST, U, UCI, UFO, UIS, ULTC, UNAT, UNB, UNC, UNITY, UNO, URC, URO, 
UROD, USDe, USDT, UTC, UTIL, VCOIN, VDO, VGC, VIA, VIOR, VMC, VNL, VOOT, VOYA, VPN, VRC, VTA, VTC, VTR, VTX, VULT, WATER, WBB, 
WDC, WETK, WKC, WLF, WOC, XAI, XAP, XAU, XBC, XBOT, XBS, XC, XCASH, XCH, XCN, XCO, XCP, XCPSCO, XCR, XDE, XDN, XDP, XDQ, XEM, 
XGR, XJO, XLB, XMG, XMR, XNC, XPB, XPD, XPL, XPM, XPY, XQN, XRC, XRP, XSI, XSL, XST, XTC, XTR, XWC, XWT, XXX, YAC, YBC, YUM, ZCC, 
ZED, ZEIT, ZET, ZIRK, ZRC, ZS

All these should be accepted - by the coinmarketcap columns generator. I have not compared them yet against all 51 assets that CMC is supporting - are they all in there?

Wow, very nice advancement, thank you! (Well, I hope the sales will thank you... and then your asset will thank me...      ).

So is it just possible to fill in the symbol in your sheet and then the asset will be treated like coin in the spreadheet?

Yes, should be, please report back what you find out!
...
Jep. Please you try that out.

Will try it out and be back when I find the time...

I hope I now finally find the time to go through you suggestions in your long email. Can I publish my answers publicly? Thanks!

Well, I don't know if it's good to make everything public when you want to sell something and get the money alone, it might imply the danger of being copied. On the other hand, a completely closed system is also difficult. If you keep rewarding the people who help you, it's OK, but if it's copied, I don't know if you can sell enough... difficult, but decide as you wish, it's your business, I only own some little bit of your assets...

Have a nice day!

[Hubus]

I checked all the sites which have adspaces for nxtad.

If you know website owners - please tell them how easy NXTAD is to implement!

...please more info about NXTAD, link?

[altsheets]

I checked all the sites which have adspaces for nxtad.
If you know website owners - please tell them how easy NXTAD is to implement!

...please more info about NXTAD, link?

http://lmgtfy.com/?q=nxtad  

How does it work? Look at my asset info page for example: http://AAssethz.ddns.net
On the very right there is this banner space. Hover over the "ad" on the top left, then
press "Advertise here". There you can register. To advertise. Or as a website owner.

Why not try it out, just for learning it? Perhaps make a banner for your asset poll thread,
and advertise it for a few cents, to see how it works, and to see what happens then.

It's an elegantly implemented system.