View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DCondie DCondie is offline
external usenet poster
 
Posts: 3
Default Creating A Trade Date Column

Working in Excel 2003

I am creating a database that lists the daily prices of stocks for the
days that I hold each stock over a twenty-year period. For each
stock, I have the price for each day that I held the stock.

I need to place the price for each day that the trade is open in a
column on the row adjacent to the first column which indicates the
trade day.

Can you provide a procedure that would eliminate Saturday, Sunday and
holidays from the date sequence over a twenty-year period staring in
1/1/83 so that the date column would only show sequentially the
available trade dates over the twenty year period?

Thank you.

Doug Condie