Hi,
I am trying to extract some data from a table.
Table A has
Company Name dates EPS value
(approx 3400). This is annual data
Table B has
Company Names dates Daily return
This is daily data (approx 70000 records)
I need to match up the company names and dates in A and B. This is fine. However, I want to return the values for the previous 54 days as well for that company.
Can this be done?
Thank you
I am trying to extract some data from a table.
Table A has
Company Name dates EPS value
(approx 3400). This is annual data
Table B has
Company Names dates Daily return
This is daily data (approx 70000 records)
I need to match up the company names and dates in A and B. This is fine. However, I want to return the values for the previous 54 days as well for that company.
Can this be done?
Thank you