| Author |
Message
|
| jdunn72 |
 Posted: Mon Apr 17, 2006 9:47 am Post subject: |
 |
|
Member of The Month
March
Joined: 26 Jan 2006
Posts: 1407
This Month: 0
11496.86 e$
Net worth: 11,496.86
Portfolio Value: 0.00
Monthly Return: 0.00%
Trades this month: 0
Churn Rate: 0.00%Items
|
| Dave Rathbun wrote: | ..........................................For example, here are the top twenty return percentages for folks with zero trades:
54.61 38.67 21.35 20.25 20.08 18.68 17.24 15.15 12.46 12.33 11.79 11.03 10.88 10.71 10.43 10.09 9.05 8.93 8.65 8.37
The average of these 20 is 16.5375%. | Yes, this is one of the parts I was looking for.
| Dave Rathbun wrote: | Here are the returns for the top twenty active traders, sorted in order by return (but queried by order of trading activity)
19.66 8.52 5.88 3.45 0.76 0.52 -0.5 -0.67 -0.68 -1.85 -3.43 -3.63 -4.61 -5.29 -5.65 -5.69 -5.77 -7.83 -8.78 -10.32
The average of these is -1.2955% | That's it.
I think that this shows I was wrong and they aren't even close to being equal, as the most active traders are doing much worse than the least active by a long shot.
Of, course if you really wanted to make sure that the least actives just wasn't the dumb luck of long forgotten accounts then you could query the top 20 returns with at least one and safely not more than 3-5(you pick) trades for this month, although that would not account for some of the active posters that are here, it might give an overall better reflection for an answer.
What do you think? |
|
| Back to top |
|
 |
| Dave Rathbun |
| Posted: Mon Apr 17, 2006 10:13 am Post subject: |
|
|
CFO
|
| jdunn72 wrote: | | ...query the top 20 returns with at least one and safely not more than 3-5(you pick) trades for this month... |
Top 20 returns for people with between 1 and 5 trades for the month are
Average return: 8.53%
Average trades: 2.3
Contrast this with the overall ratings for the entire board
Average return: -0.952751%
Average trades: 0.3
Note that the average above is a standard mathematical average with each user weighted the same. So as a whole, the board is down 1% for the month, and we've had an average of 0.3 trades per user. (Reminder: a trade is either a buy or a sell, so someone that has purchased and then sold a stock has placed two trades.)
I should put the "board return percent" on a screen somewhere. That way you could see if you're over / under the eInvesting Index. 
Last edited by Dave Rathbun on Mon Apr 17, 2006 10:17 am; edited 1 time in total |
|
| Back to top |
|
|
| vetelmo |
| Posted: Mon Apr 17, 2006 10:17 am Post subject: |
|
|
Moderator
|
| Dave Rathbun wrote: |
I should put the "board return percent" on a screen somewhere. That way you could see if you're over / under the eInvesting Index. |
I was just thinking that today! That is a good idea! 
For some reason I thought the Trading Simulator profile was that. |
|
| Back to top |
|
|
| Dave Rathbun |
| Posted: Mon Apr 17, 2006 10:19 am Post subject: |
|
|
CFO
|
The Trading Simulator portfolio is the million e$ contest portfolio. What I will do is set up a calculation on the quarter-hour recalc process that gets the board return and stores it. Then it can be displayed on your portfolio screen, and on the home page, and stuff like that.  |
|
| Back to top |
|
|
| jdunn72 |
| Posted: Mon Apr 17, 2006 10:41 am Post subject: |
|
|
Member of The Month
March
Joined: 26 Jan 2006
Posts: 1407
This Month: 0
11496.86 e$
Net worth: 11,496.86
Portfolio Value: 0.00
Monthly Return: 0.00%
Trades this month: 0
Churn Rate: 0.00%Items
|
| Dave Rathbun wrote: | | jdunn72 wrote: | | ...query the top 20 returns with at least one and safely not more than 3-5(you pick) trades for this month... |
Top 20 returns for people with between 1 and 5 trades for the month are
Average return: 8.53%
Average trades: 2.3...... |
Well, I think this revelation really showed how things are, very active traders generally do worse than less active traders.
Your really starting to have fun with this sites data possibilities now that you've plunged yourself in so deeply lately hunh?
I think the einvesting index for the monthly is a sweet idea and it would be even sweeter if the dow and or s&p gain/loss for the month was right beside it then we could also see how well the boards index is doing against the standard indices. What do you think? |
|
| Back to top |
|
|
| Dave Rathbun |
| Posted: Mon Apr 17, 2006 11:40 am Post subject: |
|
|
CFO
|
| jdunn72 wrote: | | Well, I think this revelation really showed how things are, very active traders generally do worse than less active traders. |
That is generally the consensus, is that day traders do not do well. Frequent trading (churning, as it were  ) only works if you can make money on each trade. Doing that reliably over time is difficult.
| Quote: | | Your really starting to have fun with this sites data possibilities now that you've plunged yourself in so deeply lately hunh? |
Now that the numbers are correct, yes.  Data is always fun for me, but I'm a geek, so that goes with the territory.
| Quote: | | I think the einvesting index for the monthly is a sweet idea and it would be even sweeter if the dow and or s&p gain/loss for the month was right beside it then we could also see how well the boards index is doing against the standard indices. What do you think? |
I think it should be somewhere, yes. I will have to capture the month end values for each index, just like we do with each stock, in order to be able to compare the eI with the other indexes on an even footing. |
|
| Back to top |
|
|
| jdunn72 |
| Posted: Mon Apr 17, 2006 12:24 pm Post subject: |
|
|
Member of The Month
March
Joined: 26 Jan 2006
Posts: 1407
This Month: 0
11496.86 e$
Net worth: 11,496.86
Portfolio Value: 0.00
Monthly Return: 0.00%
Trades this month: 0
Churn Rate: 0.00%Items
|
| Dave Rathbun wrote: | | I think it should be somewhere, yes. I will have to capture the month end values for each index, just like we do with each stock, in order to be able to compare the eI with the other indexes on an even footing. |
Well, that would be great and it would trigger in the script and update the var on the said date but, if you really wanted you could kick it off with a temporary var that would only be recocognized for this month and 2006. |
|
| Back to top |
|
|
| jdunn72 |
| Posted: Mon Apr 17, 2006 12:26 pm Post subject: |
|
|
Member of The Month
March
Joined: 26 Jan 2006
Posts: 1407
This Month: 0
11496.86 e$
Net worth: 11,496.86
Portfolio Value: 0.00
Monthly Return: 0.00%
Trades this month: 0
Churn Rate: 0.00%Items
|
| Well, it wouldn't even have to be a var just a value that would be recognized only this month this year. |
|
| Back to top |
|
|
| Dave Rathbun |
| Posted: Mon Apr 17, 2006 12:41 pm Post subject: |
|
|
CFO
|
| jdunn72 wrote: | | Well, that would be great and it would trigger in the script and update the var on the said date but, if you really wanted you could kick it off with a temporary var that would only be recocognized for this month and 2006. |
You and I must have completely different coding processes, because that didn't make any sense whatsoever.
At the moment, the monthly reset gets the month end quote value for each stock in an open position. That way I can calculate the "gain this month" or GTM on each board member's return page. That is the feeder value or source for the overall eI Index, which would be calculated as:
| Code: | select avg(monthly_return)
from users table
where portfolio_value is not null |
So that's the eI index, or overall performance of the board's investments. That's not a value, it's a net change.
In order to compare that to the net change for the DJ or S&P 500 index, I need to know the net change in the index value for this month, not for the day. (The daily value is available from the daily quote for each index, and is already displayed on your portfolio screen.) In order to do that, I need to capture the same month ending value for each index that I do for the stocks, and store it in the database each month. Yes? Make sense?
Where is the "temporary variable" you mentioned coming from? What did you have in mind? |
|
| Back to top |
|
|
| jdunn72 |
| Posted: Mon Apr 17, 2006 12:50 pm Post subject: |
|
|
Member of The Month
March
Joined: 26 Jan 2006
Posts: 1407
This Month: 0
11496.86 e$
Net worth: 11,496.86
Portfolio Value: 0.00
Monthly Return: 0.00%
Trades this month: 0
Churn Rate: 0.00%Items
|
| Dave Rathbun wrote: | In order to compare that to the net change for the DJ or S&P 500 index, I need to know the net change in the index value for this month, not for the day. (The daily value is available from the daily quote for each index, and is already displayed on your portfolio screen.) In order to do that, I need to capture the same month ending value for each index that I do for the stocks, and store it in the database each month. Yes? Make sense?
Where is the "temporary variable" you mentioned coming from? What did you have in mind? |
Ok, I know you have the einvesting part down, by temporary I meant it would go like this...
if date > 1st of thismonth and < endofthismonth then BeginningMonthDOWval= (the numeric value that you'd place here which was the beginning of the month value for the DOW /S&P/ NASDAQ whatever)
else (continue on to the script that you actually have in mind that would track it for you automatically each month).
Thats a temporary manual val assignment to kick it off that would only be recognized this month of this year. You see what I mean now?
Last edited by jdunn72 on Mon Apr 17, 2006 1:04 pm; edited 1 time in total |
|
| Back to top |
|
|
|
|
 |
| jdunn72 |
| Posted: Mon Apr 17, 2006 12:54 pm Post subject: |
|
|
Member of The Month
March
Joined: 26 Jan 2006
Posts: 1407
This Month: 0
11496.86 e$
Net worth: 11,496.86
Portfolio Value: 0.00
Monthly Return: 0.00%
Trades this month: 0
Churn Rate: 0.00%Items
|
| Inititially you'd get the DOW beginning value for this month from a historical quote rather than the script and feed it yourself into the temporary assigned value. (don't miss my prior post just b4 this one) |
|
| Back to top |
|
|
| Dave Rathbun |
| Posted: Mon Apr 17, 2006 2:40 pm Post subject: |
|
|
CFO
|
| Okay, we're saying the same thing then. It's just the temporary part that was throwing me off. |
|
| Back to top |
|
|
| DKnightSr |
| Posted: Mon Apr 17, 2006 4:05 pm Post subject: |
|
|
Member of the Month
May
|
"Well, I think this revelation really showed how things are, very active traders generally do worse than less active traders."
jdunn and Dave...BE CAREFUL!!!... don't tell "The Reaper" who's number one in the rankings and has 500% + churn. You'll change his M.O. and he'll down here with me!  You MUST know your place in this world, and I've found mine Leave me and my chartruse red numbers alone...we're very happy down here (NOT!) |
|
| Back to top |
|
|
| Dave Rathbun |
| Posted: Mon Apr 17, 2006 4:33 pm Post subject: |
|
|
CFO
|
| Grim has the capital and has demonstrated the acumen to trade and win. At least for this month. |
|
| Back to top |
|
|
| Im Not Warren Buffett |
| Posted: Mon Apr 24, 2006 8:24 am Post subject: |
|
|
CFO
|
I know Dave requested that information like this be posted somewhere specific, but I want to get it off my proverbial chest:
Its 2:22 EST, and everyone is showing very negative numbers for their portfolio return... I think other than Ben at 0%, the next person was at about -45%. This is just so you can check the logs or whatever type of data recording the site uses. |
|
| 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!
