| |
| Simulator Updates / Progress Notes |
« View previous topic :: View next topic » |
| Author |
Message
|
| jdunn72 |
 Posted: Thu Apr 06, 2006 5:07 am Post subject: |
 |
|
Member of The Month
March
|
quote removed
Somehow, I never noticed that link, I thought all I had was the order que.. dag-nabit  |
|
| Back to top |
|
 |
| Dave Rathbun |
| Posted: Thu Apr 06, 2006 5:08 am Post subject: |
|
|
CFO
|
| Benjamin wrote: | I'm not what exactly sure what to call it. Return Detail? Trading Complexities?  Umm, Portfolio Detail? |
TMI (Too Much Information)
Seriously, call it Monthy Portfolio Status or Monthly Return or something. It doesn't show everything, it only shows values that impact the monthly calculation, so I think it has to have "month" somewhere in the name.
I can make each of the sections links to other appropriate screens too, like the Closed Trades can link to the Trading History screen (which shows all closed trades, not just those for this month), and the Transactions This Month can link to the Order Queue (which, like before, shows all trades, not just those that impact this month's return). |
|
| Back to top |
|
|
| Benjamin |
| Posted: Thu Apr 06, 2006 5:14 am Post subject: |
|
|
Administrator
|
| jdunn72 wrote: |
Somehow, I never noticed that link, I thought all I had was the order que.. dag-nabit |
Well that is my fault. It's my job to make the navigation as straightforward as possible. I think I really need to take a hard look at the entire sites navigation soon. |
|
| Back to top |
|
|
| Benjamin |
| Posted: Thu Apr 06, 2006 5:31 am Post subject: |
|
|
Administrator
|
| Everyone please look at the numbers and let us know if it looks correct. We had a lot of issues with the old system (Complaints) and here is the replacement, so let us know how we did! |
|
| Back to top |
|
|
| Dave Rathbun |
| Posted: Thu Apr 06, 2006 5:37 am Post subject: |
|
|
CFO
|
| jdunn72 wrote: | | Somehow, I never noticed that link, I thought all I had was the order que.. dag-nabit |
I can see why you made your comments, then, as the order queue doesn't have anything to do with calculating returns. 
There are 3 basic parts of the equation. You buy a stock, you hold a stock, you sell a stock. The Order Queue shows part 1 and 3. The portfolio screen shows part 2 (open positions) only. The trade history shows 1, and 3, as it shows the purchase information and the sale information and a calculated gain.
The new screen shows parts of all 3 areas, but just for this month.
The best news is that since we already have all the data we need (meaning I did not have to create a new t$ currency afterall) I can do the retroactive calculation. The only piece of missing information is the month ending quotes for any open positions. I'm going to be generating a list of stocks and months they were held, and I believe Benjamin is going to offer an e$ bounty for anyone willing to do the research and provide an XLS file with the stock symbol, the month, and the month ending quote.  That way we can calculate year-to-date values, and be able to display historical monthly return values as well. |
|
| Back to top |
|
|
| frusnak |
| Posted: Thu Apr 06, 2006 6:50 am Post subject: |
|
|
CFO
|
I should have been doing my own calculations as to what my earnings are, that way I would have some idea where this whole thing is on or off.
As it stands I will have to go with what you are coming up with whether I think it's right or wrong. When I look at one page I see one set of figures then there's another set on another page. And none of it seems to jive with what the stock challenge is. Please do not try to explain it to me I will go with what ever you come up with.
Do not mean to come across the wrong way, it just seem mtoo confusing to keep up with. Too bad we can't just start all over.  |
|
| Back to top |
|
|
| nelaina |
| Posted: Thu Apr 06, 2006 7:44 am Post subject: |
|
|
CFO
|
I think this is great and i appreciate the work put into doing this new screen
i was having trouble understanding the GTM, but now that i've compared the price from Apr 1 to the current price i understand.
Thanks for doing this!
although i am somewhat confused as to what it means to have $8140 that i can deposit.
If i am understanding it right, this amount ($8140) has nothing to do with the actual e$ that i have?
ok, nm i see, its because i have sold 8140 worth of stock, so therefore there is that 8140 remaining to re-invest, and e$ is totally seperate as if it were cash in my pocket.
sorry, i just have to spell things out for myself sometimes |
|
| Back to top |
|
|
| Dave Rathbun |
| Posted: Thu Apr 06, 2006 7:55 am Post subject: |
|
|
CFO
|
| frusnak wrote: | | When I look at one page I see one set of figures then there's another set on another page. And none of it seems to jive with what the stock challenge is. Please do not try to explain it to me I will go with what ever you come up with. |
Too late, I will explain it anyway.
The reason the screens are different is they are doing different things. The new monthly screen is focused on detailing exactly what happened so far this month. That's it.
The portfolio screen shows you numbers for all open holdings, no matter when you bought them. It does not take closed holdings into account.
The trade history screen only shows you closed positions. Each individual position has a return %, and there is a total, but none of those will match, except for one case.
If you are a new user, and you buy a stock, then your monthly return and your total portfolio return will be indentical. Or for example for me, I had zero holdings for the month, and I purchased Yahoo at the beginning of the month. My monthly numbers and my portfolio numbers match. I didn't sell anything, and I don't have anything carried over from the prior month. |
|
| Back to top |
|
|
| Dave Rathbun |
| Posted: Thu Apr 06, 2006 8:03 am Post subject: |
|
|
CFO
|
| nelaina wrote: | | i was having trouble understanding the GTM, but now that i've compared the price from Apr 1 to the current price i understand. |
The GTM is calculated two different ways. For a position that you opened this month it's from the purchase price. For a position opened in a prior month and carried forward it's based on the monthend price from the prior month. So it's possible to have a GTM that is positive, for example, with a NET that is negative. Or vice versa.
If you purchased a stock last month for $20 and it went to $25 at the end of the month, and it's now at $22, then you have a NET of $200 but a GTM (gain this month) of -$300. But last month you had a GTM of $500, so $500 - $300 makes the $200 in unrealized gains. That part I am quite confident is correct.
| Quote: | although i am somewhat confused as to what it means to have $8140 that i can deposit.
If i am understanding it right, this amount ($8140) has nothing to do with the actual e$ that i have?
ok, nm i see, its because i have sold 8140 worth of stock, so therefore there is that 8140 remaining to re-invest, and e$ is totally seperate as if it were cash in my pocket. |
That is exactly it!
You start the month with zero cash in the account, as explained elsewhere. Any new money coming in affects the "baseline value" or the value used to determine the monthly return. But if you sell something, you don't take the money "out" of the account until the end of the month. So you can invest e$8140 on new stocks, and the gains made from that purchase are "compounded" on top of any gains realized for the month.
If you start with a 1000 holding (100 shares $10 ea) and it goes to $1500 and you sell, you have 1500 to spend. If you buy something else for 1000 and it goes to 1500, well, you have 1500 in stock and 500 in cash, or 2000 balance and 1000 total GTM, divided by 1000 starting balance, you have a 100% return. Under the old system your baseline is increased every time you buy, so the baseline would be 2000, and your 1000 GTM divided by 2000 becomes a 50% return, rather than 100%.
| Quote: | | sorry, i just have to spell things out for myself sometimes |
Do you have any idea how many pieces of paper I scribbled on and threw away, and how many different Excel sheets I built and deleted trying to figure this all out? Lots! I don't expect it to come all together right away, it will take some time to test and validate. |
|
| Back to top |
|
|
| jdunn72 |
| Posted: Thu Apr 06, 2006 8:09 am Post subject: |
|
|
Member of The Month
March
|
| Benjamin wrote: | | Everyone please look at the numbers and let us know if it looks correct. We had a lot of issues with the old system (Complaints) and here is the replacement, so let us know how we did! |
I whooped out with the calculator, they look good to me. |
|
| Back to top |
|
|
|
|
 |
| Dave Rathbun |
| Posted: Thu Apr 06, 2006 8:10 am Post subject: |
|
|
CFO
|
Next on the list, but will not happen until this weekend, is to fix the networth calculation. Here's what needs to happen. The logic used in the screen needs to be put into a loop so that it references every user on the board. I get a batch of stock quotes, then process each user, then take the monthly return and the portfolio value and update the user record. That way when you're looking at a topic you don't have to wait for the page to display while the return is calculated.
The update to the user record takes care of the networth calculation, the active leaderboard calculation, and (I think) everything else.
Finally, that process will be tested so I see how long it takes to run (there is a lot of manipulation that goes on behind the scenes to make this work) and determine if it's going to run hourly, more frequently, less frequently, or what.
As a final bonus, each time you go into the new screen, your user record will be updated. This is not happening now, as I literally just thought about it as I was typing this post. If I have already done the work, it's a trivial process to go ahead and update your record with the results. So until next week when the background process will be back, you can go into that screen periodically and have your numbers show up everywhere else. That's a good improvement, I think, and it means that every time the value is calculated it's stored, so we don't waste the cpu cycles. I will put this into place this evening, it's probably a whopping five minutes worth of work.  |
|
| Back to top |
|
|
| Im Not Warren Buffett |
| Posted: Thu Apr 06, 2006 12:30 pm Post subject: |
|
|
CFO
|
| Benjamin wrote: | | Everyone please look at the numbers and let us know if it looks correct. We had a lot of issues with the old system (Complaints) and here is the replacement, so let us know how we did! |
I think the new calculation looks accurate for me, and would prefer that it be implemented as soon as possible so I can rid that nasty red number next to my name and replace it with the nice +8% one it shows. |
|
| Back to top |
|
|
| Dave Rathbun |
| Posted: Thu Apr 06, 2006 12:54 pm Post subject: |
|
|
CFO
|
If you invoke the "my return" page, it will update your monthly return %. It does not do the portfolio value yet, but will shortly.
Im Not Warren Buffett, must be nice having Apple make a nice comeback, eh? |
|
| Back to top |
|
|
| Dave Rathbun |
| Posted: Thu Apr 06, 2006 1:08 pm Post subject: |
|
|
CFO
|
Okay, when you view the new "monthly results" page it will update your return and your portfolio value upon viewing. If you don't view the page, your numbers won't change.
The fact that the monthly page updates your portfolio will not change, meaning we will leave that in place. However, we will be resetting the background hourly updates this weekend... we don't intend to leave things as they currently are. |
|
| Back to top |
|
|
| jdunn72 |
| Posted: Thu Apr 06, 2006 1:22 pm Post subject: |
|
|
Member of The Month
March
|
| Dave Rathbun wrote: | Okay, when you view the new "monthly results" page it will update your return and your portfolio value upon viewing. If you don't view the page, your numbers won't change.
The fact that the monthly page updates your portfolio will not change, meaning we will leave that in place. However, we will be resetting the background hourly updates this weekend... we don't intend to leave things as they currently are. |
Thats cool, the mayhem is beginning to subside (this is really a great fix) . Now, hows about these networth and e$ figures in the threads......... |
|
| Back to top |
|
|
|
|
|
| |
stock market game on the web. At eInvesting you compete for monthly cash prizes while you interact, make virtual dollars, purchase items, and trade in the realistic stock market simulator. We make investing FUN!
