Excel Cryptocurrency Portfolio

Thread replies: 12
Thread images: 3

Anonymous
Excel Cryptocurrency Portfolio 2017-09-08 05:58:14 Post No. 3395193
[Report] Image search: [Google]

File: Clipboard01.jpg (48KB, 913x663px) Image search: [Google]

Excel Cryptocurrency Portfolio Anonymous 2017-09-08 05:58:14 Post No. 3395193 [Report]

This is an Excel cryptocurrency portfolio template I've made to share with you /biz/. It grabs stats on coins from CoinMarketCap.com and keeps track of transactions and what wallets/exchanges you use.

https://mega.nz/#F!OQFAnBIA!jTYWnDUg3vIlpAxaRMdzEg

I've separated the script module from the spreadsheet because people keep thinking it's a macro virus, even though it's not. In order for the spreadsheet to grab stats, you need to hit Alt+F11 and import the file named Cryptocurrency_Module.bas, save the spreadsheet as a .xlsm, then restart it to have it load stats.

If you want to see what's in the module, just open it up in notepad. You'll see this: https://pastebin.com/raw/wFBkinHB which, as you can see, just grabs data by URL from the CoinMarketCap API.

Feel free to post any suggestions for improvement as well.

If you like my work and would like to donate:
BTC: 1H3byn8uySsrEqWmX2EvZBCM4KYvd6xJ7z
ETH: 0xab907b05Eaf8fBFdc2CeA6e2e2Fd57ddBE08F71f

Enjoy!

Anonymous 2017-09-08 06:10:51 Post No.3395321
[Report] Image search: [Google]

Anonymous 2017-09-08 06:10:51 Post No.3395321 [Report]

File: Clipboard02.jpg (70KB, 1005x176px) Image search: [Google]

70KB, 1005x176px

The Crypto_Stats sheet is the only sheet that grabs from the CoinMarketCap API.

It looks like pic related, and can be updated to look for any coins you want. Just add a row to the table, and enter the coin name.

If it doesn't find the coin, go to CoinMarketCap.com > Click on your coin > Tools tab then at the bottom it will say the API URL. Enter your coins name in the spreadsheet the way it looks in that URL.

Anonymous 2017-09-08 06:17:12 Post No.3395383
[Report]

Anonymous 2017-09-08 06:17:12 Post No.3395383 [Report]

Thoughts?

Anonymous 2017-09-08 06:19:14 Post No.3395403
[Report]

Anonymous 2017-09-08 06:19:14 Post No.3395403 [Report]

I'll try it when I get home anon, too busy being a wagecuck right now.

Anonymous 2017-09-08 06:25:11 Post No.3395464
[Report]

Anonymous 2017-09-08 06:25:11 Post No.3395464 [Report]

>>3395403
Thanks man.

I just want to show it off. I'm pretty proud of it.

Anonymous 2017-09-08 06:28:59 Post No.3395514
[Report]

Anonymous 2017-09-08 06:28:59 Post No.3395514 [Report]

>>3395403
Enjoy your malware

Anonymous 2017-09-08 06:30:38 Post No.3395538
[Report]

Anonymous 2017-09-08 06:30:38 Post No.3395538 [Report]

>>3395514
Hey, did you even read the OP?

I removed the script. It's just a basic excel sheet.

Anonymous 2017-09-08 06:31:36 Post No.3395546
[Report]

Anonymous 2017-09-08 06:31:36 Post No.3395546 [Report]

>>3395193

If you really want to share it with us, post the VBA code here.

Anonymous 2017-09-08 06:36:16 Post No.3395596
[Report]

Anonymous 2017-09-08 06:36:16 Post No.3395596 [Report]

>>3395546
I did. Didn't you see the pastebin link?

Anonymous 2017-09-08 07:05:16 Post No.3395957
[Report]

Anonymous 2017-09-08 07:05:16 Post No.3395957 [Report]

Please respond.

Anonymous 2017-09-08 07:14:20 Post No.3396059
[Report] Image search: [Google]

Anonymous 2017-09-08 07:14:20 Post No.3396059 [Report]

File: 1503909008506.gif (2MB, 260x320px) Image search: [Google]

2MB, 260x320px

If this is genuine thx OP, i wont download though cuz those pajeets all want my Private keys.. cant be safe enough these days

Anonymous 2017-09-08 07:18:05 Post No.3396103
[Report]

Anonymous 2017-09-08 07:18:05 Post No.3396103 [Report]

>>3396059
It is.

I don't understand why /biz/ is so paranoid. Does money do this to you?

I'm aware that Imgur.com will stop allowing adult images since 15th of May. I'm taking actions to backup as much data as possible. Read more on this topic here - https://archived.moe/talk/thread/1694/

I'm aware that Imgur.com will stop allowing adult images since 15th of May. I'm taking actions to backup as much data as possible.
Read more on this topic here - https://archived.moe/talk/thread/1694/