Bitcoin Forum
June 14, 2024, 08:15:57 PM *
News: Voting for pizza day contest
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Track your crypto portfolio using excel easy!  (Read 225 times)
grazeppelin (OP)
Jr. Member
*
Offline Offline

Activity: 40
Merit: 3


View Profile
September 26, 2019, 05:00:10 AM
Last edit: September 26, 2019, 12:59:15 PM by grazeppelin
 #1

Hello everyone, today I will share with you my newest creation , a cryptocurrency tracking excel sheet to track your investments that draws prices from coinmarketcap.com

Google Drive:

https://drive.google.com/file/d/1XNaJ-Ouizb24cHMNjAym9byyjeEynync/view

pass: crypto123

How to use:

Download and open the excel sheet , accept the notifications , input your portfolio , click update

I hope you will enjoy this , consider donating if you like it , have a nice day!

EDIT: Download the XLS from the google drive link then run it so the script to update prices works!
Davian144
Hero Member
*****
Offline Offline

Activity: 2562
Merit: 578


Next Generation Web3 Casino


View Profile
September 26, 2019, 05:15:41 AM
 #2

Incredibly, this can help those who like to invest in crypto, and because I rarely invest in crypto, but I'm also interested in trying it out, although it's not very important for me personally, because basically I'm not an investor in crypto.

█████████████▄▄▄▄▄▄▄█████▄
█████████████▄▀███████▄▄
███████▄▄████▀▄██▀▀█▀██▄▄▄██▄▄
█████▄████████████████▄▀█▄██████▄▄
████▀▄█▄█████████████████▄▀█████████▄
░▄█████████████████████▄▄▄██████████
█████████████████████████████████
▀████████████████████▀██████▌████
░▀████████████████████▀▄█▀███▀████
░░▀███████████▀████████▀▄███████
███▀█████████████▀██████████████
████▀████████████████▀██████████
█████▀██▀▀██████████████▀█████▀

██████    ██
██
██
██
██
██
██
██
██
██
██████████
       ▄▄▄██▄▄▄
    ▄███████████▄
    █████████████▄
   ███████████████
▄█████████████████▄
▀▀▀▀█████████████▀██
    ▀█████████████▄
    ▄▀█████████████▄
   █▀ ▀▀▀██████████▌
▐███    ▄█████████▀▀
 ▀▀     ▄█████▀▀
       ███▀▀
      ██▀

██████
██
██
██
██
██
██
██
██
██
██████
JeffBrad12
Hero Member
*****
Offline Offline

Activity: 2814
Merit: 524


Leading Crypto Sports Betting & Casino Platform


View Profile
September 26, 2019, 06:35:31 AM
 #3

It's easy to use it and i appreciated. But, im willing to ask you about have you ever tried to use a mobile portfolios app? It's the easiest way to track our portfolios anytime consider about the fact that when we wanna access excel and that needs a personal computer (maybe you can access it through your phone but it's complicated)
But it's good enough and good job.

..Stake.com..   ▄████████████████████████████████████▄
   ██ ▄▄▄▄▄▄▄▄▄▄            ▄▄▄▄▄▄▄▄▄▄ ██  ▄████▄
   ██ ▀▀▀▀▀▀▀▀▀▀ ██████████ ▀▀▀▀▀▀▀▀▀▀ ██  ██████
   ██ ██████████ ██      ██ ██████████ ██   ▀██▀
   ██ ██      ██ ██████  ██ ██      ██ ██    ██
   ██ ██████  ██ █████  ███ ██████  ██ ████▄ ██
   ██ █████  ███ ████  ████ █████  ███ ████████
   ██ ████  ████ ██████████ ████  ████ ████▀
   ██ ██████████ ▄▄▄▄▄▄▄▄▄▄ ██████████ ██
   ██            ▀▀▀▀▀▀▀▀▀▀            ██ 
   ▀█████████▀ ▄████████████▄ ▀█████████▀
  ▄▄▄▄▄▄▄▄▄▄▄▄███  ██  ██  ███▄▄▄▄▄▄▄▄▄▄▄▄
 ██████████████████████████████████████████
▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄
█  ▄▀▄             █▀▀█▀▄▄
█  █▀█             █  ▐  ▐▌
█       ▄██▄       █  ▌  █
█     ▄██████▄     █  ▌ ▐▌
█    ██████████    █ ▐  █
█   ▐██████████▌   █ ▐ ▐▌
█    ▀▀██████▀▀    █ ▌ █
█     ▄▄▄██▄▄▄     █ ▌▐▌
█                  █▐ █
█                  █▐▐▌
█                  █▐█
▀▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀█
▄▄█████████▄▄
▄██▀▀▀▀█████▀▀▀▀██▄
▄█▀       ▐█▌       ▀█▄
██         ▐█▌         ██
████▄     ▄█████▄     ▄████
████████▄███████████▄████████
███▀    █████████████    ▀███
██       ███████████       ██
▀█▄       █████████       ▄█▀
▀█▄    ▄██▀▀▀▀▀▀▀██▄  ▄▄▄█▀
▀███████         ███████▀
▀█████▄       ▄█████▀
▀▀▀███▄▄▄███▀▀▀
..PLAY NOW..
jessyj48
Member
**
Offline Offline

Activity: 756
Merit: 14


View Profile
September 26, 2019, 07:02:54 AM
 #4

Hello everyone, today I will share with you my newest creation , a cryptocurrency tracking excel sheet to track your investments that draws prices from coinmarketcap.com

Google Drive:

https://drive.google.com/file/d/1XNaJ-Ouizb24cHMNjAym9byyjeEynync/view?usp=sharing

pass: crypto123

How to use:

Download and open the excel sheet , accept the notifications , input your portfolio , click update

I hope you will enjoy this , consider donating if you like it , have a nice day!
Nice but still very new,you should consider getting that on playstore and ios market for better awareness, i am better off with blockfolio app because apart from price monitoring you will always get news and updates that are base on the coins and token you are tracking

Swaap | Nova Bank
----------------------------------------------
[ GET | ACCEPT | EXCHANGE | WALLETS ]
1982dre
Hero Member
*****
Offline Offline

Activity: 1372
Merit: 512



View Profile WWW
September 26, 2019, 07:05:40 AM
 #5

Hello everyone, today I will share with you my newest creation , a cryptocurrency tracking excel sheet to track your investments that draws prices from coinmarketcap.com

Google Drive:

https://drive.google.com/file/d/1XNaJ-Ouizb24cHMNjAym9byyjeEynync/view?usp=sharing

pass: crypto123

How to use:

Download and open the excel sheet , accept the notifications , input your portfolio , click update

I hope you will enjoy this , consider donating if you like it , have a nice day!
Nice but still very new,you should consider getting that on playstore and ios market for better awareness, i am better off with blockfolio app because apart from price monitoring you will always get news and updates that are base on the coins and token you are tracking

the excel looks nice but as you say blockfolio is way more easier. Used it for a few years now and still happy with it.

But for some users this worksheet could be very helpful

.....1% HOUSE EDGE.....
.....FAUCET 3.5K...........
.....RAINBOT
10K..........






















█████
 █████     ███
  █████     ███     █
   █████     ███     █
    █████     ███     █
     █████     ███     █
      █████     ███     █

     █████     ███     █

    █████     ███     █

   █████     ███     █

  █████     ███     █

 █████     ███

█████
..DuckDice..
█████
███     █████
█     ███     █████ 
█     ███     █████  
█     ███     █████   
█     ███     █████    
█     ███     █████     
█     ███     █████
    
█     ███     █████
   
█     ███     █████
  
█     ███     █████
 
███     █████

█████






















.....★  B O N U S E S.....
.....
  L O T T E R Y......
.....
  J A C K P O T......
Godstrength
Jr. Member
*
Offline Offline

Activity: 191
Merit: 1


View Profile
September 26, 2019, 07:08:28 AM
 #6

Great share though and integration. Maybe what it lacks now or what the users will long for is a beautiful UI. But still, amazing things like this should be rewarded similar to what other projects do, rewarding crypto to their loyal shoppers. You can anyways receive tips and crypto if someone is super generous here, lol.

What I use now is the new CMC app for portfolio tracking, same thing with blockfolio where it shows news/updates basing on the variety of coins that you own. But I just like CMC's more since that's what I've been used to for a while now.
Bitbtc8
Full Member
***
Offline Offline

Activity: 1148
Merit: 116



View Profile
September 26, 2019, 07:12:30 AM
 #7

Blockfolio is the best to me and comparing blockfolio with this app i will still choose blockfolio because its still very new and i don't trust new apps easily and secondly blockfolio has better popularity, news updates too, your tracking app still needs lot of work and fixes

►           ►     enVoy            Sustainably Green Trust in Trade          ◄           ◄
►           ██  WHITEPAPER       ██  TWO PAGER       ██  TOKEN DECK           ◄
[vFacebook               [vTwitter               [vTelegram               [vMedium               [vLinkedin               [vReddit
knuckey
Sr. Member
****
Offline Offline

Activity: 1260
Merit: 251


View Profile
September 26, 2019, 08:43:47 AM
 #8

Blockfolio is the best to me and comparing blockfolio with this app i will still choose blockfolio because its still very new and i don't trust new apps easily and secondly blockfolio has better popularity, news updates too, your tracking app still needs lot of work and fixes
this is not an application for smart phones, but this is a creation of OP that uses excel to track a portfolio and OP creations are only used on computers. do you know excel? from microsoft?
Crypt0BHunter
Member
**
Offline Offline

Activity: 462
Merit: 10


View Profile
September 26, 2019, 08:46:42 AM
 #9

There are a lot of portfolio trackers apps on iOS Android and PC, me personally using Delta, it has a backup function and PC/Android version using it both.

MINTER - WE MINT COINS AND CREATE THE INTERNET OF MONEY
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
Telegram  |  Bip Wallet  |  Twitter
Onuohakk
Member
**
Offline Offline

Activity: 672
Merit: 29


View Profile
September 26, 2019, 09:13:20 AM
 #10

Hello everyone, today I will share with you my newest creation , a cryptocurrency tracking excel sheet to track your investments that draws prices from coinmarketcap.com

Google Drive:

https://drive.google.com/file/d/1XNaJ-Ouizb24cHMNjAym9byyjeEynync/view?usp=sharing

pass: crypto123

How to use:

Download and open the excel sheet , accept the notifications , input your portfolio , click update

I hope you will enjoy this , consider donating if you like it , have a nice day!
Nice but still very new,you should consider getting that on playstore and ios market for better awareness, i am better off with blockfolio app because apart from price monitoring you will always get news and updates that are base on the coins and token you are tracking

the excel looks nice but as you say blockfolio is way more easier. Used it for a few years now and still happy with it.

But for some users this worksheet could be very helpful
He just created his own excel newly, we should all try and support him by downloading it, to see how it works than comparing it with another existing one. You never can tell, it might be more easier and better than other excel

|   Facebook   |     Twitter     |                    R A N G E R S                    |    Discord    |    Medium    |
|    Telegram    |                    ─────     PROTOCOL     ─────                    |    Gitbook    |
████  ███  ██  █          VIRTUAL WORLDS BLOCKCHAIN INFRASTRUCTURE          █  ██  ███  ████
goto22
Jr. Member
*
Offline Offline

Activity: 56
Merit: 1


View Profile
September 26, 2019, 09:41:24 AM
 #11

Hello everyone, today I will share with you my newest creation , a cryptocurrency tracking excel sheet to track your investments that draws prices from coinmarketcap.com

Google Drive:

https://drive.google.com/file/d/1XNaJ-Ouizb24cHMNjAym9byyjeEynync/view?usp=sharing

pass: crypto123

How to use:

Download and open the excel sheet , accept the notifications , input your portfolio , click update

I hope you will enjoy this , consider donating if you like it , have a nice day!

It looks great, it could definitely be useful for someone new in crypto. Thanks for sharing.

⇧  (https://www.estimated.pro/) ⇧
▁▂▃▅▆▇ FREE PRICE PREDICTIONS ▇▆▅▃▂▁
mendra_2009
Full Member
***
Offline Offline

Activity: 429
Merit: 100



View Profile
September 26, 2019, 10:21:46 AM
Last edit: September 26, 2019, 10:32:23 AM by mendra_2009
 #12

Ok, this is good I really appreciate the OP for making this. But, since it is crypto portfolio tracker and seems is works offline, Looks like we should update the actual price of each token/coin we hold manually.
I think that's quite troublesome for me because it takes time to update the sheet. Would be awesome (but seems is too difficult Grin) if you can make this works online and then can update the price automatically.

vanya.pronin.1983
Member
**
Offline Offline

Activity: 378
Merit: 10


View Profile
September 26, 2019, 10:33:49 AM
 #13

Why not to use Blackfolio or any other application that tracks your investment in real time? It works great, is accessible on mobile devices and is much easier to interact with. I do not see any point in using excel instead of a regular app.
grazeppelin (OP)
Jr. Member
*
Offline Offline

Activity: 40
Merit: 3


View Profile
September 26, 2019, 12:40:55 PM
 #14

Posted an edit with some instructions
Decksperiment
Sr. Member
****
Offline Offline

Activity: 630
Merit: 250


View Profile
September 26, 2019, 01:15:46 PM
 #15

Why not to use Blackfolio or any other application that tracks your investment in real time? It works great, is accessible on mobile devices and is much easier to interact with. I do not see any point in using excel instead of a regular app.

Blockfolio is indeed a great app to track your crypto portfolio but I would like  to mention also the Delta app as an alternative which I personally prefer because it has its own unique features which I find attractive - https://play.google.com/store/apps/details?id=io.getdelta.android&hl=en  . These two apps should suffice our own crypto portfolio tracking needs and its up to us what we will choose.
grazeppelin (OP)
Jr. Member
*
Offline Offline

Activity: 40
Merit: 3


View Profile
September 26, 2019, 01:17:40 PM
 #16

Why not to use Blackfolio or any other application that tracks your investment in real time? It works great, is accessible on mobile devices and is much easier to interact with. I do not see any point in using excel instead of a regular app.

Blockfolio is indeed a great app to track your crypto portfolio but I would like  to mention also the Delta app as an alternative which I personally prefer because it has its own unique features which I find attractive - https://play.google.com/store/apps/details?id=io.getdelta.android&hl=en  . These two apps should suffice our own crypto portfolio tracking needs and its up to us what we will choose.

I personally do not use phone apps, I like the concrete view of an excel sheet that I can update and also modify using my own code !
dark08
Full Member
***
Offline Offline

Activity: 798
Merit: 104



View Profile
September 26, 2019, 01:19:23 PM
 #17

Hello everyone, today I will share with you my newest creation , a cryptocurrency tracking excel sheet to track your investments that draws prices from coinmarketcap.com

Google Drive:

https://drive.google.com/file/d/1XNaJ-Ouizb24cHMNjAym9byyjeEynync/view

pass: crypto123

How to use:

Download and open the excel sheet , accept the notifications , input your portfolio , click update

I hope you will enjoy this , consider donating if you like it , have a nice day!

EDIT: Download the XLS from the google drive link then run it so the script to update prices works!

I appreciated your excel work its easy to understand and use now I can track my altcoin porftfolio I'm switching with your excel.
Thank youso much for your hardwork to provide this kind of excel.

grazeppelin (OP)
Jr. Member
*
Offline Offline

Activity: 40
Merit: 3


View Profile
September 26, 2019, 03:56:25 PM
 #18

Hello everyone, today I will share with you my newest creation , a cryptocurrency tracking excel sheet to track your investments that draws prices from coinmarketcap.com

Google Drive:

https://drive.google.com/file/d/1XNaJ-Ouizb24cHMNjAym9byyjeEynync/view

pass: crypto123

How to use:

Download and open the excel sheet , accept the notifications , input your portfolio , click update

I hope you will enjoy this , consider donating if you like it , have a nice day!

EDIT: Download the XLS from the google drive link then run it so the script to update prices works!

I appreciated your excel work its easy to understand and use now I can track my altcoin porftfolio I'm switching with your excel.
Thank youso much for your hardwork to provide this kind of excel.



Glad you enjoyed it!
xOdiumNostrumx
Full Member
***
Offline Offline

Activity: 1064
Merit: 101



View Profile
September 26, 2019, 06:14:48 PM
 #19

Definitely an useful thingy, good job, but that being said, there is a ton of portfolio tracking apps out there with visually attractive UIs and additional functionalities, so I think I will stick with those ones.
beliomir
Full Member
***
Offline Offline

Activity: 539
Merit: 100



View Profile
September 26, 2019, 08:26:53 PM
 #20

Thanks, a very good table for a beginner. I use other tools to track my crypto assets. I like programs that work on api

                               Whitepaper     E M R X Token   :   LEARN MORE   
      E M I R E X         ─── إمركس ───          :         The Infrastructure for the
  [ telegram    facebook    TWITTER ]         New Digital Economy
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!