Re: Accumulating Values

[User (Legacy)]

FYI. After searching for a SQL query way to do this, I found one way to do

the running total:

SELECT r1.PriceDate, r1.PricePercentChange, sum(r2.PricePercentChange) AS

Running_Total

FROM tblPrice AS r1, tblPrice AS r2

WHERE r2.PriceDate <= r1.PriceDate

GROUP BY r1.PriceDate, r1.PricePercentChange

ORDER BY r1.PriceDate;

-Daniel

Juan C. Cegarra wrote in message

<1a0rdZZHAHA.1780@sfxserver.softwarefx.com>...

ChartFX does not have built-in accumulation functionality and as far as

I know this cannot be easily done in a simple SQL statement.

You will have to develop a stored procedure that returns the accumulated

data or loop through the recordset inside your ASP page.

Regards,

Juan Cegarra

Software FX, Inc.

support.softwarefx.com

-----Original Message-----

From: DB [mailto:dbowen2@nospam.uswest.net]

Posted At: Wednesday, September 13, 2000 12:13 AM

Posted To: Server

Conversation: Accumulating Values

Subject: Accumulating Values

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