| Index | Recent Threads | Who's Online | User List | Search |
|
|
 |
Portfolio123 » List all forums » Forum: Simulations and Portfolios » Thread: "PctGain" -- how is it calculated? |
|
Total posts in this thread: 2 |
[Request a Feature]
[Post new Thread] [Add To My Favorites] [Watch this Thread] |
| Author |
|
|
p123robert
Advanced Member CANADA Joined: Nov 7, 2005 Posts: 372 Status: Offline |
Hi Guys, Any one of you know how "PctGain" is calculated? A) Is it based on one's exact purchase price? Or, B) Is it based on the close of the day of purchase? For example, you bought XYZ (a mythical security) at 100.00 on 1/1/07. On that very same day, on 1/1/07, XYZ closed at 105.00. And yesterday XYZ closed at 110.00. Now, as far as "PctGain" is concerned, does XYZ have a 10% gain? Or, a 5% gain? Robert |
||
|
|
DennyHalwes
Advanced Member UNITED STATES Joined: Apr 28, 2004 Posts: 1532 Status: Offline |
Robert, This depends on whether you are running Sim or Ports. I assume that you are talking about the Function “GainPct” and about Ports. For Ports, assuming that you bought XYZ at 100.00 on 1/1/07 due to a Port recommendation, then the recommendation would be based on the closing price the previous day and the GainPct would be calculated passed on that price. So you would have to know the recommended price from the previous day's close to calculate the GainPct. Also, GainPct includes the fees and slippage. If you want the Port to calculate the actual % gain then you need to manually enter the actual price and date that you bought the stock. In this case use 0.0 for fees and slippage since they are already reflected in the price you paid for the stock. In Sims it depends on what setting you use for “Price for transactions”. If you use “Next Open”, “Previous Close”, or “next Average of High and Low” then the GainPct will be calculated based on that value + fees and slippage. The above also applies to the column "Pct" on the Transactions; Realized page. Denny  ---------------------------------------- "The significant problems we face cannot be solved at the same level of thinking that we were at when we created them". Albert Einstein ---------------------------------------- [Edit 1 times, last edit by DennyHalwes at Sep 13, 2007 1:15:29 PM] |
||
|
| [Show Thread Printable Version] [Post new Thread] |
Re: "PctGain" -- how is it calculated?
