SQL Server Performance

Caculating % change in Closing Price

Discussion in 'General Developer Questions' started by sfunds, Jun 8, 2008.

  1. sfunds New Member

    I have a table with following fields
    Date
    closePrice
    symbol
    I have to calculate % change in Closing Price compared to prvios day price for all symbols
    Thanks
    Sridhar
  2. MohammedU New Member

    You need to keep previous day close price in either in the same table or some other to calculate...% change...do you have one?

Share This Page