Topic: AltSheets AltFolio = AltCoin PortFolio - auto-updating spreadsheet & dataserver - page 2. (Read 19131 times)
March 07, 2016, 12:25:57 PM
Nice one. Keep it up. Keep updating it and you won't go wrong. Looks like the start of something very good
February 24, 2016, 01:12:06 PM
February 23, 2016, 05:13:48 PM
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.)
I already got that database but I hate updating it.
And with "updating" ... you mean the current last price, or the trading volume, or the last 7hours price change?
Yes, that is what AltFolio is really useful for.
However, if it contains personal data, better send it by email.
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.
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.)
Sounds as if you are looking for a database where
you can store all the information related to each of your coins.
you can store all the information related to each of your coins.
I already got that database but I hate updating it.
And with "updating" ... you mean the current last price, or the trading volume, or the last 7hours price change?
Yes, that is what AltFolio is really useful for.
I'l post some pics so you can see how data is organized.
Cool. Interesting to see how people organize their knowledge.However, if it contains personal data, better send it by email.
Is there anyway to link your server with my database or I have to move my database to your doc?
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.
February 23, 2016, 04:40:56 PM
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 is offering already
- try out all the functions in the ALTFOLIO-MENU.
Then it is easier to talk.
Have fun with it!
:-)
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).
I'll try out this night
Yes please.
Fully check out what AltFolio 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?
February 23, 2016, 01:57:13 PM
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 is offering already
- try out all the functions in the ALTFOLIO-MENU.
Then it is easier to talk.
Have fun with it!
:-)
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).
I'll try out this night
Yes please.
Fully check out what AltFolio is offering already
- try out all the functions in the ALTFOLIO-MENU.
Then it is easier to talk.
Have fun with it!
:-)
February 23, 2016, 01:48:03 PM
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?
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
February 23, 2016, 07:44:38 AM
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?
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.
February 23, 2016, 04:14:13 AM
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?
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?
February 22, 2016, 12:06:19 PM
Added cryptopia to my DataServer
retweet please - thx.
EDIT: This coding half-day was inspired by FLY coin.
retweet please - thx.
EDIT: This coding half-day was inspired by FLY coin.
February 19, 2016, 06:00:27 PM
Hooray, AltFolio is the ... Affiliate of the Day... at SaluS coin!
More info in the SaLuS thread.
EDIT: Retweet please, thx.
--=[ "Affiliate of the Day" ]=--
- AltSheets Altfolio - Portfolio Management for AltCoins -
More info in the SaLuS thread.
EDIT: Retweet please, thx.
February 12, 2016, 12:01:12 AM
Some of my SOIL contributions
and quickie on my Other projects
Perhaps you are interested in some of my other projects?
Enjoy
Useful SOIL manuals
Quick overview about some of my posts:
May those resources help you with SOIL.
Quick overview about some of my posts:
- Soil on Linux / in the cloud / via github.
- Upgrading to newer sourcecode is easy then, last upgrade to 1.4.0.
- my JSRE commands for easier handling of the gsoil attach client will work on any OS, just loadScript("altsheets.js")
- I have joined the stats node information service, incl. how to upgrade.
- Using my first ever smart contract: SOILfaucet - contract version.
- I mention the WTB/WTS soil thread (with those fabulous diagrams) only for historians, but hey - that was a lot of fun, no?
(Actually, here are even older posts of me on and around SOIL) - ABEESOIL block explorer extensions:
Launch, History & Screenshots, pages to explore, background research about ethereum API and uncle rewards.
May those resources help you with SOIL.
and quickie on my Other projects
Perhaps you are interested in some of my other projects?
- AltFolio - keeps a price-updated overview of your AltCoin portfolio, and value, with price data from 11 exchanges, and market data from CMC.
- My recent PeerExplorer is only one example for my many projects in HZ. I created cool network graphics of the whole network of wallet nodes.
- ... the latter is a subproject to improve my ChainCountDown image server - which I could actually one day port the SOIL too, if anyone's interested.
- The most beautiful is AssetGraphs-v2 - a new approach for a GUInterface; understand your own complex data intuitively better. Press "Start PRODUCT" to see it live.
- more
Enjoy
February 03, 2016, 02:26:15 PM
ProgrammableWeb entry for AltFolio Dataserver
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
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
February 03, 2016, 12:35:27 PM
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
So I have implemented an alternative now, and done some time measurements:
comparing access to bittrex DOGE price: getticker?market= versus getmarketsummaries
Code:
7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07
10 times single market call took: 4.34
7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07
10 times getmarketsummaries call and single market extraction took: 4.44
10 times single market call took: 4.34
7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07
10 times getmarketsummaries call and single market extraction took: 4.44
sometimes the big call is even faster:
Code:
7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07
10 times single market call took: 4.62
7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07
10 times getmarketsummaries call and single market extraction took: 3.73
10 times single market call took: 4.62
7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07 7.1e-07
10 times getmarketsummaries call and single market extraction took: 3.73
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.
Code:
print "comparing access to bittrex DOGE price: getticker?market= versus getmarketsummaries"
import timeit
T=timeit.default_timer
b=T()
for i in xrange(10):
print askBittrex("DOGE"),
print "\n10 times single market call took:", T()-b
b=T()
for i in xrange(10):
t=askBittrexForTicker()
p=selectPriceFromBittrexTicker(ticker=t, acronym="DOGE")
print p,
print "\n10 times getmarketsummaries call and single market extraction took:", T()-b
import timeit
T=timeit.default_timer
b=T()
for i in xrange(10):
print askBittrex("DOGE"),
print "\n10 times single market call took:", T()-b
b=T()
for i in xrange(10):
t=askBittrexForTicker()
p=selectPriceFromBittrexTicker(ticker=t, acronym="DOGE")
print p,
print "\n10 times getmarketsummaries call and single market extraction took:", T()-b
:-)
What? --> http://altfolio.ddns.net
January 28, 2016, 08:27:23 AM
#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
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
January 26, 2016, 01:06:44 PM
AltFolio new version - now with HitBtc
- try it out now: http://altfolio.ddns.net
- retweet please, 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
January 26, 2016, 11:21:04 AM
AltFolio new version - now with HitBtc
- try it out now: http://altfolio.ddns.net
- retweet please, thanks.
January 20, 2016, 01:33:02 AM
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. thx.
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. thx.
January 13, 2016, 04:14:13 PM
!
New 2016 price scheme:
New 2016 price scheme:
AltFolio Prices
0.094 BTC for 3 months (39 USD)
0.138 BTC for 1/2 year (59 USD)
0.230 BTC for 1 year (98 USD)
= "Less than a quarter bitcoin per year"
... adapted to new BTC=427 USD in early 2016.
Free trial now.
EDIT: Retweet please 0.094 BTC for 3 months (39 USD)
0.138 BTC for 1/2 year (59 USD)
0.230 BTC for 1 year (98 USD)
= "Less than a quarter bitcoin per year"
... adapted to new BTC=427 USD in early 2016.
Free trial now.
December 07, 2015, 03:57:44 PM
Quote from: altsheets
Milestone!
1st customer served!
I have just sold a "buyer perspective" app of assetgraphs-v2.
Yiehah! 
-----
Edit: retweet
1st customer served!
I have just sold a "buyer perspective" app of assetgraphs-v2.
Yiehah!
-----
Edit: retweet
--> nxtforum.org/index.php?topic=9741.msg203055#msg203055
November 08, 2015, 11:43:10 AM
New Products released!
AssetGraphs v2
Visit the new website:
/assetgraphs/v2/products
shorturl: 2020.fm/ag2
Please retweet at
twitter.com/altsheets/status/663391393281417216
- thanks.
Jump to: