mearisk
asked on
A 'dynamic' PIVOT
Hi.
I have been trying to tackle this issue with stock prices that I get every day. It comes in:
Date Ticker ClosingPrice
1/2/2006 CSCO 35.45
1/3/2006 CSCO 36.00
1/4/2006 CSCO 36.50
1/2/2006 IBM 98.00
1/3/2006 IBM 98.50
1/4/2006 IBM 99.55
1/2/2006 AAPL 79.50
1/3/2006 AAPL 79.85
1/4/2006 AAPL 78.75
I get pricing on thousands of stock prices each day
I have a portfolio with n number of stocks in each day.
I need to create a matrix of data for a dynamic set of tickers each time to look like:
Date CSCO IBM AAPL
1/2/2006 35.45 98.00 79.50
1/3/2006 36.00 98.50 79.85
1/4/2006 36.50 99.55 78.75
The hard part is that the universe of names can and will change each time.
If there are any missing days then use previous days price.
Any help would be greatly appreciated.
Mark
I have been trying to tackle this issue with stock prices that I get every day. It comes in:
Date Ticker ClosingPrice
1/2/2006 CSCO 35.45
1/3/2006 CSCO 36.00
1/4/2006 CSCO 36.50
1/2/2006 IBM 98.00
1/3/2006 IBM 98.50
1/4/2006 IBM 99.55
1/2/2006 AAPL 79.50
1/3/2006 AAPL 79.85
1/4/2006 AAPL 78.75
I get pricing on thousands of stock prices each day
I have a portfolio with n number of stocks in each day.
I need to create a matrix of data for a dynamic set of tickers each time to look like:
Date CSCO IBM AAPL
1/2/2006 35.45 98.00 79.50
1/3/2006 36.00 98.50 79.85
1/4/2006 36.50 99.55 78.75
The hard part is that the universe of names can and will change each time.
If there are any missing days then use previous days price.
Any help would be greatly appreciated.
Mark
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
X Y Z
Date Symbol Price
1/2/2006 CSCO 35.45
1/2/2006 IBM 98.00
1/2/2006 AAPL 79.50
1/3/2006 CSCO ....
...
...
Date Symbol Price
1/2/2006 CSCO 35.45
1/2/2006 IBM 98.00
1/2/2006 AAPL 79.50
1/3/2006 CSCO ....
...
...
ASKER
So are you saying that this can not be done?
Date CSCO IBM AAPL
1/2/2006 35.45 98.00 79.50
1/3/2006 36.00 98.50 79.85
1/4/2006 36.50 99.55 78.75
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.
I will leave the following recommendation for this question in the Cleanup topic area:
Split between gheist http:#16661838 and m1tk4 http:#16664267
Any objections should be posted here in the next 4 days. After that time, the question will be closed.
gheist
EE Cleanup Volunteer
I will leave the following recommendation for this question in the Cleanup topic area:
Split between gheist http:#16661838 and m1tk4 http:#16664267
Any objections should be posted here in the next 4 days. After that time, the question will be closed.
gheist
EE Cleanup Volunteer
ASKER
I don't understand