SORTING STOCKS

verluc · Mar 19th, 2002, 09:48 AM

I have in a workbook 2 sheets: sheet A and sheet B.
In sheet A I have in the column A1:A250
a number of 250 symbols from stocks of the NASDAQ.
In sheet B I have download the hole NASDAQ stock exhange of about +/- 7000 stocks;
Now what I want to do is every day in column B of sheet A set the stock PRICES with the same symbol as of sheet B
Is this possible?
Many thanks

smozgur · Mar 19th, 2002, 09:53 AM

A_col | B_col

1 | =VLOOKUP(A1,SheetB!A1:A7000,1,FALSE)
2 | =VLOOKUP(A2,SheetB!A1:A7000,1,FALSE)
3 | =VLOOKUP(A3,SheetB!A1:A7000,1,FALSE)
..
..
..

SheetB should be sorted in ASC by A column.

_________________
Oz ~ TheWordExpert

[ This Message was edited by: smozgur on 2002-03-19 08:54 ]

[ This Message was edited by: smozgur on 2002-03-19 08:55 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 09:48 AM	#1
verluc Board Regular Join Date: Mar 2002 Posts: 1,290	I have in a workbook 2 sheets: sheet A and sheet B. In sheet A I have in the column A1:A250 a number of 250 symbols from stocks of the NASDAQ. In sheet B I have download the hole NASDAQ stock exhange of about +/- 7000 stocks; Now what I want to do is every day in column B of sheet A set the stock PRICES with the same symbol as of sheet B Is this possible? Many thanks

Mar 19th, 2002, 09:53 AM	#2
smozgur BatCoder Join Date: Feb 2002 Location: Turkey Posts: 764	A_col \| B_col 1 \| =VLOOKUP(A1,SheetB!A1:A7000,1,FALSE) 2 \| =VLOOKUP(A2,SheetB!A1:A7000,1,FALSE) 3 \| =VLOOKUP(A3,SheetB!A1:A7000,1,FALSE) .. .. .. SheetB should be sorted in ASC by A column. _________________ Oz ~ TheWordExpert [ This Message was edited by: smozgur on 2002-03-19 08:54 ] [ This Message was edited by: smozgur on 2002-03-19 08:55 ]