We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Automatically recalculating dependant formulas

Thread ID:





52895 Dec 5,2006 08:14 PM UTC Dec 7,2006 12:22 PM UTC WinForms 1
Tags: Calculate
Greg Perrott
Asked On December 5, 2006 08:14 PM UTC

I have created a custom function that returns real-time data from the Reuters network.

I am using the CalcQuick class to define formulas that use the real-time data. The custom function is called “REUTER and is passed a string parameter that defines what data to capture.

this.calculator["Bond Turnover 2017"] = "=REUTER('NZSPREAD,IRGROW,3,1,48,5')";
this.calculator["IIB 2016"] = "=REUTER('NZG0216=FISW,HS_CODE')";
this.calculator["TEST"] = "=([Bond Turnover 2017] + [IIB 2016])/2";
this.calculator["TEST1"] = "=REUTER('NZSPREAD,IRGROW,3,1,48,5') + REUTER(\"NZG0216=FISW,HS_CODE\")";
this.calculator["TEST2"] = "=[TEST]*2";

In the example above, when a new value arrives from Reuters for the “Bond Turnover 2017”, I would like to recalculate the “Bond Turnover 2017” value and have all other dependant values (eg “TEST”, and “TEST2”) recalculated automatically and just be notifed via the ValueChanged or ValueSet events when this happens.

Administrator [Syncfusion]
Replied On December 7, 2006 12:22 PM UTC

Here is a sample that I think does what you described.


A comment is that the CalcQuick object will not have any way of knowing that a new value has arrived from your Reuter source unless that Reuter source raises an event when one of its values has changed. So, in the sample, a ReuterChanged event was added and is raised when a timer event changes the values provided by Reuter. In this way, you can listen for this event and force CalcQuick to recalculate when this changed event comes in.


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon