Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stock Symbol Column comparison
How can I download Nasdaq stock symbols into Excel 97 on Win 98 platform
and then parse day to day symbol info because each day the total number of symbols changes (i.e. 3,450 one day and next 3,530) to end up with a "common list" of say, 3,000 Nasdaq symbols. Then, please help create a formula that can allow me to view 2, 3, 5 days of price and volume increase relative to the pre-prepared list. I call these stocks "Runners" and a profit can be made. Please help. Thank you in advance. I wrote once, but lost the info. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stock Symbol Column comparison
I can't seem to understand what you want. Send your workbook to me at the address below. I am not using win 98 and don't have xl97 loaded on this computer but I can take a look at your file and try. -- Don Guillett Microsoft MVP Excel SalesAid Software "Mike" wrote in message ... How can I download Nasdaq stock symbols into Excel 97 on Win 98 platform and then parse day to day symbol info because each day the total number of symbols changes (i.e. 3,450 one day and next 3,530) to end up with a "common list" of say, 3,000 Nasdaq symbols. Then, please help create a formula that can allow me to view 2, 3, 5 days of price and volume increase relative to the pre-prepared list. I call these stocks "Runners" and a profit can be made. Please help. Thank you in advance. I wrote once, but lost the info. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stock Symbol Column comparison
?? maybe ?
http://groups.google.com/group/micro...1d8f21ae09f99b -- Gary''s Student - gsnu200758 "Mike" wrote: How can I download Nasdaq stock symbols into Excel 97 on Win 98 platform and then parse day to day symbol info because each day the total number of symbols changes (i.e. 3,450 one day and next 3,530) to end up with a "common list" of say, 3,000 Nasdaq symbols. Then, please help create a formula that can allow me to view 2, 3, 5 days of price and volume increase relative to the pre-prepared list. I call these stocks "Runners" and a profit can be made. Please help. Thank you in advance. I wrote once, but lost the info. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stock Symbol Column comparison
Thank you, Gary"s Student. Yes, helped a lot. This is my original post that
I lost. Still I am asking more questions in my both the original post and the present post. Please help if possible. Thanks again. "Gary''s Student" wrote: ?? maybe ? http://groups.google.com/group/micro...1d8f21ae09f99b -- Gary''s Student - gsnu200758 "Mike" wrote: How can I download Nasdaq stock symbols into Excel 97 on Win 98 platform and then parse day to day symbol info because each day the total number of symbols changes (i.e. 3,450 one day and next 3,530) to end up with a "common list" of say, 3,000 Nasdaq symbols. Then, please help create a formula that can allow me to view 2, 3, 5 days of price and volume increase relative to the pre-prepared list. I call these stocks "Runners" and a profit can be made. Please help. Thank you in advance. I wrote once, but lost the info. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stock Symbol Column comparison
To Gary"s Student.
Actually, Harlan Grove answered one of my questions in the old post. The question of each day stocks are added and deleted from Nasdaq and this creates a list non conformist day to day, so Harlan's formula of =IF(COUNT(MATCH(G1,H:H,0)),G1,"") did find the "common stocks" from day to day (i.e. did not list those that are there one day and gone the next. However, after running this formula, the price and volume was not "attached--relative to the original stock symbol" and therefore I could not apply a formula to read day 2 is price is greater than day 1, and so forth. So, my next guestion is how can I run a formula like Harlan's and still retain the price and volume info associated with each stock symbol.? Thanks in advance. Mike "Gary''s Student" wrote: ?? maybe ? http://groups.google.com/group/micro...1d8f21ae09f99b -- Gary''s Student - gsnu200758 "Mike" wrote: How can I download Nasdaq stock symbols into Excel 97 on Win 98 platform and then parse day to day symbol info because each day the total number of symbols changes (i.e. 3,450 one day and next 3,530) to end up with a "common list" of say, 3,000 Nasdaq symbols. Then, please help create a formula that can allow me to view 2, 3, 5 days of price and volume increase relative to the pre-prepared list. I call these stocks "Runners" and a profit can be made. Please help. Thank you in advance. I wrote once, but lost the info. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stock Symbol Column comparison | Excel Worksheet Functions | |||
lookup stock symbol on worksheet and return summary data | Excel Worksheet Functions | |||
Excel Chart - 2 column stack /w 1 comparison column | Charts and Charting in Excel | |||
How do I add a stock symbol smart tag in Excel? | Excel Discussion (Misc queries) | |||
Excel; Stock Quotes; Smart Tags: doesn't always recognize symbol. | Excel Discussion (Misc queries) |