| Index | Recent Threads | Who's Online | User List | Search |
|
|
 |
Portfolio123 » List all forums » Forum: Screener » Thread: Spread Sheet |
|
Total posts in this thread: 3 |
[Request a Feature]
[Post new Thread] [Add To My Favorites] [Watch this Thread] |
| Author |
|
|
gmealey
Advanced Member  UNITED STATES Joined: May 6, 2004 Posts: 42 Status: Offline |
Marco I wonder if there is any way that Portfolio 123 can be used to put together a spread sheet of a laundry list of stocks that a person may be watching and have the spread sheet list for each stock a wide range of data that could be changed from time to time. ( Such as PEG, PE Analyst rating, market cap, estimated 5 yr growth rate etc. etc.) I t seems that all the data is there but I see no way to get it into a spread sheet. Gmealey ---------------------------------------- gmealey |
||
|
|
BJS
Advanced Member
|
George, You might be able to do it this way: 1. Create an InList that contains the stocks you want to watch. 2. Create a ranking system that contains all the factors you want to compare (PEG, etc.). Assign a weighting of 1% to each of these factors. 3. For the last factor, specify the InList (e.g. Inlist("xxxx")=1), and make it Boolean. Assign a weighting for this high enough to bring the total of the weightings to 100. 4. When you run the ranking system, and get the ranks, it should put all of your InList stocks at the top. Then you can download the data into a spreadsheet, and delete everything below your watch list. It's kind of clunky, but it should work. Brian |
||
|
|
gmealey
Advanced Member UNITED STATES Joined: May 6, 2004 Posts: 42 Status: Offline |
Thanks, it works. Very helpful. ---------------------------------------- gmealey |
||
|
| [Show Thread Printable Version] [Post new Thread] |
