HowUTrade website bridge doc correction?

madhukar
Few days back while calling
Public Function GetMtmBridge (
Exch As String,
TrdSym As String,
StgyCode As String,
Source As String,
IsLive As Boolean
) As Double

I was getting error

When i looked into template worksheet of kitexl I found there is one more required parameter for this method i.e. with parameter should be LTP

But didn't poste the query then but I guess it's correction in this method!

@HowUTrade
Tagged:
  • HowUTrade
    @madhukar

    We added a extra parameter in the Excel UDF which wraps the GetMtmBridge funtion, to make it auto update in excel cell.(Dynamic dummy parameter, which will force excel to re-calculate the formula whenever Ltp changes)
  • madhukar
    madhukar edited November 30
    Okey! So this method wont work without this dummy parameter in excel but should work in other applications?

    Also is this possible to replicate this same method for getATP UDF? As follows by modifying getATP UDF

    Public function getATP(etc..., ByVal Dynamic value As Double) As Varient
    etc...

    GetATP=kite.getAtp(etc...,here LTP as double e.g. for acc 1450)

    Etc...

    End function

    P.s.
    Etc is what is already there in UDF , ignore typos!

    @HowUTrade

    Is this one of the efficient ways to reduce RTD load to get many values?

    Will there be any throttle limit issues if some of static UDFs are converted to dynamic? Again to reduce GETRTD load?
  • HowUTrade
    @madhukar

    Yes, you can convert any existing UDF to dynamic by adding additional parameters.
    But make sure that, the additional parameters is dynamic and updates automatically without any intervention. In other words, you should have at-least one cell with RTD function for very liquid stocks/index and refer this cell for dynamic parameter. We use NIFTY future with Volume Field, as it updates virtually every second. Ideally, there should not be any performance impact.

    Pls note we are not modifying the original DLL functions. Original functions will accepts only the permitted parameters.

Sign In or Register to comment.