Portfolio of the Week

[skiracer]

I'm getting ready to post todays results of the POTW but there are 3 position moves that I need help with pertaining to the time of sales prices. They are: I could use these asap if anyone has them available. My brokerage's time and sales doesn't give me the data after the close anymore. Used to be able to go back a couple of days after the close each day but now only during market open hours. This will be a big help please.

Alice4321us: 10:14 sell MTEX.
MIMO_100: 10:31 sell FTEK.
RL: 3:10 enter AXTI.

[peanuts]

Ski,

all are opening prices at the times you posted:

MTEX $15.83
FTEK $19.232
AXTI $4.50 (no trade at 3:10, this is 3:11 opening price)

All information according to Ameritrade

[skiracer]

Ski,

all are opening prices at the times you posted:

MTEX $15.83
FTEK $19.232
AXTI $4.50 (no trade at 3:10, this is 3:11 opening price)

All information according to Ameritrade

You're a nut. Thanks bud. As in Peanuts.

[peanuts]

Ski,

Just real quick: I'm actually positive on my short position, but you have my short as a long. Same with DMK. He's is short, but in a losing position right now, and you have him recorded for a gain. Also, I thought the positions were percentage gain/loss. If it is dollar gain or loss, then I am calling BRK.A as my stock for the rest of the year. It moves in thousand dollar increments...

and whizzy has a .14 loss, not .05

ps. percentage gain/loss is better.... The formula is: ((end-beg)/beg)x100 = percent change

[skiracer]

Ski,

Just real quick: I'm actually positive on my short position, but you have my short as a long. Same with DMK. He's is short, but in a losing position right now, and you have him recorded for a gain. Also, I thought the positions were percentage gain/loss. If it is dollar gain or loss, then I am calling BRK.A as my stock for the rest of the year. It moves in thousand dollar increments...

and whizzy has a .14 loss, not .05

ps. percentage gain/loss is better.... The formula is: ((end-beg)/beg)x100 = percent change

Peanuts,
Whiz's entry was supposed to be 2.01 and not 2.10. That's why I have it .05. Initially when I first looked at the list that Rob posted I missed the two shorts. I changed them to short positions, in red, today but forgot to reverse the numbers as they should be for shorts. Down is + and up is -. I'll fix it right now. With that formula can I plug in the formula and highlight the whole sheet and get the gain/loss percentage for all of the positions at once?

Once I plug the formula into the fx bar what do I do after that please. I would like to show them in percentages if you can lead me through it.

[skiracer]

Well I have been messing around with it and I think that I am getting it a little better and more concise. I would like to know how to flood the background with color or the individual rows or columns with color. Any other suggestions to make it more eye appealing are welcome.
Pete Hansen. I am not dissing you Pete. I don't get anything for BRCL on Stockcharts.com. Sorry but if you would help me out here please Pete and tell me what you want to do. Anyone else get anything on BRCL?
I think I have everyone's positions down right now. I'm putting the long positions in BLUE and the short positions in RED.

Stky is still on the top of the leader board with his NVEC play. This could be it for the week. Not to much change within the remaining players today. Still 5 undecided's in the PRETTY IN PINK ZONE.

Remember any suggestions are welcome as far as making this esthetically pleasing. Here are today's results and standings:
Karel, I think this should be acceptable size wise yes. Before you thumbnail it please give me a chance to make it alittle smaller if it needs it. I like the larger format since it is easier on the eyes as long as it fits your parameters.

[dmk112]

Ski, it looks like you're using Excel. To color the background of a cell you can click on the cell and then click on the 'paint bucket' button on the toolbar.

[Karel]

Ski, you are doing just fine. This one is 614px wide. (Rob's were 687, so you have some more room.) I don't think a sheet with a font this big really needs alternating row backgrounds, but here is an Excel tip anyway:

http://www.techonthenet.com/excel/questions/cond_format2.php

They leave a step out however, as you loose the border color this way. Just don't click OK after you have set the background color, but go to the border tab, select the lightest gray as color (or another color when you choose that as your background), and click on Outline. Now you click on OK.

Regards,

Karel

[skiracer]

Ski, you are doing just fine. This one is 614px wide. (Rob's were 687, so you have some more room.) I don't think a sheet with a font this big really needs alternating row backgrounds, but here is an Excel tip anyway:

http://www.techonthenet.com/excel/questions/cond_format2.php

They leave a step out however, as you loose the border color this way. Just don't click OK after you have set the background color, but go to the border tab, select the lightest gray as color (or another color when you choose that as your background), and click on Outline. Now you click on OK.

Thanks Karel and DMK. I wasn't thinking of anything multi-color but maybe a solid color wash for the background with a border around that to emphasize the sheet. Just thoughts and I'll try it later tonight. There is only so much that you can do. What I would like more help with is the suggestion that Peanuts made about the gain/loss being in % rather than numerically. I would like to know how to plug that in and if I have to do it with each players results or can I do the whole sheet at once. Thanks.

[Karel]

[...] What I would like more help with is the suggestion that Peanuts made about the gain/loss being in % rather than numerically. I would like to know how to plug that in and if I have to do it with each players results or can I do the whole sheet at once. Thanks.

Ski, that is easy. Currently you use a formula like =[close] - [entry] for the results. What you need is either:
=([close] - [entry]) / [entry] (and format as a percentage)
or:
=([close] - [entry]) * 100 / [entry] (no need for formatting, but no percentage sign)

This is the formula for long positions. For shorts you put a - just after the =

Regards,

Karel

[skiracer]

Ski, that is easy. Currently you use a formula like =[close] - [entry] for the results. What you need is either:
=([close] - [entry]) / [entry] (and format as a percentage)
or:
=([close] - [entry]) * 100 / [entry] (no need for formatting, but no percentage sign)

This is the formula for long positions. For shorts you put a - just after the =

Regards,

Karel

Thanks Karel. After I type the formula into the fx bar then I just hit enter and it will give me the percentage. Can I highlight the whole sheet and do it all at once or do I have to do it individually?

[peanuts]

Thanks Karel. After I type the formula into the fx bar then I just hit enter and it will give me the percentage. Can I highlight the whole sheet and do it all at once or do I have to do it individually?

While moving the cursor around the worksheet, you might notice that when the cursor goes to the bottom right corner of any cell, the cursor changes to a black + sign. When that happens, you can click on the black + sign and drag a formula in the cardinal directions. In this case, you would type in the formula and then click the black + and drag the formula down to the end of the contestant list. If you'd like, you can email the spreadsheet and I can check it for you. I've got alot of experience with excel, and I like using it. I've set up a generic email address for occasions just like this. Just email the spreadsheet to me and I will check out the formulas. [email protected] I hardly ever use this email address

[skiracer]

While moving the cursor around the worksheet, you might notice that when the cursor goes to the bottom right corner of any cell, the cursor changes to a black + sign. When that happens, you can click on the black + sign and drag a formula in the cardinal directions. In this case, you would type in the formula and then click the black + and drag the formula down to the end of the contestant list. If you'd like, you can email the spreadsheet and I can check it for you. I've got alot of experience with excel, and I like using it. I've set up a generic email address for occasions just like this. Just email the spreadsheet to me and I will check out the formulas. [email protected] I hardly ever use this email address

I can do that.

[IIC]

Well I have been messing around with it and I think that I am getting it a little better and more concise. I would like to know how to flood the background with color or the individual rows or columns with color. Any other suggestions to make it more eye appealing are welcome.
Pete Hansen. I am not dissing you Pete. I don't get anything for BRCL on Stockcharts.com. Sorry but if you would help me out here please Pete and tell me what you want to do. Anyone else get anything on BRCL?
I think I have everyone's positions down right now. I'm putting the long positions in BLUE and the short positions in RED.

Stky is still on the top of the leader board with his NVEC play. This could be it for the week. Not to much change within the remaining players today. Still 5 undecided's in the PRETTY IN PINK ZONE.

Remember any suggestions are welcome as far as making this esthetically pleasing. Here are today's results and standings:
Karel, I think this should be acceptable size wise yes. Before you thumbnail it please give me a chance to make it alittle smaller if it needs it. I like the larger format since it is easier on the eyes as long as it fits your parameters.

Guess my pick wasn't good enough to post...IIC

[peanuts]

Guess my pick wasn't good enough to post...IIC

Monday, 10:29 LVLT, right? If so, I'll add it when I get the spreadsheet...

Is that OK Ski?