Accumulating Values

[User (Legacy)]

I'm fairly new with ChartFX IE 2000, but not new to ASP or COM.

I have a need to graph some stock information where the data is stored as a

percentage change from the last day (in a database).  So for example, the

data might look like:

PriceDate PriceSymbol PricePercentChange

02-Jan-90 SPY 0.002592262

03-Jan-90 SPY 0.008687829

04-Jan-90 SPY 0.009852357

05-Jan-90 SPY -0.004494191

08-Jan-90 SPY 0.011927235

09-Jan-90 SPY 0.006651119

In the graph, I would like to display the "PricePercentChange" as it

accumulates.

In other words:

02-Jan-90 SPY 0.002592262

03-Jan-90 SPY 0.011280091

04-Jan-90 SPY 0.021132448

05-Jan-90 SPY 0.016638257

08-Jan-90 SPY 0.028565492

09-Jan-90 SPY 0.035216611

Is there anything in ChartFX IE 2000 that provides functionality to have it

accumulate values?  If not, is there a SQL query way to do this (most query

expressions seem to treat each record as an island)?  If not, am I stuck

looping through the recordset and doing the calculations in ASP?

Thanks!

-DB