B
Box
I'm new so please forgive if this is really easy.
I have a database in the following format:
Line 1 has basic information about a stock (Name, Symbol, etc.)
Lines 2 thru ? have prices (Open, High, Low, Close, etc.) for a month worth
of days with each day on a separate line.
The next line has basic information about another stock
Lines that follow have prices for a month worth of days for this new stock
This continues for a bunch of stocks going back to 1984
I'd like to add the basic information to each record but don't know how to
do it.
The result would be each line with roughly the following format:
Open, High , Low, Close, Stock Name, Stock Symbol
Sorry, if this was in Excel I'd be a champ but there's too much info for Excel
I have a database in the following format:
Line 1 has basic information about a stock (Name, Symbol, etc.)
Lines 2 thru ? have prices (Open, High, Low, Close, etc.) for a month worth
of days with each day on a separate line.
The next line has basic information about another stock
Lines that follow have prices for a month worth of days for this new stock
This continues for a bunch of stocks going back to 1984
I'd like to add the basic information to each record but don't know how to
do it.
The result would be each line with roughly the following format:
Open, High , Low, Close, Stock Name, Stock Symbol
Sorry, if this was in Excel I'd be a champ but there's too much info for Excel