#96 FIFO Calculation for Portfolio report

open
nobody
None
5
2012-11-18
2010-09-09
Anonymous
No

I have found following issue with the
Portfolio report calculation. (After it started running. :))
I have done following transactions for one stock in past one year
DATE TRANSACTION PRICE QTY
1-Jan-09 BUY 546.80 30
30-Mar-09 SELL 889.00 30
1-Feb-10 BUY 296.75 50
As per above transactions, I have bought and sold same security over a
period of time.
As per the calculations, my Actual Reliased Profit is 10266 and Avg.
Price of the Stock is 296.75 as on date.
If I run the report on 30-Mar-09, I will also see the realized profit
as 10266.
But after the Buy transaction goes for a toss.
Now I see following data in the report
Reliased Profit as per report = 14954 and Avg. Price is 390.52.
As per my observation the report is designed to take all the buy
transactions to calculate the avg. price and that is being used to
calculated rest of the values.
But in my opinion the report should work on FIFO basis to calculate
values, to have correct realized profit as well as avg. price.

Discussion


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks