Trading Account

28 comments

  1. Hey! Thanks for the awesome excel model, it's great.

    The only thing is that on my Mac I get the following message when I open the file
    "This workbook contains content that isn't supported in this version of Excel.".

    I think we have the same version of excel so I think it's an OS issue, any suggestions?

    Reply
  2. my file not do update from website. how can i do option on excel?

    Reply
  3. Hey how do you add new bar for a new crypto

    Reply
  4. Hello, Great spreadsheet I've been using it for a couple months. As of ~10/22/17 mine stopped updating from the datasource. Anyone else expiernenceing issues?

    Reply
  5. I think it's a really good start! One thing I'm looking for is a comparison page. Example is it better to buy BTC with USD or buy it with ETC. I would want a quick comparison page. I should be able to build that with your document. Thank you!!

    Reply
  6. Hello. Thank you very much for your Excel sheet! Since today it stopped to calculate my numbers. Excel still sais "Calculate" and "copying web data to sheet". But nothing happens. Can you please help me? Thank you!

    Reply
  7. how would you add new coins? like btc gold ?

    Reply
  8. Alf, check this Crypto Analyser in a spreadsheet http://tinyurl.com/y9xdq8ym

    Reply
  9. I created a spreadsheet that automatically pulls your balance from Bitfinex, Bittrex, Kraken, Poloniex, GDAX and calculates your profit loss. More info, see Cointrexer

    Reply
  10. can i change the usd to eur?

    Reply
  11. I like your video BUT where is the download link? I am blind,

    Reply
  12. first off thanks. i would like to know if there is any way to turn the refresh to one hour?

    Reply
  13. IS THIS SAFE FROM MALWARE AND SPYWARE ?

    Reply
  14. For some reason certain currencies stopped updating. Ethereum and XRP show nothing when selected in the drop down, so this is messing up my entire portfolio since it basically says I don't own ETH or XRP. If you're still using the document, make a new tab and select XRP or ETH and you can see what I'm talking about. Any ideas on what's going on there? I have many different versions of this same document and all them will not show anything for certain currencies. What the heck is going on? Help!? Lol, thanks in advance!

    Reply
  15. Where can i find The document?

    Reply
  16. Perfect for what I need except .. as soon as the background query data runs or refreshes all the Net Gain fields blank out. Same with My BTC worth cell in summary .. all data disappears. I know you said you fixed the bug but seems there is still a fault.

    Reply
  17. Awesome video and I just Subscribed! However, I have a few questions. How do you show for exchanges? Lets say I trade 1 BTC for 500 OMG. How would I justify that on the tracker?

    Reply
  18. Hey there,

    Thanks for the excel doc, pretty cool that it pulls prices from world coin index.

    One issue though – when i enter a sell transaction, I enter the coin amount as a negative, and the net gain summary gets all screwed up. Any idea how to fix this?

    Reply
  19. hi man I would like to ask a question. Whenever I fill in my coins both 'My <insert coin> Worth' and 'Total Net Gain' won't work. They keep blank all the time. Do you know how I can fix this?

    Reply
  20. Thanks for the doc. It's just what I need. Just have a question how to set the refresh interval to 1 hour for example? And how to report if you sell a coin?

    Reply
  21. Values are not right- highs and lows arent correct. Expression.error 24H high of table wasn't found.

    Reply
  22. Hi C4jina,
    This looks great, thanks for sharing. I would love to download this sheet if it is available. Thank you again, great job!

    Reply
  23. Awesome spreadsheet, can you make more tabs for other currency?

    Reply
  24. Hello, can you make a google sheets version of this spreadsheet? thanks!

    Reply
  25. Thanks! What do you do when you buy your bitcoins at different dates and trade them for alt coins does it average out your cost? Also is it possible to lookup historic prices?

    Reply
  26. Amazing chart, thank you!

    Reply
  27. Thanks man, this is perfect!

    Reply
  28. Hi! Great worksheet! I'm trying to add NEO to the drop down but can't find how to do it within Excel. I can't seem to find and edit the reference list. Help would be appreciated!

    Reply

Leave a Reply