micky6strings
New Member
- Joined
- Apr 2, 2024
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello, this is my first post here and tbh I am not sure how to present this question, but here goes. I am quite new to excel, and I am trying to create a spread sheet that tracks my investments. I column A2:A40 I have my assets listed. In column B2:B40 I have the initial Investment cost, in column C2:C40 I have the amount of tokens, in column D2:D40 I have the average price, in column E2:E40 Profit/Loss for each token. I would like to be able to have a cell where I can add new purchases/sells of tokens, the price paid/received, and how many tokens were received/or removed. and that data is updated for the relevant tokens in column A. Is it possible to have something like this example, In cell H2 I input, Name XRP, Buy 100, Price 0.60, received 166.6. That data then gets transferred to the corresponding Tokens data in the A column. Is it even possible to add multiple variables in to one cell or is it easier to put that data into 4 cells. Hoping someone can help me with this. Thanks.