KiteNet: Rates(fields) are not refreshing in Marketwatch, while in MarketDepth its working perfectly

EquityOnSMS
@botany02 rates (fields) are not refreshing in Marketwatch, while in Market Depth it's working perfectly.

Tagged:
  • HowUTrade
    @EquityOnSMS
    As you are getting quotes in depth window, we can narrow the issue to Excel.

    Try the following sequentially:
    1. Ensure RTD throttle interval is set to 0
    RTD throttle interval

    2. Run Excel as Admin.
    Most of the issues will be resolved when you run Excel as admin.

    3. Explicitly allow excel through windows firewall
    Control Panel\System and Security\Windows Firewall\Allowed Programs

    4. Make sure the Port number 3057 is not used any other application.
    RTD server receives data from KiteNet through Udp sockets.
    The following ports are used in KiteNet.
    Protocol             Port            Use
    Udp 3057 RTD Server
    Udp 6057 Data Logger
    Tcp 9057 Bridge
    5. Repair MS office
    This is the last option if everything fails, repair your MS office installation
    Control Panel\Programs\Programs and Features

    Best practices using Excel:
    * If you have large data updating through RTD, set excel calculation mode to Manual and periodically calculate the sheet using Application.OnTime.
    * Do not save excel excel file while RTD is updating. Saving excel while RTD update will lead to excel crash.
    * Disable auto-save option in excel. Auto-save is evil when you use excel with RTD
    * Avoid unnecessary formatting's. Every conditional formatting adds extra load to excel and it pays huge price.
    * Avoid editing VBA code while RTD is updating. This will reset variables initialized and will lead to error and crash.
    * Avoid unnecssay for For...Loop in VBA code.
    * Use static variables and dictionary to store temporary data instead of text file or something.

  • EquityOnSMS
    EquityOnSMS edited April 2018
    Step by Step checked, all were ok but the Repair the MS Office worked for me. Thanks @botany02
This discussion has been closed.