Crypto - Previous Position tracker

in #excel7 years ago

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)
BaseCurrency.JPG

Main input to insert Tickers + number of coins
TickerAndVolumes.JPG

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)
Main Input.JPG

Visible last updated date stamp
DateRetrieved.JPG

Simple summary tab
Summary.JPG

comparisons between last and current retrieve
Totals.JPG

Varianes
Variances.JPG

Sort:  

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!

Coin Marketplace

STEEM 0.19
TRX 0.18
JST 0.032
BTC 86998.67
ETH 3233.80
USDT 1.00
SBD 2.92