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.

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

Step by Step checked, all were ok but the Repair the MS Office worked for me. Thanks @botany02