Software FX Posted September 13, 2000 Report Share Posted September 13, 2000 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.