Crypto - Previous Position tracker
Hi All, i am a financial modeller who got into Crypto a few months ago and this morning i decided it was time to create a proper Microsoft Excel spreadsheet what will inform me of movements from my previous position, i.e. last checked date vs latest checked date. It is my 1st draft of the tool and i would appreciate peoples feedback.
PSB a link to Imgur which demonstrates how it currently looks, its quite simple atm, needing just ticker + coin volume inputs + a press of a button to create the information.
Please advise me if you wish to test it as i am looking to get feedback so that i can improve it as i will be using it alongside the other tools i use.
http://imgur.com/gallery/1TLiN
Select the base currency (Currently BTC and ETH)
Main input to insert Tickers + number of coins
View of main table
Orange/Tan cells are the inputs requiring just Number of coins + Ticker
Outputs are;
Price per coin in chosen Base unit (BTC or ETH)
Total price in chosen base unit
Total price in USD (other currencies to be added later)
Visible last updated date stamp
Simple summary tab
comparisons between last and current retrieve
Varianes
hi and welcome to steemit. Nice to see another Excel expert here. You might be interested in joining the business Intelligence tag and community #bisteemit would love to have you on board
Hi, thanks for the advice, i've made a draft available and posted it into that section.
Great post you earned a new follower from @thefollower -_- Like money? Read my blogs for more!