Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Strategies & Market Trends : Picks of the quarter -- Ignore unavailable to you. Want to Upgrade?

To: Elroy who wrote (5602)	4/3/2008 5:47:30 AM
From: Patrick Slevin	Read Replies (1) \| Respond to of 20435

Actually, I was thinking of downloading one portfolio into one "sheet" then setting up a second sheet to grab the data from the first sheet. The second sheet would be the varying 30 odd portfolios. So for example the first sheet downloads stocks A B C D E and the second sheet has Portfolio 1,2,3,4 et cetera. Player one has Stock A & C, Player 2 has Stock B & C, Player 3 Stock D & E and so on. So the data ends up on sheet one, the "sort" is compiled on sheet two. Whatever, it's your call. You know, you can just ask Yahoo to provide the EOD Quote without putting in the positions. Use this page. edit.finance.yahoo.com Then all it does is download the last price and you can manipulate the data anyway you want. EDIT The above page produced the following AAPL $147.49 4/2/2008 4:00pm ESLR $9.90 4/2/2008 4:00pm IBM $114.81 4/2/2008 4:01pm INFN $12.10 4/2/2008 4:00pm OVTI $17.00 4/2/2008 4:00pm SIMG $5.27 4/2/2008 4:00pm