Guys
I have a problem.
I have a  Big database (in the table below) that i need to manupulate the data across. But I´m not getting.
I tried to use function aggragate,table and tapply, to a cross date whit the clossing price equit. But i din´t succeed.
 exemplo
My database

Simbulo Período      Data   hora Abertura Máximo Mínimo Fechamento Quantidade Financeiro
1  ABCB11       D 24/9/2007 185000    93.89   93.9   93.7       93.8      16300    1529782
2  PETR4       D 21/9/2007 185000       92  94.06     92      92.95      91800    8448657
3  PETR3       D 20/9/2007 185000     93.4   93.5   92.5       92.5      11100    1031339
4  VALE5        D 19/9/2007 185000       94     94   93.5      93.99       3300     309885
5  VALE3       D 18/9/2007 185000    92.99     94   91.5         94      10500     976880
6  BBAS3       D 17/9/2007 185000       93     93     92       92.7      49700    4604635
 
I will need to do (date / Closing Equite)

         Date ABCB11 PETR4 PETR3 VALE5 VALE3 BBAS3 
24/9/2007    93.7 93.7 93.7 93.7 93.7 93.7 
21/9/2007    92 92 92 92 92 92 
20/9/2007      92.5 92.5 92.5 92.5 92.5 92.5 
19/9/2007    93.5 93.5 93.5 93.5 93.5 93.5 
18/9/2007    91.5 91.5 91.5 91.5 91.5 91.5 
17/9/2007    92 92 92 92 92 92 

what is the function to accomplishment this intersection?
someone help me?
Thank.
Clhis Alberty


      ____________________________________________________________________________________
[[elided Yahoo spam]]

	[[alternative HTML version deleted]]

