create account

Portfolio Management Excel by jahnnydns

View this thread on: hive.blogpeakd.comecency.com
· @jahnnydns · (edited)
$0.66
Portfolio Management Excel
Hi guys,
I created a crypto wallet manager and thought it might be useful to someone.
The sheet consists of two pages:
General monitor both of the prices of some crypto, and of the quantities divided in the various exchanges, percentage of the portfolio divided into Coins. You also have an automatic calculator at the top DX to see the price of a given coin, based on the quantity
Page where you fill in the data regarding the quantity of coins present in the various exchanges. Exchange calculations with EUR or USD are automatic

![image.png](https://files.peakd.com/file/peakd-hive/jahnnydns/23tmf9hN7PWu8pmwDmrfKUC1Sy39i8avB8JzhjmMngDtwZFGo3YdhFk7jXpor2xerseNq.png)

EDIT ONLY THE RED PART ACCORDING TO YOUR NEEDS !!!

P.s I was trying to integrate it with Notion through automation programs like zapier, in which he sends me a weekly report of the value of the portfolio. Or create me a sheet weekly with the totality of the portfolio value. But I'm not sure how to develop it if anyone has any ideas please don't hesitate to contact me.
The link is below, you can download it, but I recommend you use it from Drive in order to synchronize prices.

https://docs.google.com/spreadsheets/d/1lcOLtLVQeJ4iMXsmrsakrv0Jy8j_pajp-x4XPLeVMKs/edit#gid=0[Google Sheet Portfolio Manager](https://docs.google.com/spreadsheets/d/1lcOLtLVQeJ4iMXsmrsakrv0Jy8j_pajp-x4XPLeVMKs/edit#gid=0)
👍  
properties (23)
authorjahnnydns
permlinkportfolio-management-excel
categoryexcel
json_metadata{"app":"peakd/2021.09.1","format":"markdown","tags":["excel","wallet","manager","coins"],"users":[],"image":["https://files.peakd.com/file/peakd-hive/jahnnydns/23tmf9hN7PWu8pmwDmrfKUC1Sy39i8avB8JzhjmMngDtwZFGo3YdhFk7jXpor2xerseNq.png"]}
created2022-01-10 18:58:00
last_update2022-01-10 19:22:54
depth0
children0
last_payout2022-01-17 18:58:00
cashout_time1969-12-31 23:59:59
total_payout_value0.329 HBD
curator_payout_value0.329 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,377
author_reputation167,445,723,139
root_title"Portfolio Management Excel"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id109,354,754
net_rshares385,829,593,415
author_curate_reward""
vote details (1)