Jump to content
Software FX Community

RE: Accumulating Values

Software FX

Recommended Posts

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.


Juan Cegarra

Software FX, Inc.


-----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


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?



Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...