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