CALLING SPREADSHEET GUY!!
Based spreadsheet guy, you posted a pic of your portfolio a couple days ago - pic related. I wanted to ask you a question but the thread was kill. Hopefully someone else might be able to answer it.
The image you posted is a perfect example of how you should record what you have invested in. But I was wondering, say if you wanted to accumulate more of a stock in your existing portfolio (at a different price than you initially paid for it) how would you add it to your spreadsheet? Would you create a separate cell in which you enter the new price you bought it at?
Thanks in advance lemme suck your dick too (no homo)
Also to clarify,
If you added to one of the stocks at a different price would you need to make a second column because the cost basis would be different?
>>1065257
>Would you create a separate cell in which you enter the new price you bought it at?
Yes. A new row with information relevant to that buy (Date, Cost Basis, Brokerate, etc.)
But it's all up to you because you're the only one looking at your own spreadsheets. Do whatever you can understand easily.
how can I use spreadhseets and spreadsheet software to analyze a company's fundamentals?
>>1066183
bump for interest
It should be organized how you want to do it for taxes. Lifo, fifo, weighted average.
My xom is fifo and voo is weighted average.