Displaying 1 result from an estimated 1 matches for "marketdate".
Did you mean:
market_date
2008 Nov 13
1
Unflatten a table in R
...is task, (hopefully efficiently).
My data table is full of historical stock-market data. Daily, each
ticker-symbol has four data points: open, close, high, and low.
Right now the table looks like the following. (Note, each ticker symbol has
a unique numeric 'SymbolID'.
SymbolID MarketDate Open Close High Low
1 4 11/3/2008 1.5790 1.5788 1.5790 1.5788
2 4 11/4/2008 1.5891 1.5892 1.5892 1.5891
3 4 11/5/2008 1.5937 1.5931 1.5937 1.5931
4 4 11/6/2008 1.5727 1.5727 1.5727 1.5727
5 4 11/7/2008 1.5673 1.5669 1.5673 1.5669
6 5 11/3/2008...