Throttle RTD Interval

How to throttle the RTD interval

By default, Microsoft Excel will throttle RTD updates into your spreadsheet. This means that data can be delayed, especially if you are expecting multiple updates per second.

To check your current RTD throttle interval, follow these steps:

  • Open the Visual Basic editor using Alt + F11
  • Open the Immediate Window using View->Immediate Window or Ctrl + G
  • Type into the immediate window, “?Application.RTD.ThrottleInterval” (without the quotes) and press Enter

The default value for Excel is 2000 milliseconds or 2 seconds, which means that updates will not be refreshed within 2 seconds of each-other in your sheet.



How to change the RTD interval

You can set a new value for the RTD throttle interval in the same immediate window as above, using the following syntax:

Application.RTD.ThrottleInterval=1000

which would set the throttle to 1 second.

To remove the throttle completely, and have Excel send updates as quickly as it can to your spreadsheet, you can turn it off with

Application.RTD.ThrottleInterval=0

About RTD

What is RTD and DDE in Excel?

DDE

Dynamic Data Exchange (DDE) is a Microsoft technology for transferring information between applications and is the older of the two technologies. DDE utilises Windows messaging to send and receive data.

RTD

Real-time Data (RTD) is a newer technology introduced specifically for Microsoft Excel for high-speed data transfer, making it an ideal choice for financial data applications. RTD utilises a combined push and pull technology to allow for fast updates of data into an Excel sheet.

Install 64 bit Excel

How to install 64 bit Excel

By default, Microsoft recommends and installs the 32 bit version of Office (and Excel). The main reason, I believe, is for support with the many Excel plugins that are supported on 32 bit Excel.

Here are some of the reasons you may be interested in 64 bit Excel:

  • You have very large datasets -> Excel 64 bit can access more memory and is better with big data
  • You need to support files over 2gb in size -> Excel 64 bit will not be restricted like the 32 bit version
  • You are using a plugin that requires or recommends the 64 bit version

Download the 64 bit version

Before you click ‘download’, ensure that you have selected the 64 bit version. If there is no 32 bit or 64 bit, it usually means you are downloading the 32 bit version.

Office 365

For Office 365, click on Language and Install Options->Additional Install options and select 64 bit Excel

Office Professional Plus 2016 and 2019

If you are installing from a downloaded version of Office, running Setup will usually install the 32 bit version.

Open the Office folder and run Setup64.exe to install 64 bit Office

Is my Excel 64 bit or 32 bit?

The easiest way to tell which bitness your Excel is running, is to open Task Manager on Windows using Ctrl+Shift+Esc or to use Start->Task Manager.

Pro Tip: Despite which version is installed, it is a good idea to check in Task Manager which version is running as this will affect plugins you are trying to install and use

Excel 32 bit using Task Manager (Windows 10)

If you see a * or 32 bit next to the application or process name, the process is running as 32 bit.

If there is no 32 bit or * next to the application or process name the process is running as 64 bit.

Excel 64 bit using Task Manager (Windows 10)

Excel 2013

You can check for 32 bit vs 64 bit using File->Account and clicking on About Excel.


Excel 2016

Similar to Excel 2013, you can check for 32 bit vs 64 bit using File->Account and clicking on About Excel.


Excel 2019

Excel 2019 and 2016 look nearly identical, with the same way of checking 32 bit vs 64 bit through File->Account and clicking on About Excel.

Excel 365

Office 365 and 2019 are fairly similar, both in looks and functionality. You can check 32 bit vs 64 bit in the same was using File->Account and clicking on About Excel.

Which version of Excel am I running?

Excel 2003

Excel 2007

Excel 2010

Excel 2013

Excel 2016

Excel 2019

Excel 365


Excel 2003:

Excel 2003 had a file menu and toolbar that looked like this:

You can click on Help->About Microsoft Office Excel


The product version is at the top of the About Microsoft Excel dialog.


Excel 2007:

Excel 2007 introduced the Office logo replacement for the File Menu, which looks like this:

Click on the Office Logo->Excel Options then click on Resources on the left panel. This will show you the specific Excel 2007 version information.


Excel 2010:

2010 re-introduced the File menu, which looked like this:

Click on File->Help and take a look on the right of the screen for version and build info.


Excel 2013:

Excel 2013 had a lighter menu with a File menu like this:

Click on File->Account

and select About Excel


Excel 2016

Excel 2016 introduced the green menu-bar, which looks like this:

Click on File->Account and select About Excel


Excel 2019

Excel 2019 continued the green toolbar theme, which looks like this:

Click on File->Account and select About Excel


Excel 365

Not sure if you have Office 365 or Excel 2019? Clicking on File->Account will show you:

Click on About Excel to see product information and bitness (64 or 32 bit)

Excel Developer Toolbar

How to add VBA developer options in Excel ribbon

Let’s face it, buttons are cool.

As a VBA Trader, at some point you need to add a button to your trading sheet to pull trades, or to start and stop your auto trader system.

By default, Excel hides the developer options which allows you to add controls and edit code. Here are the steps to add it to your toolbar:

  • Click on File->Options
  • Select Customize Ribbon
  • On the right-hand list, check Developer in the list
  • Press OK
Excel 2019 Developer Options in the Toolbar