Bitcoin Forum

news 2016 January 13th: new 2016 price scheme (https://bitcointalk.org/index.php?topic=978804.msg13542852#msg13542852) for AltFolio DataServer 2015 November 8th: (https://bitcointalk.org/index.php?topic=978804.msg12921413#msg12921413) New product released! AssetGraphs-v2 --------------------------------------------------------------------------- Altcoin Portfolio Overview Sheets AltSheetsAltfolio = daily helper for Altcoin traders = frontend: GoogleSheets: configurable = backend: data collection server: fast, async = new innovative product, free trial, cheap licences I announce a new service, and here is the free trial (http://altfolio.ddns.net). Some direct links into postings about: "my story" (#2) (https://bitcointalk.org/index.php?topic=978804.msg10683813#msg10683813) screenshots (#3) (https://bitcointalk.org/index.php?topic=978804.msg10683878#msg10683878) videos: (https://bitcointalk.org/index.php?topic=978804.msg10683964#msg10683964) promo video: short commercial (1min) presentation with audiocomments(3min) (https://bitcointalk.org/index.php?topic=978804.msg10683964#msg10683964) explain video 1: basics explain video 2: edit buys and sells planning of my own asset (https://bitcointalk.org/index.php?topic=978804.msg10684058#msg10684058), and my general research about existing assets (https://bitcointalk.org/index.php?topic=978804.msg10755157#msg10755157) reselling (https://bitcointalk.org/index.php?topic=978804.msg10692102#msg10692102) my other threads on BCT (https://bitcointalk.org/index.php?topic=978804.msg10702563#msg10702563) roadmap DEV UPDATES: 2015 March 19th: all the other places ... (https://bitcointalk.org/index.php?topic=978804.msg10824737#msg10824737) 2015 March 21st: assetparser.py (https://bitcointalk.org/index.php?topic=978804.msg10844844#msg10844844) 2015 March 23rd: yachtcalculator (https://bitcointalk.org/index.php?topic=978804.msg10856256#msg10856256) 2015 March 27th: Nerd prose :-) (https://bitcointalk.org/index.php?topic=978804.msg10898327#msg10898327) 2015 March 28th: asset launched: AAssetHZ (https://bitcointalk.org/index.php?topic=978804.msg10932981#msg10932981) 2015 March 31th: Banners for ads (https://bitcointalk.org/index.php?topic=978804.msg10945856#msg10945856) 2015 April 4th: Structure Overview (https://bitcointalk.org/index.php?topic=978804.msg10980260#msg10980260) 2015 April 11th: New Homepage (https://bitcointalk.org/index.php?topic=978804.msg11057692#msg11057692) 2015 April 14th: MJcoins special (https://bitcointalk.org/index.php?topic=978804.msg11086683#msg11086683) 2015 April 15th: privateAPI considerations (https://bitcointalk.org/index.php?topic=978804.msg11093429#msg11093429) 2015 April 19th: privateAPI first implementation (https://bitcointalk.org/index.php?topic=978804.msg11138625#msg11138625) 2015 April 28th: shareholders /innercircle/ PM (https://bitcointalk.org/index.php?topic=981128.msg11219235#msg11219235) 2015 April 29th: shareholders.py explanations (https://bitcointalk.org/index.php?topic=998804.msg11236283#msg11236283) (5 posts) 2015 May 11th: new homepage design (https://bitcointalk.org/index.php?topic=978804.msg11350400#msg11350400) 2015 May 19th: new AltFolio version v50 - many improvements! (https://bitcointalk.org/index.php?topic=978804.msg11415669#msg11415669) 2015 May 26th: new AltFolio version v51 - brochure image (https://bitcointalk.org/index.php?topic=978804.msg11450977#msg11450977) 2015 June 3rd: freedom! (https://bitcointalk.org/index.php?topic=978804.msg11527447#msg11527447) (leaving = a lot of work) 2015 June 6th: asset launched: AAssetNXT (https://bitcointalk.org/index.php?topic=978804.msg11583419#msg11583419) 2015 June 6th: SupernetRadio interview with me. (https://bitcointalk.org/index.php?topic=978804.msg11610570#msg11610570) 2015 June 20th: Altcoin Newspaper Stand, edition v01 published (https://bitcointalk.org/index.php?topic=978804.msg11663604#msg11663604) 2015 June 29th: HZ Blockexplorer extension for assets, in PHP! (https://bitcointalk.org/index.php?topic=978804.msg11745517#msg11745517) much more ... undocumented 2015 August 5th: assetgraphs.py (https://bitcointalk.org/index.php?topic=978804.msg12055996#msg12055996) 48h nxthacks2015 2015 August 6th: chaincountdown.py (https://bitcointalk.org/index.php?topic=978804.msg12067029#msg12067029) 1-week fun hackathon 2015 August 15th: I wont the nxthacks2015! (https://bitcointalk.org/index.php?topic=978804.msg12150067#msg12150067) 2015 August 21st: new webpage showing my "log" of activities (http://altsheets.ddns.net/log) <--! 2015 November 8th: (https://bitcointalk.org/index.php?topic=978804.msg12921413#msg12921413) New product released! AssetGraphs-v2 2016 January 13th: new 2016 price scheme (https://bitcointalk.org/index.php?topic=978804.msg13542852#msg13542852) for AltFolio DataServer much more ... undocumented 2016 March 13th: completely new, surprising AltFolio homepage

____________http://altsheets.ddns.net/img/homepage_screenshot_20150801.png (http://altsheets.ddns.net/) ____________https://i.imgur.com/LdjH809.jpg (http://altfolio.ddns.net/)

I have been using it myself for months now, continuously improving it - so it is highly optimized for daily use. The goals are that my tool saves you time - because you get all the data you need for daily 1 minute portfolio checking, and that it improves your trades - because you can react quicker when one of the markets starts moving. But it's my first such product. Please help me improve the sales side of this (In exchange you will get generous serial code extensions = free access). Thx.

Follow me: - Twitter (https://twitter.com/altsheets) - Diaspora (https://diasp.eu/people/84e1e620b16d01321e8f5404a6b20780) - Facebook (https://bitcointalk.org/index.php?topic=978804.msg11527447#msg11527447) - Youtube (https://www.youtube.com/playlist?list=PLhqliQNp18DxaCfaJRH2VmgSrpETIu_Wk) - Bitcointalk (https://bitcointalk.org/index.php?topic=978804) - NxtForum (https://nxtforum.org/general-discussion/a-question-from-the-nxt-facebook-group/msg167872/#msg167872) - BitcoinGarden (http://bitcoingarden.tk/forum/index.php?topic=3190) - CryptoCoinTalk (https://cryptocointalk.com/topic/38582-altfolio)


Good? Get yourself a gmail, because you need googledrive for this. Then

"My Story"


So I was asked tell MY STORY (instead of posting a "buy my product" :) only). This became real fun typing:


My nerdy software romance
- an exciting, and mesmerizing plot, with surprising turn of events, no cliffhangers, but also a not too Happy End. More Nouvelle Vague than Hollywood, really *g*

...

SPREADSHEETS
I always loved the power of Excel spreadsheets - a few simple formulas chained after each other ... can calculate quite some complex questions. Great!

BITCOIN
So when I entered the bitcoin world, shortly after the last (ever?) rally in late 2013, I quickly used that talent for many things:
* Hardware profitability calculator sheets - turned out to be completely correct. But very wrong when BTC just never stopped falling in value (I actually sold my GPUs in the last possible second, early last summer).
* Trading logbooks - to understand better this mindbogglingly simplistic -but emotionally difficult- new task of TRADING. My highest early gain was more than 1000% sell over buy price - that's when I understood: Wow, here is how to make money (if I will ever get interested enough in money, that is). But man, I also lost sooooo much. And never again got over 10fold.
* Mining profitability sheets - in the end I had more or less replicated coinwarz, even with crossover-factors for all mining algorithms (Scrypt vs X11 vs ...).
* And sheets with all my 80+ wallets on 5 different computers, virtualboxes, and cloudmachines. "One day they will be valuable" - what a nonsense.
Bottomline: I have more than 10 different types of Excel sheets now, that I am using for cryptocurrencies. Very useful. And one of them evolved further:

GOOGLESHEETS
Then, for presenting a semi-scientific analysis (I could show that the richlist of a rather arbitrarily chosen coin ... follows a scale-free power law, in a large part), I chose GoogleSheets over Excel, mainly because I wanted to present it to our Facebook Group. At the end of that project, I had actually gotten some donations for it - but only very few. Cryptocurrencies are seemingly almost exclusively about TAKING from each other, very very seldom about GIVING, REWARDING, DONATING. Far from a better world, really, very far.
But I had learnt a big deal about GoogleSheets - they are not as advanced as Excel, but they live online - ideal for FB communication about data. And for most ideas so far I could at least write extensions in Javascript/GoogleAppsScript.

PORTFOLIO PIE CHART
In a small FB group, we were discussing the latest crypto technologies, and investment tipps. To simplify the communication, I came up with a pie chart visualisation of my portfolio. Showing only the relative amounts! That way, the very rich (approx 300times more money than me?) would look exactly like the very poor (me), and we could discuss strategies without envy or awkwardness (the otherwise unbridgeable divide between the ruthlessly rich and the heartbreakingly poor is a knockout argument against capitalism, actually - it's an antisocial system which we have to transcend eventually.).
Those pie charts really helped to understand each other better. One picture says it all. It didn't help me to loose money, though. (The tons of money that I lost in those months in that expert group, I still have not fully recovered *g*)
But the pie charts became the basis of the software system that is ready now.

LIVE UPDATE
To be able to calculate the total value of all my coins - yes, I was like Dagobert Duck playing coin rain in his vault. Only with a ridiculously smaller amount - ... I always wanted to have CURRENT PRICE DATA. Because most coins are loosing their value so quickly, that only with an automatic price update ... my spreadsheets would still make sense.
I found a superb library to parse JSON data, and started eating the API output of poloniex. Wow, this is so powerful. The internet has only really become useful when servers started to provide us with such structured data (and actually that only started to be relevant when ME began to parse that data :-) ). APIs are great, I want to work in that field!
Then I had to battle with countless problems, of course. A well known one: GoogleSheets are caching all their function results, so even if a price at an exchange changes dramatically, my sheet would show an old value. *Grmpf*. I found a workaround, a dummy parameter. Yiehah! (Skipping a lot of intermediate steps here).

SINGLE CELL UPDATES
In autumn, my sheet was not only ready and already very useful for myself - I had also put a lot of energy into it, to make it more easily accessible to other people (still, too idealistic I am). All cell types were coloured differently, external data different from locally calculated, and most importantly: "YOU ONLY EVER TOUCH THE ORANGE AND YELLOW CELLS" became a complete replacement of a 5 pages long manual.
I have been using it ever since, at least once a week - I wouldn't know how to trade without it actually. And two friends also used it. However, for some reason even that free/donationware version never really caught on. I don't understand humans well enough, I guess - or humans do not understand me well enough ;-) I probably need a good salesperson at my side! Send me your CV/successes.

BACKEND IDEA
With 15 coins the GoogleSheet became stuttering, some of the updates were either super slow, or failed completely. It was a combination of two things: The GoogleSheet server does not provide much CPU power, not much bandwidth or parallel webconnections - and poloniex was always sending data about all markets, even if I only wanted a single coin's price. Overload, laggy, not nice to use, really. And my future plans were to pull MORE data not less. No chance to continue with a GoogleSheet only.
Moreover, all the intelligence of my system had been completely embedded into the frontend, so there was no way of demanding money once the sheets were handed over (and as mentioned before, for me working on donation basis ... the average greedy cryptocoin person is not awakened enough, unfortunately.). So I had to come up with a serial code solution - if I wanted to afford to put more life time into it.

EARN MONEY
My hope is to sell it for very cheap to many many people, I prefer that to the other option of asking for a lot of money from a wealthy few. But I guess, at the beginning, I will have to take from the rich first? So please YOU WEALTHY ELITE (You can even donate anonymously, see the 3rd tab in the sheets): Please support this great programming project with 0.1% of what you own, or earn - that would help me to continue to improve the product, and offer it for a really low price. Be my patron please. If you want something in return, tell me - how could I help you?
The third option would actually be the fairest, but uncapitalistic: Take only a small fee from poor people, but take a 100 times higher price from richer people. Morally, it would make most sense, really. We have stopped to notice how much capitalism is preventing better or best ideas from at all getting into this (instead deteriorating) world ...

GOOD PRICE
If you have a good intuition for fair prices, please make a suggestion.
I need 5 prices: For 1day / 1week / 1month / 1quarter / 1year.

ASPECTS
* My rough idea was to ask a server by simply composing a URL which contains all the specifics of the question.
* I needed specific routines for each of the now 7 exchanges. One for getting, one for extracting from the JSON data.
* And I wanted to cache all API results, for a few second (No need to hammer the exchanges more often than every 30 seconds.).
* Cryptsy needed special treatment because it works with marketIDs instead of coin names.
* And Poloniex always delivers all market data, so it makes sense to cache it, for another coin.
* Django suggests a MVC (model, view, controller) approach, so I created my object models for Coins, and Markets.
* Plus I needed a customer database, for the authentication code system.
* And coinmarketcap can provide more than only price data - by the way a VERY useful extension: In a small table I can see if anything dramatic happened to any of my coins in the past hours, or days.
* A settings file distinguishes if the code is running on the dev system, or the production environment.
* There are maintenance and backup functions, and many tests to check the system.
* Finally, an elaborate form mechanism generates a new trial code when feeded with an email address.
Now that it is ready, it sounds so easy - but building all this organically, and testing it iteratively ... took months, part-time.

FRAMEWORK
I had to make a choice how to implement the server. I chose Django as the web framework, because Python is my favorite language. And Django has a very easy to use URL dispatcher, of which the manual page even mentions the excellent article http://www.w3.org/Provider/Style/URI of the WWW mastermind TimBernersLee (I guess that citation convinced me most :-) )
A choice I have never regretted - Django is an amazing plattform to build the App intelligence without having to care too much about the lower levels of implementation. Most of the time that is :-).

WHOLE COLUMN UPDATES
Now with CMC + exchanges, I was pulling in external data into 50 cells in parallel. Even without having to parse JSON (as my server now provides primitive, but fast CSV), GoogleSheets was acheing. Hmmm. I redesigned, to now return whole columns. It's a pity really - because why update all those coins that are not critical right now? But the speeding up was dramatic when I started to return whole columns. A future upgrade would replace that by somehow updating only those cells that the cursor is hovering over, or clicking into!

BACKEND BLOCKING TO ASYNC
In December, I was ready to launch. All was working perfectly again, even after the migration to half frontend / half backend. It was working better than before - but honestly, only a little bit better. still, I proudly presented it to X, but in the first minutes he found my design problem: Not async but blocking. Ooops. For me that became not a few lines of code, but a whole conceptual upgrade of my programming abilities. Over decades, I had programmed tens of thousands of lines of code, but on single core processors, and without waiting for any data. Just waiting for number crunching (some of my science simulations were running days before they then returned one number, but with high accuracy).
Anyways, threaded / async programming had never been necessary for what I had built so far. Until now. I understood the principle, but had not a clue about how to implement it. So weeks of super-interesting learning started. By now, I have fully explored threading; it arrived in my repertoire late - but when needed. And it sped up the data access BIG time, most (whole column!) updates now need much less than a second. If not, the reason is usually poloniex ;-)

ASYNC NEEDS LOCKING
New abilities = new problems. The App server is providing my App to the WWW in a dozen independent worker processes. And ooops - suddenly there were some database objects doubled which should only ever exist once - of course, due to the -now async- concurrent access of several workers onto the same database. Such a problem is solved by an object called Lock - only the process that acquires the lock is getting access to the scarce resource.
In my webforum research about django database locking, postgreSQL had been suggested to be the much better choice than the default sqlite3, so I learnt how to install and configure postgreSQL on Linux and Windows, and migrated everything - only to find out, that new and different concurrency problems appeared. And that postgreSQL is up to 20 times slower than the primitive but lean sqlite3.
In the end, I created my own lock system, db-independent. And I hope sqlite3 simply keeps on scaling up with all the additional load to my server :-)

FINDING TESTERS
Of course, the above is only describing a tiny bit of what really happened from the very first idea "let's make a pie chart" to this fully working end user software. But perhaps you found it a bit interesting to read a nerd story?  My honest hope is that I could: Seduce you into a free trial of my product. Send me your email address.
Because ... finding testers, buyers, even taking-it-for-free people seems to be a hundred times more difficult than any of the above challenges. And I don't understand why. I have helped lots of people on the internet, invested hundreds of hours into FB groups and BCT, donated tons of my time - but when it comes to me asking for 10 minutes of other people's time, I am given zero - that is actually a bit disappointing right now. Are most cryptocurrency people really as bad as their reputation? (*)

Please help me understand the phenomenon better, yes - but first please
* have at least tried out my product once,
* have pressed "update" a few times in it, and then
* have smiled at your thought of: "wow, this AltSheets AltFolio is a really useful software" ...

:-)

End-of-nerdstory,
about an altcoin trading helper software,
version v06, typed on 2015 March 4th & 5th & 6th.

Screenshots: http://altsheets.ddns.net/screenshots
Fanpage:       https://www.facebook.com/altsheets
tipping:          bitcoin:13YtgFiZvfeFSSqZv5qcUo2GHg8Cgjv3CJ
email:            altsheets(plus)trial(at)gmail(dot)com

---

(*) addendum "TRUST":

Very thankful for feedback: It was pointed out to me that TRUST could be an issue:

> The problem you have now is trust though,
> you are using "Alt Sheets Dev" as a user name,
> nobody wants to click anything by that,
> might be a trojan,
> might be someone shady trying to rip them off.

Of course, I hadn't though about that point yet - because I do trust myself, and fully. I will think about how to make this more transparent. However, right now I would actually not even know how to betray people with it. Why? It's your own copy of a GoogleSheet that you run. All the frontend code is accessible to you, you can check the code easily (MENU ... tools ... script editor). Please open it now, for a minute (I had even put some comments into that code.)

But I will take such doubts serious. Whoever has trust issues about this, and ideas: Please work together with me about it, so that I can find out how to make my customers feel safer. Thanks a 10^6 !

A new suggestion which solves it: ... is to simply use a fresh gmail account.

The AltSheets AltFolio works with your own copy of my GoogleSheet, which lives in your own GoogleDrive - so if you want to be supercareful, just create a completely new googleaccount for that ... and even if I had malicious intentions, you should then be 100% safe.

Screenshots:

1 - input & current price
2 - portfolio composition with diagram
3 - simplified "CEO overview" for making your own screenshots



1 - input & current price

http://altsheets.ddns.net/screenshots/Screenshots2015_v44_part1_v02.png


2 - portfolio composition with diagram

http://altsheets.ddns.net/screenshots/Screenshots2015_v44_part2_v02.png


3 - simplified "CEO overview" for making your own screenshots

http://altsheets.ddns.net/screenshots/Screenshots2015_v44_part3_v02.png

roadmap

reselling

I share 30% of the sales price with you when you are reselling AltFolio.

Conditions:
* You are an AltFolio user yourself, and thus know the product well.
* The buyer buys at least for 6 months.

PM me for details.

Some of my threads on bitcointalk:

• product 1: 'AltFolio' - price-updated ALTcoin PortFOLIO Overview
  https://bitcointalk.org/index.php?topic=978804
  
  
• products 2: assetparser.py & shareholders.py - analyzing the HZ/Nxt blockchain for assets
  https://bitcointalk.org/index.php?topic=998804
  
  
• my assets 'AAssetHZ' and 'AAssetNXT - crowdfunding my endeavours, will be paying dividends from profits of the above
  https://bitcointalk.org/index.php?topic=981128
  
  
• 'how to buy assets on HZ' - easy instructions for newbs
  https://bitcointalk.org/index.php?topic=1006327
  
  
• New subforum: ASSETS and asset PLATFORMS? https://bitcointalk.org/index.php?topic=988034
  A futile thread to convince (the chronic haters on) bitcointalk to open a proper subforum for us.
  
  
• Altcoin Newspaper Stand - which crypto news aggregators are you regularly reading?
  https://bitcointalk.org/index.php?topic=1036263
  
  

an idea-for-the-future: address+privatekey generator (https://bitcointalk.org/index.php?topic=983550) for any coin. --> cold storage addresses that are auto-updated from blockchains.

my interesting research about assets:

CAC (https://bitcointalk.org/index.php?topic=981128.msg10708354#msg10708354)  cryptoassetcharts.info
CMC (https://bitcointalk.org/index.php?topic=981128.msg10709843#msg10709843)  coinmarketcap.com
descriptions (https://bitcointalk.org/index.php?topic=981128.msg10752592#msg10752592) and numeric properties (https://bitcointalk.org/index.php?topic=981128.msg10760673#msg10760673) of HZ assets

... work in progress ...

 

New: Twitter handle -->  https://twitter.com/altsheets

https://i.imgur.com/28HWkam.png

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

The goals are

that my tool saves you time - because you get all the data you need for daily 1 minute portfolio checking, and
that it improves your trades - because you can react quicker when one of the markets starts moving.

connect with me on Twitter -->  https://twitter.com/altsheets

https://i.imgur.com/QOsWB7o.png

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

Very interested to try :)
Thanks

I kind of like my last facebook announcement, because it is short, and explains it well - doesn't it?


https://www.facebook.com/groups/MultiCoinTipping/permalink/911146135615740/

https://i.imgur.com/poEU7lD.png

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

I stumbled across Altsheets right at the start on FB.  Using my special talents as a Newbie, I worked with him to make it 'me-proof.'  Somehow he pulled it off, it's so easy to use even I can't screw it up.  It took me 10 minutes to load up the information, and the spreadsheet took over.  Now instead of flipping thru Poloniex, Cryptsy, and Bittrex i just pull up Google Spreadsheets to check coin price changes, volume, etc. in about 3 seconds.  I bought three months right off of the bat, a bargain considering that time is money.  Staring at those screens got old very quickly and now THAT burden is gone.  Even as-is I love it, but I'm told that it will be expanded even more.  He gave me a free trial and was responsive and helpful.  What more could I ask for, really?

In case you are wondering, I was and will be paid NOTHING for this endorsement.  The trial is free for everyone.

mind808crime

true sentences for marketing:

https://i.imgur.com/pf95efR.png

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

> would you mind if you explain me about  your software?
Sure:



Thanks for asking ;-)

good work  8)
reserved

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

Anyone who wants a free trial, PM me!

DEV UPDATE

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

• you can like my facebook fanpage (https://www.facebook.com/altsheets)
  - two of my postings: in CCC (https://www.facebook.com/groups/459085124197658/permalink/638507396255429/) and in the MultiCoinTipping (https://www.facebook.com/groups/MultiCoinTipping/permalink/911146135615740/) group - please you leave comments there.
  - beautiful user review (https://www.facebook.com/groups/459085124197658/permalink/640953129344189/) of my software!
  - lots of fb PMs (https://www.facebook.com/messages/100008826040038) (and emails which I prefer), of new users trying out my software. GET YOUR FREE TRIAL NOW (PM ME (https://bitcointalk.org/index.php?action=pm;sa=send;u=413122) here in BCT)
• The newly started twitter account (https://twitter.com/altsheets) already gets quite some followers, favoriting, and even retweets.
• Suggestions for you retweeting my message are on the first page of this thread (https://bitcointalk.org/index.php?topic=978804.msg10783261#msg10783261).
  
  
• nxtforum topic 8580 (https://nxtforum.org/index.php?topic=8580.0): I am parsing the asset markets, writing my own software for that!
• bitcointalk HZ thread posting
  #1133 (https://bitcointalk.org/index.php?topic=823785.msg10810475#msg10810475): which could perhaps also be sold.
• #1084 (https://bitcointalk.org/index.php?topic=823785.msg10787757#msg10787757): and with it, I even already found a bug!
• #1147 (https://bitcointalk.org/index.php?topic=823785.msg10820385#msg10820385): 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 (https://bitcointalk.org/index.php?topic=981128.0) 981128.
  

https://i.imgur.com/uXcpUoh.png

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

The BitcoinGarden twitter invited me to BitcoinGarden.tk to present my product there. (http://bitcoingarden.tk/forum/index.php?topic=3190)

... and tweeted about it (https://twitter.com/BitcoinGarden/status/578956490674970624), which is causing quite some retweets. Very happy!

(TODO: Screenshot)

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

https://i.imgur.com/PBt1APF.png

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

I have created an assetparser.py  (https://bitcointalk.org/index.php?topic=998804.0)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 (https://bitcointalk.org/index.php?topic=981128).


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

https://i.imgur.com/bMnM1wj.png
retweet please: https://twitter.com/altsheets/status/579393281290829824 Thx ;-)

Bitcointalk Signature Bonus

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


to your bitcointalk signature (https://bitcointalk.org/index.php?action=profile;sa=forumProfile) - and earn weeks of serial code validity for AltFolio.

A new tweet:

https://i.imgur.com/93P2dRK.png

https://twitter.com/altsheets/status/579841306698080256 (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)

new tweet: assetparser last mystery solved

https://i.imgur.com/hOBqkOn.png
https://twitter.com/altsheets/status/581270222348398592 (https://twitter.com/altsheets/status/581270222348398592)

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


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 (https://bitcointalk.org/index.php?topic=981128)"
how to buy:  "how to buy assets on horizon - the complete process, explained for newbies (https://bitcointalk.org/index.php?topic=1006327)"


.

Today:

25 bitcointalk postings (https://bitcointalk.org/index.php?action=profile;u=413122;sa=showPosts) (TWNTYFVE)
2 bitcointalk PMs (https://bitcointalk.org/index.php?action=pm;sa=send;u=413122)
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 (https://bitcointalk.org/index.php?topic=998804.msg10930008#msg10930008)
1 closed thread :-) (https://bitcointalk.org/index.php?topic=988034)


Good night, everybody!

good argument:

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

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


AltFolioBanner01.png http://altsheets.ddns.net/img/AltFolioBanner01.png (http://altsheets.ddns.net/altfolio)  --> dedicated landing page --> get trial serial

AAssetHZ_logo_250x250 http://altsheets.ddns.net/aa/AAssetHZ_logo_250x250.png (https://bitcointalk.org/index.php?topic=1006327)  --> bitcointalk "how to buy assets ..., example: 8101260088962758269 ..."

AltFolio_logo_250x250.png (not final!) http://altsheets.ddns.net/img/AltFolio_logo_250x250.png (http://altsheets.ddns.net/altfolio)  --> dedicated landing page --> get trial serial


Please give feedback!

Thx.


P.S.: Have a look at the very first banner advertising on cryptocoincharts.info (https://bitcointalk.org/index.php?topic=981128.msg10945770#msg10945770)

AltFolio - possible extension: Asset prices

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 (https://bitcointalk.org/index.php?topic=998804.0)) 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

Yes, and I have just done this here for you:
All these should be accepted - by the coinmarketcap columns generator. I have not compared them yet against all 51 assets that CMC is supporting (http://coinmarketcap.com/assets/views/all/) - are they all in there?

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


All feedback very welcome, always.

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!

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

New AltFolio Banner "Skyscraper 120x600"

http://altsheets.ddns.net/img/AltFolioSkyscraperBanner01.png


altsheets.ddns.net/img/AltFolioSkyscraperBanner01.png
--> dedicated landing page (http://altsheets.ddns.net/altfolio)
--> get trial serial

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!

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


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


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


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!

...please more info about NXTAD, link?

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

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.

Thank you for the link!

...I mean for the link.

...for this link: lmgtfy  :D  ;D !

 ;D

Altfolio description - sentences for press releases, etc.

The GUI frontend of the ‘AltFolio’ software is a GoogleSheet, so experienced spreadsheet users have full control, and can adapt everything to their needs! For beginners, it is intuitively colored so you hardly need any manual - and some 500 lines of Google AppsScript give it extra functionality. The many automatic cells make it so useful, and the updates come from a dedicated  data server - that backend consists of 3000 lines of Python code, which concurrently collects and caches from 9 data sources, including bittrex, and poloniex. And coinmarketcap - which shows me immediately if something dramatic happened to one of my coins in the past hour and week.

AltSheets structure, definitions, and names

I was told my endeavour is "progressive as fuck".
Already too complex, or a bit confusing?

Perhaps it is time to define my 4 new words:

... AltSheets = Altcoin Spreadsheets - a software family:
... ... AltFolio - the auto-updated portfolio tracker
... ... assetparser.py - the HZ&Nxt asset market blockchain parser in Python

... AAssetHZ - my AltSheets asset shares, on HZ


-->


AltSheets
* a software family
* to ease the life of altcoin and altasset traders
* --> AltSheets AltFolio,
* --> AltSheets assetparser, and the resulting --> asset market overview study ...

AltFolio
* is the altcoin portfolio overview sheet
* the software you are invited to try now (http://altsheets.ddns.net/altfolio) for free.
* can be bought as a month/quarterly/yearly licensed “Software-as-a-service”.
* with GoogleSheet frontend, and 500 lines of GoogleAppsScript to add functionality
* and data server backend in 3000 lines of Python, which manages fast, concurrent access to 9 data sources
* more info: read this thread here "AltFolio - price-updated ALTcoin PortFOLIO Overview (https://bitcointalk.org/index.php?topic=978804)"

assetparser.py
* an analyzer for HZ and NXT asset markets
* compares 107 HZ assets, and 488 NXT assets with each other
* in 28 observables, mostly statistical
* is written in Python, accessing the node API, to parse the blockchain data of the past
* the program output can be bought (107x27 and 488x28 cells big spreadsheets), and the program sourcecode can be bought
* more info in its own thread assetparser.py (https://bitcointalk.org/index.php?topic=998804)
* was originally just meant to explain me more about the asset market when I designed:


AAssetHZ
* the profit sharing, dividends paying, tradeable ... asset shares
* with which I sell 5% (five percent) of all future AltSheets profits
* buy them on HoriZon Platform now
* second largest volume among all HZ assets!
* more info in its own thread "[ANN][AAssetHZ] AltSheets Asset on HoriZon - software profits dividends (https://bitcointalk.org/index.php?topic=981128.0)",
* and in "How to buy an asset on HorizonPlatform.io (HZ)" (https://bitcointalk.org/index.php?topic=1006327)

Any questions - please ask!

Logo & Banners & Colors & Font - Competition ?

See the above "structure" text - a whole set of (icon-like?) objects would be nice.


But first: Please help me to understand this whole topic better.

Have you observed many? (because myself I kind of ignored logo competitions in the past).
Which such competition worked really well, in the recent past? Why do you think that is?

What is the order of magnitude for a prize that is attractive enough to get seriously talented designers to participate?
(And how much if I can only afford a 90% solution - for now?)

N.B.: This competition has NOT started yet. I always need time to think, and listen, and research. As an example, see my asset thread - it took from #1(March 08, 2015 (https://bitcointalk.org/index.php?topic=981128.0)) to #41 (March 28, 2015 (https://bitcointalk.org/index.php?topic=981128.msg10908865#msg10908865)) to launch AAssetHZ ! Also ... it could save me time (a scarce resource right now) to simply work together with ONE designer. So if you know someone, please point her/him to me ...

Much appreciated feedback of a knowledgeable user


Hey Hubus,
I finally find the time to go through your suggestions. Crazy times, since the launch. So much, and so different things to do.

> I had a look at your Altsheets Sheet.
Thanks a lot. Much appreciated. Every idea is welcome!


> Personally, I like spreadsheets (Excel) - like you.
Yes. Especially chaining of operations is so easy. Complex calculations can be broken down. And once formulas are defined, applied to whole columns. Spreadsheets are great!

Then when I decided to split my program into frontend, and Python backend - I made it even more useful. A lot of previous problems were suddenly solvable.

By the way, only a small part is visible to you users. Much of the intelligence lives in the Python backend now. It has become a powerful architecture. I like this short text that explains it well (https://bitcointalk.org/index.php?topic=978804.msg10980186#msg10980186).



What am I talking about when I say "frontend"?  Please open
AltFolio ... Menu ... Tools ... Script Editor ... altsheets-scripts.gs

To me, 'frontend' is the visible spreadsheet including the GS (GoogleappsScript) that is extending its functions.



> So for me it's good to have this as a spreadsheet.
Feel free to re-arrange, and extend and expand it.

Would love to see which mods will come up.
One other mod already exists, by the way.


> I would probably even like to customize it for my taste,
Exactly.
Please do so.

> which might be difficult if you want to protect your program.
Not at all. Go ahead.
You work in your copy anyways.

And really cool ideas could be reinserted upstream
- and I will reward you for it!


The protection comes with the data server authentication.
Plus expecting a minimum of morals from my customers, of course ;-)



> On the other hand, it should be possible
> to link my own spreadsheets to yours
Sounds interesting.

> (if it would be in Excel).
Two ways:

Either you import your existing sheets into GoogleSheets (if they are script-less then super-easy, automatic import for most of the Excel functions),

... or start building that portation to Excel.

An Excel version is already on my long list of ideas for the future (but not with high priority). One day, I might do it myself: Learn VBA, and do an Excel version of the frontend. Or probably it then won't be Excel, but LibreOffice/OpenOffice due to its different license - and of course it also has a scripting language (https://wiki.openoffice.org/wiki/Documentation/DevGuide/Scripting/Scripting_Framework).

However, as the data server backend is an online resource, I see not a huge advantage in building an offline version of the frontend. So why not Googlesheets?

I'd like your opinion on that.



>  I don't know if a local Excel version of this would be possible, but I would like it.
Of course it would be. Possible.
I simply took a decision early, to go for the online, GoogleSheets version.

But different frontends are possible. For sure.

For example, I have another quick'n'dirty hack as a completely different frontend - still only for myself, because it is slightly more complex to use.
Have you installed Python 2.7 ?  Then I could let you try it ...



> On the other hand, I think for a broader public,
Never to forget about them, I have to

(Yoda speak :-) )


> a spreadsheet version might be to complicated
If that turns out to be the case, I will make a altfolio-for-dummies version :-)

But let us first try this more advanced technology ... hoping for some tech literacy - just because it is so damn useful.


> and leading to errors
The good thing about googlesheets is the eternal rollback. With
  Menu ... File ... see revision history ...
you just hop to a version in your own past, which still worked.

Solved.


> (look at your "many" instructions,
Yes.

For a quickstart you really only have to stay to the one-liner rule:

--> Only ever edit the orange and yellow cells <--

If you stick to that, _most_ problems can be avoided.

But not all, I agree.

I made videos, too. You only have to see them once, less than 10 minutes.



> where the user has to find and input his changes freely.
Yes, flexibility comes with (the disadvantage of) choice.


> I think this is only possible, if the user already knows spreadsheets.
We have just had a case in which an spreadsheet newbie -quickly- went all the way, and he is enthusiastic about the power of (a) my programm, and (b) spreadsheets in general.


> For a good-selling program, probably a standalone version would be best.
Not impossible to do, yes.
But then you have 3 different operating systems, etc.  
It would probably better become a webpage as a frontend.


For my taste, however, the whole concept would loose an essential part of its beauty.
I had been using static solutions, and didn't like them. That's why I built AltFolio.

Perhaps ... I make software for intelligent people?

And: Look at the cryptocurrency scene  - even after 5 years, the majority still has a higher tech literacy than the average population.

 


> I can write some Excel makros (programs),
Superb.

Then please do have a look at the frontend GoogleScript code.

Perhaps you feel like porting it?


> so it might be possible to hide even more of your formulas
> from the screen and automate some of the inputs.
I am really open to suggestions.



> Well, it seems to be possible with these scripts ("Altsheets Functions"), too.
Yep.

> I should learn this, what kind of script is this, is it included in Google Sheets?
Yep.

See above.



>  You could form a more graphical user interface for the commands and inputs, maybe.

Unfortunately "buttons" are (still) implemented in a really stupid way, in this evolution step of GS.

They are graphics objects, have to be created (and linked to functions) manually, and (seemingly) do not get an addressable identity. *meh* GS is primitive.

If I had found a better way to create, show (and hide!) buttons, then I would have built a functions panel - instead of that slightly off menu.

But Google is a fast moving company, and when they upgrade their GS, I can do more such things.
 
 

> More improvement ideas:
Super, thanks!
 
> 1) Often, one buys the same currency at different times and prices.
Yes. Me. Often.

> So far, the only solution with your spreadsheet seems to be to add another row.
No no no. Please don't :-)

Simply combine all purchases,
into one average buy price,
and a total sum of coins.

> But then the currency is displayed separately.
> It's ok, but would be better, if all different buys
> in the same currency could be added and summed up to one total.
Yes.

> Maybe you should think of such a function for later.
> A heavy trader won't only make one buy for one price.
Sure.

I often have several consecutive buys at different prices.

The current workaround is the little handy "Combined purchases calculator" below the main table.

What you want is to divide the total BTC expenses by total purchased coins, to get an average buy price.


Any idea to improve usability more - happy to hear!
I want to reduce the "number of necessary clicks and keyboard presses" more.


> And a light trader probably doesn't need a software
> to keep his few things under control.
AltFolio actually allows a "light trader" to do one careful step towards becoming a "heavy trader", by having more different coins in overview than before.



 
> 2) If you don't want to play and don't want to loose money,
> I think you would be more interested in the value in US $ or,
> in my case, in Euros €, especially as the Bitcoin is so volatile.
That's what the one column "balance in USD" is for.
I often look at it, just to get a feeling how "important" that coin is, and not to care too much about 4 dollars worth of (what-turned-out-to-be-)shitcoins :-)

My intuition still needs fiat value, sometimes.


> So you really only know if you made a plus or minus,
> if you take the price of the Bitcoin itself into account!
Not sure that I agree with that.

Because I trade my altcoins often, but
bitcoin-fiat only really really seldom.

Or do you really do the (HZ --> BTC --> EUR --> BTC --> HZ) conversions for each and every hickup of the BTC price?


My altcoin trading is a way to increase my BTC total.
And in a good moment I trade BTC for fiat then.

In my first months with cryptos I was always converting everything to Euros; I don't do that anymore.
REAL money is bitcoins, Euros are just fiatmoney :-)



> Of course, the Bitcoin is an important denominator for the altcoins,
> but to see if you really made a plus or minus with your altcoins
> (and Bitcoins), you need to relate it to a fiat money like $ or  €.

What about this:

You introduce extra columns into your own copy,
and try out the best ways to represent that.

You can simply use the cell P3 (bitstamp USD/BTC)
to multiply everything, to get dollar values.

Please first start with dollars.

Then in my next backend upgrade, I build you a EUR/BTC data "askServer" function.

What about that plan?

N.B.: When you insert colums, some of the extra-menu-functionality
will break, for a moment, until you also fix the column numbers and
names in lines 17-56 of the GS code.
Please make a comment, to find your changes more easily later.



 
> 3) If this is too much,
> I would at least like it,
> if it would be possible to choose
> Euros besides Dollars for the balance column.

good idea.

It's on the TODO list now.

For now:
USD/EUR is almost at parity (https://duckduckgo.com/?q=1+euro+in+dollar).
Just subtract one tenth from everything, and you have the Euro value.




> Ok, I don't know if my comments are already worth 3 % of your profits,
:-)

Your comments are  ... invaluable.

But why do you say 3%?


>  but at least I earned a serial key prolongation... ;-) ?

Of course you do. Definitely.

I have just prolonged it once more. try menu ... "serial key server answer refresh".



Thank you soooooooo much. Be sure: All of your ideas, and suggestions have been heard, and some are already on the list for future versions of the software. Thank you for your attention!

Please keep on using, and help improving it!

Happy Easter!

Hello,

thank you for your answers! As usual, time is a scarce resource, so I don't know if and when I can answer more or even try to make my own version of your spreadsheet - usually, that's why people just want to buy a fully functional version and be lazy themselves!  ;D



Hey, we are in THE INTERNET here!  :o

> (if it would be in Excel).
Two ways:


I am from old times, I always prefer local versions. And so far, everything through the browser takes more computer resources, more time and more steps and more open windows and confusion, as far as I see it (and I don't have a super new computer).


Excel would be interesting, I would like to try a portation, but that would probably cost too much time for me... I don't have Python, but will have a look at it.


Maybe, but if they are too intelligent, they might not buy your software but do everything on their own?
> I should learn this, what kind of script is this, is it included in Google Sheets?



But I thought, the software should save me from work and from calculating everything on my own. If I have to do this in Excel first and then export the results to your google spreadheet, I have to do so many steps by myself and on two different platforms. Then I might not use your software but do everything in my Excel spreadsheet.


That is only half of the problem and it's not only about intuition, it is really necessary if you want to calculate profits.


If you really don't want to loose money and if you trade seriously, it's absolutely necessary and important, as the bitcoin price does not only "hickup", but does a lot more, possibly changing by 20 % on a single day, and much, much more in two weeks! That's not a hickup, that's changing from rocket high to vomiting and sick...!

And it is a problem of the altcoins, which I would really like to look at: They change when the BTC price changes - but not in the same and predictable and clearly linear manner! They are neither independent from the BTC nor completely dependend - this is very interesting for a trader!


So you buy everything you need with BTC? I don't believe you...  :P


I'll try. Maybe. If I find the time.


You wrote it somewhere, I don't recall where it was now.


Thank you very much! It's important for me, as I don't look at it every day...!

I tried today to insert the Asset Abbreviation, but your sheet has to fetch the data from some server!? So far, I found only the exchanges (like Bittrex, cryptsy etc.) in column M, but they don't have any assets, so where do you get these values? Or is it still something planned?

Thanks a lot!

Which ones have you tried?
With which results?

No, it makes up an answer on the basis of random function :-) Just a joke.

Correct is:
Your sheet-copy compiles the questions column-wise,
then when you press "update" ... asks my data server,
which in turn asks the data sources (*) - all async/concurrently;
and then the data sources provide the answers. Usually.
All is cached, and sent back to your sheet.
Then you decide to sell or buy :-)


I have implemented dedicated API access routines for (*) 8 exchanges (bittrex, poloniex, ccex, ...), plus coinmarketcap.com .

More is possible easily - I just have to find the time. You buying the software allows me to prioritize extending it along your wishes.


correct.

They have VERY few assets yet, and implemented them like coins.

The news about this type of cryptoassets is actually ... that they live on the blockchain (https://bitcointalk.org/index.php?topic=981128.msg10697516#msg10697516), and they are traded in DISTRIBUTED asset exchanges. No need for mtgox, mintpal, poloniex, allcoin ... and all the other places that already got/robbed our coins in the past.

I will build a similar gateway between my dataserver, and a HZ / Nxt node, to fetch asset prices. Thinking is being done - See the design questions in this thread.



Y

-->


but already:




Thanks a lot for your long answer above. Will get to it.

Enjoy your weekend!

:-)

... I could have edited my answer, but I think it's more clear to add something here:

If we want to calculate the "real" values, it is not necessarily the price of the EUR, BTC and HZ triplett at a given timestamp. Unfortunately, the calculation cannot be completely automated, as we don't buy the BTC with Euros at the same time as we buy the HZ with Bitcoins. Usually, you buy some amount of BTC at an individual time before you convert your BTC into HZ. And then, if we convert this back to Euros, we also do this at two different times and perhaps not with equivalent amounts.

So if I really want to calculate my profits/losses in the right way (and if you want to relate to fiat currency and not to BTC for this), I would have to note my personal EUR/BTC exchange price and amount manually, and then again the BTC/HZ price. And if I exchange EUR/BTC not a single time, but more often (which is normal), I even have to note from which BTC tranche I have bought which HZ tranche!

So it might be too complicated, but it would be the only accurate way to calculate my profits/losses (in EUR)!

(I think it would also be interesting for tax calculation, if you assume that you do everything accurate and legally...!  ;D )

Good thinking. You are completely right, for tax accuracy, another approach would have to be taken. All exact transactions that actually happened need to be taken into account, preferably directly downloaded from all 539 blockchains (http://coinmarketcap.com/currencies/views/all/) of all currencies. And for the exchanges (which is partly hidden data!) complex mixtures of them have to be manually input. E.g.:

I bought some BTC at 600 USD which I still had been lying around, and combine that with some new bitcoin which I got cheap for 180 USD and some to the day price of 237USD; then use 93% of the whole lot to buy some HZ at 101 Satoshi, and 94 Satoshi - and after buying and selling some assets on HZ (of which I actually keep 43% into the next tax year) ... I do the whole thing in reverse, but at 120 and 117 Satoshi per HZ - and can unfortunately sell my BTC only at 234 USD now - but I need the fiat so I have to.  

A very realistic example of what could really happen. And when future tax officers (or their bots) then discover on the blockchain that I had bought those third bitcoin 17 seconds later - and then the exchange rate was actually 1.2% lower ... they will put a chain to my feet, and I have to live on water and bread for a while ;)

My program is not intended to solve that.

Instead, AltFolio informs me -to its best knowledge- about the here and now. With the goal of looking into the future.

So that I can base my buy and sell decisions on real data. Without going to 5 different websites, loosing time for nothing.
... now I only check the price charts of those coins which have recently moved. <-- that, to me, is its greatest advantage.

But I agree, for Prussian accuracy :P, it will always be only an approximation of the situation.

> from which BTC tranche I have bought which HZ tranche!
Due to the property of fungibility of currencies (http://en.wikipedia.org/wiki/Fungibility) ... that is not necessary.
Imagine a trip to the US: Which 10 dollar note will you take out of your pocket when you buy a Veggieburger? The note which you got for 9 Euros - or the one which you bought for 8.50 Euros last year?

All we need to do is calculate a new average buy price.


> want to relate to fiat currency
Try to implement your ideas about conversion into the different currencies - or into those that you favor most. It's easy. My choice of a GoogleSheet frontend has the immense advantage that you can make your own mod of the frontend. And you know your Excel well - so it should be easy for you. Have fun with it! :-)

Either that or worse! Spending all my time with arguing with them, filling in forms, calculating and trying to prove that I did not make a few cents more than they think... and I thought Altsheets could save my from this  :'( !

At least, one should try to have some kind of "before & after" pools to see if the money got more or less.


How's that?


There, you are of course right! My thinking or explanation wasn't clear there  :P - but I had in mind, that you at least have to note all the tranches - otherwise you cannot calculate that average.

I still did not look at how to get this into your spreadsheet or if I have to calculate this separately in Excel, but for my taste, it would be good to have such an average calculation space directly in your sheet, maybe in a different table, but relating to your main table. As we have already discussed, also for different tranches of the same altcoin (bought at different BTC prices).

I like to work in a single file (and offline is still much faster on my computer). If we have to switch all the time between local and online, I will look for import/export possibilities from Googlesheets to Excel and vice versa.

Btw, Microsoft has an online version of Excel, now, too. Will look at that, too, but as far as I tried it, it is also unconvenient and slow compared to my "personal" Excel.

Yes, I agree - combining purchases is still the most tedious part of using it.
The little "calculator" at the bottom has at least automatized the necessary calculations now.
It takes me less than a minute, to update my sheet when I have bought additional coins.
(And most of the time, I am just LOOKING at the sheet, to see if anything dramatic has happened.)

But I agree, in this version there is still some considerable number of clicks and copy-paste operations, that can be reduced ... in future versions.

Thanks for insisting, by the way, that made me think about it longer - I think I came up with an idea how that might be solved more elegantly than now. Will try in a future update of the frontend. Until then: Semi-automatic, manual copy-pasting :-)


By the way:
The far future could also have an option for APIkey&secret input (needs more trust, though),
and direct import from all (8!) exchanges. That would automatize this step completely.

But to be able to implement all that ... I would need additional funding first.
Which will happen. This is a long distance endeavour ;-)


An OpenOffice/LibreOffice portation of the frontend, I could imagine. Not now, rather mid-future.

But the longer I think about it - the less likely I will invest myself into a (completely proprietary) Excel+VBA portation.

But you speak VBA, right?

Ah, I see, if I understood it right, you keep an old value in the upper row, and each time you buy some new, you insert it into the lower row and then take the result as the new old value?


I am not sure if I understood everything. Would that give the user full control over your sheet? I like that, but on the other hand, that will take away your last protection if you want to sell anything. Then you are dependent on good will, probably like selling shareware on a voluntary paying basis?


Yeah, while looking at all this new Microsoft monthly paying and online Office shit, I also begin to think slowly about changing one day, maybe. On the other hand, the old versions of Office I already own, have all (maybe more) core functionality - concerning the functions I usually I need - than the new versions and I am not sure if I need new versions at all. It might only be a compatibility/communication problem, when I am the last person who is using this (good) old software.


I am not a 100 % professional in VBA, but did some things a while ago and might learn more (especially as the help functions in this system are very nice and useful, I don't know if this is the same in OpenOffice) - the only thing which would currently be missing in my knowledge to build an Excel-clone of your sheet are probably things like those web queries, and licence keys and such things.

And as I said: I use old versions. I can only recommend to get them for a cheap price, it should be allowed to do business with the "Office Professional" versions, shouldn't it? But people always want new things, even if they are made more dependent and even if functions are reduced...

P.S.: The REAL thing would be to build some kind of HZ wallet wich has the functions of your sheet. OK, a sheet always has advantages, but maybe if you use the core functions and add an export (.csv) function, for example... What programming language is used to build those wallets? Java? (I told you to have a look at the SuperNet NXT wallet, it has some interesting etended functions in terms of asset administration, dividends, polls and decentralized exchange. I hope the HZ exchange - it's available as asset, too - will soon be realized).

Also, the BURST wallet, has an "AT automated transactions" function in which you can add code. Problem is, I do not understand all this yet, what kind of code has to be inserted there?

yes, that's how it works:
http://altsheets.ddns.net/img/combined-purchases-calculator.png

... because you want to input the new altcoin total (here 13.00), and the new average buy price (here 0.03846).

And with Ctrl-Shift-V you can paste the values only (keyboard-shortcut for: Edit ... paste special ... paste values only)

No, different story, completely different. The other way around - it would give me some control, over their trading account.

Have a look at e.g. https://poloniex.com/apiKeys = the way to get information about your trading account at poloniex.

The huge advantage for our question:  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.

I mentioned trust because altFolio.future.version users would have to trust me with their API key & secret.

At the moment there is no conceivable way that I could do real harm to my AltFolio users
- but for such an automated access to their trading accounts, my users would have to trust me more ... than is necessary now.


Yes, the HZ backend is Java, the HZ frontend is HTML+Javascript.
Other wallets (e.g. bitcoin, and all of its clones, like DOGE, and SDC etc.) are done in C++.

No idea. Just googled a bit. At first glance, screenshots of BURST look like just-another-Nxt-clone. Ask them in their thread (https://bitcointalk.org/index.php?topic=731923.0), I'd suggest.

Yes. Had no chance to look at it, yet.  But thx for the hint! Hope to find time for it ...

 :D

MJcoins special - screenshot

http://altsheets.ddns.net/img/AltFolio_420-special_20150414-1802.png

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

Above is data of an "ideal buying" scenario,
in which I assume a trading genius would have correctly guessed
the (recent) bottom of each of the 7 MJcoins,
and then bought 0.1 BTC each, at that lowest price.
That is why all are in the plus now, in this picture.

April 20th is in 6 days - so what is your guess:
Will any of these go up? Which one?
Who of you is trying to score?

Disclaimer: I am not saying it will happen - I am just asking whether it might happen

:-)


---

EDIT: This is based on the observation that all 7 MJcoins pumped shortly before 20/10/2014, and some around 20/4/2014. But also see this (https://bitcointalk.org/index.php?topic=978804.msg11093455#msg11093455) posting.

Thank you again for the explanations, very interesting to learn about these things!

But something shocked me:


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

If this is the case, I have to tell you, this idea is completely unrealistic! I would never do this and never recommend this to anyone - on the contrary! Such level of trust might exist within a family, or between best friends or a couple. Or in a company between the owner and only the highest financial or IT security executives, and even then it would be secured by some mechanisms and contracts, and the people know each other personally, see them every day, know their addresses etc. No way such a thing would be possible with your software. Well, if you find someone who does it, I might call that person crazy...

(I'm sorry, I am not saying that you are not trustworthy, but really, life experience, and even more: internet experience should have taught every reasonable and sane person that this is not adviseable.)

After reading about your suggestion, I now understood what "420" is. But in the history of the coins 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.  ???

...alas, October is a bit further away...  ;)

Yes, isn't it? Happy to tell.
I have been programming for a long time, but API access to data has revolutionized how I think about the internet.


No.

Have a look:

https://i.imgur.com/w2EehIG.png (https://i.imgur.com/w2EehIG.png)


All not relevant.

Again, and to be 100% clear: No. I would NOT get COMPLETE CONTROL over the user's account, e.g. including withdraw coins from there.


But your reaction is exactly what I meant - so we have a very good live example now.
Even if I would technically not be able to do what you suspected ... a user could immediately get panicky, paranoid, and run into a distrust spiral.


So the (huge!) advantage of fully automatic updates about all coin balances ... are weighed down by fear in less informed users.

But that is only one argument, not the full case.
I would still like to implement it into a far.future.version of AltFolio. Make it an optional gimmick.
But as it is a lot of work (it has to be done separately for each of the 8 exchanges) ... it's future music, anyways.


TL;DR: Just to be clear, for a quick readers:
PrivateAPI access is NOT part of the current AltFolio version.
Coin balances are updated manually.

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.

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? (https://bitcointalk.org/index.php?topic=1004621.msg11093523#msg11093523) thread - perhaps someone will tell us.

I had another look at October 20th:

http://altsheets.ddns.net/altprices/altsheets_altprices_MJ_October2014_prices.png (http://altsheets.ddns.net/altprices)

http://altsheets.ddns.net/altprices/altsheets_altprices_MJ_October2014_prices_stacked.png (http://altsheets.ddns.net/altprices)

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

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?

yes, exactly. All true.

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

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

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

This is the present version of AltFolio:

This is conceivable for a future version:
(for security/trust issues, also see this posting (https://bitcointalk.org/index.php?topic=978804.msg11093429#msg11093429)).


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 (http://altsheets.ddns.net/customer/new.html).

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

http://altsheets.ddns.net/img/20150512-HomepageScreenshot-AltFolio.jpg (http://altsheets.ddns.net/)

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

... check them out: http://altsheets.ddns.net (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.

 ;D

Newsflash:

http://altsheets.ddns.net/img/altfolio-7days-price-minicharts.png (http://altsheets.ddns.net/altfolio)

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

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

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

AltFolio just got better ... new version v51.

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

http://altsheets.ddns.net/img/AltFolio-v51-new-features.png (http://altfolio.ddns.net)


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

Poll

AltCoinTraders, tell me:

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


Thx.

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

AAssetNXT issued!

https://i.imgur.com/CIIniY6.png (https://twitter.com/AAssetNXT/status/608027512275378176)

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

my asset thread "[ANN][AAssetHZ/AAssetNXT] AltSheets Asset on HZ/NXT (https://bitcointalk.org/index.php?topic=981128)"


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

updated:

* AAsset OP (https://bitcointalk.org/index.php?topic=981128.msg10697450#msg10697450)
* AAssetNXT issuance info (https://bitcointalk.org/index.php?topic=981128.msg11583679#msg11583679)
* webpage /aassetnxt/ (http://altsheets.ddns.net/aassetnxt/)
* twitter @AAssetNXT (https://twitter.com/AAssetNXT)
* AltFolio OP (https://bitcointalk.org/index.php?topic=978804.msg10683744#msg10683744)
* cryptocointalk new post (https://cryptocointalk.com/topic/38582-altfolio)
* my other threads on BCT (https://bitcointalk.org/index.php?topic=978804.msg10702563#msg10702563)

AltSheets was interviewed at #supernetradio #SNRN

http://altsheets.ddns.net/pr/supernetradio-player-embedded-screenshot.png (http://altsheets.ddns.net/pr/supernetradio.html)

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

Altcoin Newspaper Stand (https://bitcointalk.org/index.php?topic=1036263)
edition v01 is ready

https://i.imgur.com/SxZhem3.png (https://twitter.com/altsheets/status/612042042110308352)

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

great work, how much does it cost after the trial?

Thanks. Anything you'd like added to it?


Let's try this for now:

good?

I coded a
HZ blockexplorer extension B.E.E.f.A
for all assets: 'asset.phtml'

https://i.imgur.com/a8Ub897.png

You can read everything about it

in the HZ thread:

• why what how? (https://bitcointalk.org/index.php?topic=823785.msg11744271#msg11744271)
• quickstart (https://bitcointalk.org/index.php?topic=823785.msg11744396#msg11744396)
• asset warnings idea (https://bitcointalk.org/index.php?topic=823785.msg11744576#msg11744576)
• sourcecode & readme (https://bitcointalk.org/index.php?topic=823785.msg11744624#msg11744624)

all compiled below (https://bitcointalk.org/index.php?topic=978804.msg11749943#msg11749943)

... or -beautifully layouted- in

• my github --> readmeAsset (https://github.com/altsheets/hz-blockexplorer/blob/master/assetsReadme.md)

...

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

thx ;-)

What is the newspaper stand?

How can it benefit me as dev of 2bacco coin?

What can I do with it?

Discussed over there: https://bitcointalk.org/index.php?topic=1036263.msg11749768#msg11749768

AltSheets B.E.E.f.A

copy of my 4 postings  in the HZ thread (https://bitcointalk.org/index.php?topic=823785.msg11744396#msg11744396)

---

---

---

---

This is just a copy-for-eternity, to document it here on my AltSheets timeline.

Please do discuss it over there  in the HZ thread (https://bitcointalk.org/index.php?topic=823785.msg11744396#msg11744396), or in the Horizon Forum (https://horizonplatform.io/topic/b-e-e-f-a-block-explorer-extension-for-assets-page-in-b-e-one-per-asset/), not here ! Thx :-)

I fixed a bug!

copy of my posting in the HZ thread (https://bitcointalk.org/index.php?topic=823785.msg11753742#msg11753742).

Lootz from supernetradio (my 1 hour interview about AltFolio is online on soundcloud (https://bitcointalk.org/index.php?topic=978804.msg11610570#msg11610570)),
and me chatted a bit about AltFolio, and shareholders.py, and assetparser.py, in a slack.

Here is a transcript (https://forum.thesupernet.org/index.php?topic=599.msg15290#msg15290) (without all the uploaded pictures).

 :)

New assetparser.py version v31

https://i.imgur.com/N201MIX.png (https://i.imgur.com/N201MIX.png)
(click pic for larger)

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

Thanks!

My products:

* AltFolio - Useful for AltCoin Traders. Do you own altcoins?
    Keep all your coins on one page, with auto-updated price & CMC data & mini-charts
    (CoinTelegraph.de (http://altsheets.ddns.net/pr/cointelegraph/) interview about AltFolio!)

      --> http://altfolio.ddns.net - free trial.

* assetparser.py - analyze ALL assets on both (NXT&HZ) markets, in 42 observables --> http://altsheets.ddns.net/assetparser.py/
* shareholders.py - closer contact with your shareholders, send a password to an "innercircle" webspace - http://altsheets.ddns.net/shareholders.py/

* PAS (http://altsheets.ddns.net/pas/) = Poll Analysis Sheet, descriptive data analysis - I can analyze your data professionally

* AssetGraphs.py (https://nxtforum.org/assetgraphs-py/) = visualizing assets, shareholders, issuers as network graphs
  - may soon turn into a product (https://nxtforum.org/index.php?topic=9967.0). I won the nxthacks2015 1st prize (http://jnxt.org/nxthacks) with it !!!

* ABEE (https://bitcointalk.org/index.php?topic=1181547) = AltSheets Block Explorer Extension v0.2.2 for Ethereum clones

* "Advice me, Altsheets" (http://altsheets.ddns.net/advice/)


Some of my other projects:

* Altcoin Newspaper Stand (https://bitcointalk.org/index.php?topic=1036263) - I created "the missing list" of crypto journalism sites

* many: BAMM.py (https://bitcointalk.org/index.php?topic=823785.msg11286811#msg11286811) (balance alarm mail mailer (https://bitcointalk.org/index.php?topic=823785.msg11454543#msg11454543)), B.E.E.f.a (https://bitcointalk.org/index.php?topic=823785.msg11744271#msg11744271)  (HZ block explorer extension for assets, 4 consecutive postings!), altprices.py, ...

* PGP (http://altsheets.ddns.net/pgp/) encrypted email tutorial & quickstart for newbies

* chaincountdown (http://altsheets.ddns.net:8888) - block count image server (github (https://github.com/altsheets/chaincountdown))

* ASC (https://bitcointalk.org/index.php?topic=1181547.msg12451920#msg12451920) = a new representation for the total difficulty ( "AltSheetsCoefficient" :-) )




---

About me:

* CoinTelegraph.de interview (http://altsheets.ddns.net/pr/cointelegraph/) about AltFolio

* supernetradio 1h interview - http://altsheets.ddns.net/pr/supernetradio.html

* my threads on bitcointalk: http://2020.fm/altsheetsthreads

* "my story (https://bitcointalk.org/index.php?topic=978804.msg10683813#msg10683813)" describes the beginning, how AltFolio was born.

---

Support me:

* I love contributing; see my giveback-license for how to give back - http://altsheets.ddns.net/give/

---

My assets:

* AAssetNXT(13634799205909171438), and
* AAssetHZ(8101260088962758269)

    --> http://altsheets.ddns.net/aasset

.

------
EDIT 20150918: Added 7 more (projects + products). What a productive summer!

HZ 3.9.2 and HZng 3.9.2

https://i.imgur.com/QlG81Bu.png (https://twitter.com/altsheets/status/621736064454160384)

Linked here: https://twitter.com/altsheets/status/621736064454160384 Please retweet.

Thanks

altsheets is a great tool guys, keep record of your gains easily.

Thanks a lot, LooTz.

And thanks again for the opportunity to give an interview on your supernetradio (https://bitcointalk.org/index.php?topic=978804.msg11610570#msg11610570)!

AltFolio v51.10 - New minor version upgrade

https://i.imgur.com/iL1LsVj.png

* bittrex: yes, I am using API v1.1 - https://bittrex.com/Home/Api
* bittrex: check if "success": True; cryptsy: check if "success": 1
* cryptsyIdsRewrite now catches '[Errno 13] Permission denied''
* simpleStatus: sizes of caches

* btce: removed "cnh","gbp"

* added kraken fiat prices: "usd","eur","gbp","jpy","cad"


---

retweet: https://twitter.com/altsheets/status/623055046171848704

! assetgraphs.py is born !
my 1st hackathon participation in
nxthacks 2015 - vote now

https://i.imgur.com/sOQaXqi.png

retweet: https://twitter.com/altsheets/status/628005223466991616
and https://twitter.com/altsheets/status/628018551417384960 thx!

More info will be in my assetparser.py thread (https://bitcointalk.org/index.php?topic=998804.msg12056046#msg12056046) - now it gets  ... visual
VOTE FOR ME - 4 days left to vote. 6 participants, 6 great projects!

My submitted epic: http://altsheets.ddns.net/assetgraphs yiehah!

:-)

EDIT1: crossposted to the HZ thread (https://bitcointalk.org/index.php?topic=823785.msg12056114#msg12056114)
EDIT2: new threads AssetGraphs.py is born! (https://nxtforum.org/index.php?topic=9741.0) and ... to Open Source (https://nxtforum.org/index.php?topic=9742.0)

chaincountdown.py
a server to build always updated countdown images

*tattaa*  :)

http://altsheets.ddns.net:8888/nxt/495997.png?heading=nxthacks%20voting:&fontsize=35&headingfontsize=50&color=ffaa00&bgcolor=001122 (http://altsheets.ddns.net:8888/)

This image is generated, on the basis of the current blockchain status!

Read more there: http://altsheets.ddns.net:8888 image server!

----
EDIT: new threads: bitcointalk 1147294 (https://bitcointalk.org/index.php?topic=1147294), nxtforum.org 9735 (https://nxtforum.org/index.php?topic=9735)

Shortinfo:

chaincountdown.py

I have celebrated a second "hackathon light", for myself.
I built us a useful tool ... for the nxthacks, and beyond.

This image is generated automatically, and always up-to-date:
http://altsheets.ddns.net:8888/nxt/495997.png?heading=nxthacks%20voting

The image can be placed into any webpage, like here:
http://altsheets.ddns.net/assetgraphs/

More infos on how to choose better colors, sizes, heading, etc:
http://altsheets.ddns.net:8888

A Blockchain aware countdown timer !

----
EDIT: new threads: bitcointalk 1147294 (https://bitcointalk.org/index.php?topic=1147294), nxtforum.org 9735 (https://nxtforum.org/index.php?topic=9735)

AssetGraphs.py is born!

Two new threads related to my nxthacks participation

"AssetGraphs.py is born! (https://nxtforum.org/index.php?topic=9741.0)" explains backgrounds, and paints possible futures for my project.

"AssetGraphs to Open Source - help me design a new asset (https://nxtforum.org/index.php?topic=9742.0)" does what it says  ;-)

Thanks!

.

#NxtHacks 2015 (http://jnxt.org/nxthacks/) winner: 1st: @AltSheets (http://altsheets.ddns.net/) - with #AssetGraphs.py (http://altsheets.ddns.net/assetgraphs) The poll entries were scored on four categories, Completeness, Style, Use of API, and Usefulness. Final Scores for the hackathon: ALTSHEETS - 27.11 5.85 Completeness 7.38 Style 7.50 Use of API 6.38 Usefulness all results at: NxtHacks thread (https://nxtforum.org/index.php?topic=9566.msg191411#msg191411). Retweet (https://twitter.com/altsheets/status/632588405717774336) ;-) _____________________________________________________________

.

https://33.media.tumblr.com/444da2b69f1eb4e6f474d6886d11b556/tumblr_mjvg2lmQQM1s2g2fgo1_500.gif (http://jnxt.org/nxthacks/)

Read more in the brand new subforum "AssetGraphs.py (https://nxtforum.org/index.php?board=199.0)":
"Concept draft for the future" + "Help me design an asset to OpenSource this"

Hooray  :)

Congrats champ.
Looking forward on the polished version.

Thanks a lot.

Let's get that going (https://nxtforum.org/index.php?topic=9794.0). <-- Today did research on licenses & crowdfunding.

A few days ago, I had an idea how a direct monetization could work;
at 5:19 a.m. in the morning. Immediately was wide awake, and started
scribling, and researching tools. Hope to soon find time to start coding it .

I have to consider all routes that money can take, to come my way. New
profile at gratipay (https://gratipay.com/altsheets/) (they support BTC) - new & shiny (http://altsheets.ddns.net/give/) gratipay button :-)

Studying day. Found the coolest project ever (https://www.startjoin.com/spacelift), and read interesting pages.
e.g.: AltFolio (http://altfolio.ddns.net/) is partly OpenSource (frontend & its GoogleAppsScript), and
partly SaaS (Software as a service) (https://en.wikipedia.org/wiki/Software_as_a_service): GoogleSheets itself and my own
dataserver that collects & caches & standardizes data from the exchanges,
provides the serialcode licensing system, etc. Stallman, forgive me please ;-)

Yesterday was great, too. I almost finished a new spreadsheet, that analyzes &
presents voting poll results (our nxthacks voting as starting point.). Stay tuned.

EDIT:
You can now post in a new supporters thread (https://nxtforum.org/index.php?topic=9798.0), intended
to gather some momentum to carry this into the future.

PGP = Pretty Good Privacy

Is there anyone here NOT yet informed (enough) about PGP ? 

Today I have taken the time to write a step-by-step tutorial,
for Thunderbird + gpg4win + enigmail + playing-with-Adele.

manual to configure your workplace with "Pretty Good Privacy" (PGP)
--> altsheets.ddns.net/pgp (http://altsheets.ddns.net/pgp/)

https://i.imgur.com/pvPHB0K.png

Please retweet. Thx. (https://twitter.com/altsheets/status/635063923193049088)

My step-by-step tutorial --> http://altsheets.ddns.net/pgp/

.

New

• webpage (http://altsheets.ddns.net/advice/)
• BCT thread (https://bitcointalk.org/index.php?topic=1162411)

Good idea?

People, find (https://www.openstreetmap.org/) a (http://maps.bing.com) lake (http://maps.google.com), and go swimming. August's almost over :-)

http://ciaobambino.com/wp-content/uploads/2013/09/north-shore-lake-tahoe-burnt-cedar-beach.jpg (https://www.google.de/search?q=summer+pic+lake+swimming&tbm=isch)

:-)

I tried it and it's a neat little sheet! Recommend to everybody to try it out. It's super easy.

Thanks a million for the compliments. Really happy about it myself.

Coinographer - spread the word! You can get attractive reseller bonus!

Just tell whom you invite to put "Coinographer" into the 'referral code' field (http://altsheets.ddns.net/customer/new.html).

 ;)

Detailed comparison of my two assets


https://bitcointalk.org/index.php?topic=981128.msg12373069#msg12373069


https://i.imgur.com/jBSGmDX.png
retweet: https://twitter.com/altsheets/status/641698394189242368 (https://twitter.com/altsheets/status/641698394189242368) - thanks!

Much updated overview about all my products and projects: Above, in this thread. (https://bitcointalk.org/index.php?topic=978804.msg11895609#msg11895609)
Also a shorter overview here (https://nxtforum.org/index.php?topic=9956.0). And also updated: my list of threads (https://bitcointalk.org/index.php?topic=1006327.msg11466586#msg11466586).

BLOCK EXPLORER for Ethereum clones
After BTC, then LTC, later NXT and cryptonotes ... now an ETH cloning wave might hit the scene.

Here is a simple -but well working- BLOCK EXPLORER,

that I learned to understand -inside out-, then extended with essential functions -

and that I can port to your Ethereum clone:

https://i.imgur.com/iu6vyvD.png (https://bitcointalk.org/index.php?topic=1181547)

As I can act fast, it is especially valuable for the first days of a new clone.
Later then, you can get e.g. a second B.E., or build your own one from scratch.

(Idea for how to get money (https://bitcointalk.org/index.php?topic=1181547#post_crowdbounty) together).


Contact me for details, and see my new thread (with MANY PICTURES) (https://bitcointalk.org/index.php?topic=1181547).

retweet (https://twitter.com/altsheets/status/644686457010061313) please. Thx.

 :)

New social networks
... that pay us for publishing, and inviting:

Qkadoo
https://qkadoo.com/#/friendme/4d7258be-905c-46c0-8a37-9879d19b3470-altsheets

StartPeeps
https://startpeeps.com/index.php?tab1=welcome&affid=AltsheetsDev

join us there.

 ;)

---

Good things can so easily be harmed by bad mood. Seen that too many times.

Posting this here, because I sense an analogy between bitcointalk trolls,
and un-therapized slave job patients on a TUI plane ...

Package tourism

It was my 1st package tourism (Pauschal-Reise) in > 20 years.
(Since back then once, I had always been a self-responsible traveler; a stonier, and harder path,
but more rewarding. And it educates you, and allows your consciousness to grow and expand).


Man, I was shocked:  So many package tourists can be terrible whiners. Poor them.
Every little obstacle, misunderstanding, disappointment ... is reason to go berzerk.

And later, checking online comments about our cozy hotel, I was appalled;
there is a large group who wrote such a bullshit about that beautiful place;
that was simply untrue, FUD, lies, and negativity. They are confusing their own
illness tainted view on the world with the objects they think they are describing.


Being able to always see the worst aspects of the world around them, and their
fellow patients. And it's only them who keep themselves unhappy, while they point
to the outside world to be the reason for their uncontrolled emotions. Powerlessness.

They are seemingly really unable to escape from their mental cage. And unwilling?

The word I need is: Ugly.
Mankind is   Rich countries are really in a pitiful state. -->

Sarcastic joke 1
"Successful Capitalism is a ..."
EDIT: deleted, those suffering from this affliction do not deserve to be compared to economics.
;-)

Sarcastic joke 2

The customs could consider to refuse entry into a beautiful holiday country
for those who are professional FUDers everywhere, and stamp their passports:

"
Sorry, but you must first go to a hotel in your own country for 1, 2, or 3 days
(depending on the severity of their affliction), to let go of your accumulated hatred ...
... before you only focus on spoiling your own, and everyone else's experience.
Entry refused, for x days. Please come back, we love to meet you again - relaxed.
"
 

*g*


Plenty of Positivity in Place

But still, myself I had an unforgettable holiday week. The longest time away from
the keyboard in ages, and I immediately clicked, and turned social, it was beautiful.
I was also able to find, and meet the minority; some people have come far, and
are amazing encounters. They are good teachers, discussion partners, joy givers, and
sources of wisdom, beauty, freedom, and creativity.  We are just so damn few.


What now?
How could more people liberate themselves from their personal hell?  I am puzzled,
more than ever. Should psychotherapy become obligatory in high school perhaps?

And what now ... does all that tell us about posting on internet forums?

My above rant is not about this following tip of the iceberg, more about the vast amount of highly unhappy people in rich countries (most of who are rather self-harming, and passive aggressive, but they then also spoil the experience for their environment), and who are proving (besides the ecological mess, gross inequality, and perpetual war) that our economic system is poison.

This post here is about the extreme cases of unhappiness. I give this short addendum, because by chance I came across a data-driven examination of the worst case scenario, when ~3% of users got eventually even banned for their utterances:

    Antisocial Behavior in Online Discussion Communities (http://arxiv.org/pdf/1504.00680.pdf)
    Justin Cheng, Cristian Danescu-Niculescu-Mizil, Jure Leskovec (Stanford University, Cornell University)

Three aspects when browsing through it:

• They establish a high predictive power (with their automatic language analysis system) who might be later get banned:
  "With these features in mind, we consider a prediction task where we observe a user’s first ten posts [...] we can accurately predict whether a user will be subsequently banned with a mean AUC of 0.82 (mean accuracy=0.74, mean F1=0.71)". (Page 8 )
  Impressive.
  
  
• "... posts written by FBUs are less readable [...], and differ in affective content such as swearing ..." (page 8 )
  
  
• Troll (FBU) posts usually get a much higher reply rate than non-troll (NBU) posts (page 5).

Ignoring affective content might be the best move to protect ourselves. We guessed it intuitively, now science is starting to prove it.

--> "Don't feed the troll (https://spreaditout.files.wordpress.com/2015/02/internet-troll-by-woody-hearn.jpg).".

 ;)

--> nxtforum.org/index.php?topic=9741.msg203055#msg203055 (https://nxtforum.org/index.php?topic=9741.msg203055#msg203055)

!
New 2016 price scheme:
EDIT: Retweet (https://twitter.com/altsheets/status/687390796593639424) please

AltFolio new version v52.01

Bug fix (thx to Kushed for finding it!)

v52:
* GoogleScript must have changed something in the way
    that formula cells are treated (versus data cells)
    --> "insert-one-more-row" now results in
    all column updates not working anymore.
* The fix is emptying the 6 respective new cells now.   


Existing users:
Get a new copy of the mastersheet (the SAFER way!)

OR (for experts  ;) )
Overwrite only the Script code with the v52.01 code

Menu ... Tools ... Script Editor ...
copypaste the whole "altsheets-scripts.gs" into your old 51.10


New users:

http://altfolio.ddns.net

 :)

---
retweet (https://twitter.com/altsheets/status/689693830371737600). thx.

AltFolio new version - now with HitBtc

https://i.imgur.com/pBZXHcr.png (https://twitter.com/altsheets/status/692016928085426176)

• try it out now: http://altfolio.ddns.net
• retweet please (https://twitter.com/altsheets/status/692016928085426176), thanks.

Thanks for adding support for HitBTC.com, now I can track Dashcoin(DSH) as well :)

Great tool, its a must have for SaluS alt portfolio.

-Kushed

#StartPeeps accelerates. Already story # 347,821 !

Story #‎ 516 was one of my first posts, six months ago.

347813 / 516 = 67406 percent, in 6 months.

Join through my referral:
https://startpeeps.com/index.php?tab1=welcome&affid=AltsheetsDev

I just couldn't accept this trouble :-) https://twitter.com/altsheets/status/694183057474068480


So I have implemented an alternative now, and done some time measurements:

comparing access to bittrex DOGE price: getticker?market= versus getmarketsummaries


sometimes the big call is even faster:

So I guess, I am switching to /getmarketsummaries - even though it is the much more massive return object.

And because I am Caching all results it will save time when prices for several coins are pulled from bittrex.


:-)


What? --> http://altfolio.ddns.net

ProgrammableWeb entry for AltFolio Dataserver

https://i.imgur.com/V2TRQ0R.png (https://i.imgur.com/V2TRQ0R.png)

Altfolio actually supports 11 APIs
(bittrex, bleutrade, btce, bter, ccex, cryptsy, hitbtc, poloniex, yobit, bitstamp, kraken)

but only these 6 have a homepage at ProgrammableWeb

http://www.programmableweb.com/mashup/altfolio-altcoin-portfolio-tracker

retweet (https://twitter.com/altsheets/status/694946361192681472)

Some of my SOIL contributions


and quickie on my Other projects

Hooray, AltFolio is the ... Affiliate of the Day... at SaluS coin!


More info in the SaLuS thread (https://bitcointalk.org/index.php?topic=1317448.msg13942884#msg13942884).

EDIT: Retweet (https://twitter.com/altsheets/status/700818622239924224) please, thx.

Added cryptopia to my DataServer

https://i.imgur.com/4NlUPBz.png

retweet please (https://twitter.com/altsheets/status/701810590906503168) - thx.


EDIT: This coding half-day was inspired by FLY coin (https://bitcointalk.org/index.php?topic=1316737.msg13973841#msg13973841).

Hi,

I would like to try your product

I've checked coinfinance, cryptotrack and cointracking and they are all bs.

Few q

Bleutrade, Cryptopia and Yobit exchange coins included?

Can I add more columns and more graphs to the sheet?

Good. Trial is free: http://altfolio.ddns.net

Yes. That is why I had started building my own.

And my solution is most flexible, as you can configure it freely,
the frontend is your personal copy of my master spreadsheet.
Powerful - and still easy for noobs, as I colorcoded it all by function.


Yes, API-accessed are all the BTC pairs from
   bittrex
   bleutrade
   btce
   bter
   ccex
   cryptopia
   cryptsy
   hitbtc
   poloniex
   yobit

plus for fiat
   bitstamp
   btce
   kraken
   hitbtc

And if you miss your favorite exchange, I can implement it. Happy about donations for that.


More graphs?
Yes please, I'd be very interested to see what you come up with!


More columns to add?
   First of all: Yes, definitely. Easily.


However, at the moment, the automatic columns are hardcoded, so to keep their function alive
they cannot be moved left or right. Still, no problem - there are ways to introduce other columns:

   EITHER use the empty columns T or AE and behind - that is the easiest.

   OR use some of the balance columns D-J, and change the sums in K - that is quick, and gives you 7 more columns.

   OR add a sheet (+), and import my data via   =Portfolio!p6   etc. - that is the most flexible
   OR make a new file, and use    =importrange(id,"Portfolio!n6:q8")   - that is the most advanced, and allows sharing

   OR tell me which other functions you need - and I might perhaps implement them.


Perspective: If more people are doing their own mashup of my frontend layout,
I could implement a version, in which the automatic columns are not hardcoded,
but searched for, and recognized by an anchor. So you see:

Lots of possibilities, and all say:

Yes.

 ;)

Definitely, it sounds good to me!! :)

No need of more exchanges.

A lot of posibilities with columns, so I'll find one I can manage.

The graphs I would like to add are:

Related to new columns:
- Where do I save them (Exchange, wallet or hardwallet)
- Where do I save them_2 (Which exchange, where is the wallet, which hardwallet)
- Mail used to create the account (1,2,3,4,5)
- Market cap
VVB       > 10M $
VB       > 1M $
B      < 1M $
M      < 500K $
S      < 100K $
VS      < 50K $
VVS      < 25K $
VVVS   <5K $
- Category ( BTC, 2.0 , M, V) (M means its worth it) (V means will see if it's worth it)
- Sector (Anonimity, Sex, Weed, Teleco, Country...)



Special tables

- Winners and Losers of 1h, 1d, 7d
(havent tried yet, but I think I can see my portfolio and order it from winners to losers, but I mean a special table where the coins change depending on the data. It just save one/two click but it's a lot more visual.)

- Map of my portfolio. Looking green if it's up, looking red if it's down.
(Visual of all my portfolio. Just checking the color of the map I can see the overall trend of the market) 



I'll try out this night :)

Lots of interesting ideas, thanks!

Sounds as if you are looking for a database where
you can store all the information related to each of your coins.

Parts of the questions you are pondering ... are already implemented (e.g. marketcap rank).


Yes please.

Fully check out what AltFolio (http://altfolio.ddns.net) is offering already
- try out all the functions in the ALTFOLIO-MENU.

Then it is easier to talk.

Have fun with it!

:-)

I already got that database but I hate updating it.

I'l post some pics so you can see how data is organized.

Is there anyway to link your server with my database or I have to move my database to your doc?

On my dataserver logs, I can see that you have connected your sheetcopy
with the dataserver, and already input your first coinnames - very good.

That is, by the way, everything that I can know about your portfolio
* the coin names, and * your choice of exchanges where to pull the data from.

(I cannot see your balances, as the sheetcopy is your personal copy where
only you have access. Just wanted to clarify that. I am privacy aware myself.)


And with "updating" ... you mean the current last price, or the trading volume, or the last 7hours price change?

Yes, that is what AltFolio (http://altfolio.ddns.net) is really useful for.


Cool. Interesting to see how people organize their knowledge.

However, if it contains personal data, better send it by email.


As usual, there are many ways to do it.
Depends a bit on the details, and goals.

Is your database also a GoogleSheet?

Perhaps then you can try to use the IMPORTRANGE function.
That way, you do not have to change the AltFolio GoogleSheet at all, and thus avoid breaking it.

But you can still pull the data out.

Please read this help page: https://support.google.com/docs/answer/3093340

I can also build a custom thing for you. Let's discuss that by email.

 :D

That was an interesting session. It inspired me to publish parts as a FAQ now ...

Nice one. Keep it up. Keep updating it and you won't go wrong. Looks like the start of something very good :)

Yes, I know - I am on to something there.

Data driven trading is helping my own trading much,
to avoid bad trades,
to react faster
to not to overlook and miss opportunities,
to keep an overview of my portfolio,
etc.

- and AltFolio is the publicly available part. To share parts of
my creations with other users - is making that product better.

Help me to sell it more often ;-)  then I can afford the time to upgrade it more.
Next thing I am trying out right now is a daily history function, so that
I can later see how it actually happened when I got to my first million  ;-D

Very nice - thank you

https://upload.wikimedia.org/wikipedia/commons/f/fd/Nuvola_apps_biology.png

for the flowers.       :-)

Please you spend some time with it (http://altfolio.ddns.net). Feedback is much appreciated.

Do not use the old donation addresses anymore
- but they are gone from your sheetcopy now anyways.

So cool.

I had forgotten that whole functionality actually - but now it came in VERY handy.

https://i.imgur.com/trIK92k.png (https://twitter.com/altsheets/status/723325943683670016)

retweet (https://twitter.com/altsheets/status/723325943683670016) - thx.

(their tweet (https://twitter.com/ShapeShift_io/status/723167397092450304) that made me realize it)

 ;)

Totally off-topic ... but a brilliant list of "life-hacks".
Thanks to David Orban, and his good newsletter (http://davidorban.com/). Literally cited:

--- --- ---

Peter's Laws
Peter Diamandis is the founder of XPRIZE, Singularity University, and many other fascinating initiatives. He formulated his provocative laws, which for me have always been an inspiration! Now they have also been translated into Italian, and other translations are ongoing.

If anything can go wrong, Fix It!!... to hell with Murphy!
When given a choice... take both!!
Multiple projects lead to multiple successes.
Start at the top then work your way up.
Do it by the book ... but be the author!
When forced to compromise, ask for more.
If you can’t win, change the rules.
If you can’t change the rules, then ignore them.
Perfection is not optional.
When faced without a challenge, make one.
“No” simply means begin again at one level higher.
Don't walk when you can run.
When in doubt: THINK!
Patience is a virtue, but persistence to the point of success is a blessing.
The squeaky wheel gets replaced.
The faster you move, the slower time passes, the longer you live.
The best way to predict the future is to create it yourself!
The ratio of something to nothing is infinite.
You get what you incentivize.
If you think it is impossible, then it is... for you.
An expert is someone who can tell you exactly how it can’t be done.
The day before something is a breakthrough it’s a crazy idea.
If it were easy it would have been done already.
Without a target you’ll miss it every time.
Fail early, fail often!
If you can’t measure it, you can’t improve it.
The world’s most precious resource is the persistent and passionate human mind.
Bureaucracy is an obstacle to be conquered with persistence, confidence and a bulldozer when necessary.

You can find the original English language poster (https://www.singularityweblog.com/wp-content/uploads/2012/08/PetersLaws-Poster-Final-8.5x11-08072012.pdf) ready for printing online, and the Italian language poster (https://drive.google.com/file/d/0B2TuTPfi9PipaWVWbGhVaVdhOEk/view?mc_cid=39790842cc&mc_eid=29eb86e0f0), too.

--- --- ---

https://www.singularityweblog.com/wp-content/uploads/2013/08/Peter-Diamandis-Laws.jpg (https://www.singularityweblog.com/peter-diamandis-laws-the-creed-of-the-persistent-and-passionate-mind/)

I'm using this service and it working fine for me.
why there no more people using it?  ???

Sorry for not answering earlier. Busy winter.

Great, I am happy. Thanks for posting!  

PM me, and I'll gift you a serial extension.


Perhaps you also want to tweet/facebook (https://twitter.com/altsheets/status/827604565210050560) about  altfolio.ddns.net?  Are you interested in a reseller bonus?



That is a puzzling question for myself too.

I have powerusers who have queried my dataserver already more than 100,000 times.

Probably there is some "spreadsheet fear" illness out there :-) But I think I did a good job at making it as easy as possible.

Thanks but i'm busy now so I dont think I could sell too many.
Anyway if you want to give me a reseller bonus if I get new people, it's fine for me  :)

I think wallst people will be more used to using spreadsheets, so it may be there the opportunity.
some ads could also help  ;)

Hi,

how is all going over here?

new users coming into cryptos during this months, do they know about this awesome product?

Very good, thanks for asking.

Just very busy. But busy in a good way  ;)


Yes, I am seeing that. There is renewed interest in my product.



hey - what about you making them aware?  Become a reseller. I am willing to share a chunk of my profit.

Hi,

I'm not getting any single piece of data in my sheet  ???

Please solve it...

solved. apologies.

thanks!

what is the status ? there is no update for long time

People are using it. I am using it. It has not caught on virally though.
I offer reseller bonus, PM me if you are good at selling SaaS.

The CMC part is offline at the moment, because the data intermediary I had been using for years,
to get preformatted CMC data, is suddenly offline, and does not seem to come back up.
The only choice I have now, is rebuild that part of the API fetchers. Which I will do ASAP.

GoogleSheets has introduced a new layer of "security", so initially it takes a few
more clicks to authenticate my code to be allowed to run and call my backend server;
but that needs to be done only once, so no big issue.
Sometimes GoogleSheets is failing, and that creates hickups in my frontend
- but as that is on Google's side, I cannot do anything but ask for patience until they are back on track.


Other than that, all is working well. Especially the Python Dataserver backend.
There have been literally hundreds of thousands of calls to my server.
I am impressed myself at how stable it runs.
Today I have just restarted the whole dataserver - it had been running flawlessly for 248 days.

Are you using AltFolio yourself?

Wanna try?   http://altfolio.ddns.net


.

0.23BTC is not $98 anymore :)

Very true. Wow what a rise since only 2y ago. If only I had kept more BTC from back then  ;)

Translate the USD price yourself.

Do you like altfolio ?

Frankly, didn't try it...I was just checking for portfolio app that could pull data directly from API

If that "pull data directly from API" is about updated prices, change24, volume, CMC-rank, etc. - then you have found your solution. A solution, at least.


My system has two components:

- the frontend is a GoogleSheets spreadsheet, with additional GoogleScript functions to do cool stuff

- a dataserver backend which can compile data from many different sources, and concurrently.


The second was necessary, because every exchange has a different API format, and because GoogleSheets just collapsed under the load of too many concurrent requests.

Hey,

I'm not getting any data now. Please check

Rw

Yes, sorry. Had been on holidays, and offline - so I did not notice. Should be fixed anytime soon.

Everyone: PM me your altsheets-dataserver-serial code, then I'll gift you a month.



EDIT: All good again, problem is fixed.