FALSE!
RTD works in Excel on Windows machines. From Excel 2003 version thru 2016. No issues! You will also need the origin of the RTD, such as TOS for receiving live quotes. I'm been using in for a few years! I use it many times per day!
Excel DDE Add-In
- Thread starter Hennie
- Start date
RTD works in Excel on Windows machines. From Excel 2003 version thru 2016. No issues! You will also need the origin of the RTD, such as TOS for receiving live quotes. I'm been using in for a few years! I use it many times per day!
RTD works fine for me on my Windows 7 laptop but not on my Windows 10 machine.
Is it working for you on Windows 10?
On my Windows 10 machine I have resorted to using OpenOffice Calc in order to stream TOS.
My primary use is with Excel 2016 on a Win 10 machine! No issues. However, you have my interest with your commet "OpenOffice --- stream TOS" statement! <-- I am very curious, as the only reason I bought Excel 2016 was for access to RTD!
BTW: I do recall others having issues initially getting Excel 2016 RTD working, but did not encounter issues myself --- They all resolved their issues, and got it working.
R1234:
I found this, courtesy of Raul Sarin, that may relate to your issue.
VBA code follows:
'..... Code Developed by Rahul Sarin to Fix Excel 2016 RTD issue with TOS........
Public Sub UpdateRTDFunction()
Dim wks As Worksheet
Dim rngFormula As Range, cell As Range
With [Application]
.EnableEvents = False
.ScreenUpdating = False
End With
For Each [wks] In ThisWorkbook.Worksheets
On Error Resume Next
Set [rngFormula] = [wks].Cells.SpecialCells(xlCellTypeFormulas)
On Error GoTo 0
If [rngFormula] Is Nothing Then: Exit Sub
For Each [cell] In [rngFormula]
If InStr(1, [cell].Formula, "RTD") > 0 Then
If InStr(1, [cell].Formula, ", ,") > 0 Then
[cell].Formula = Replace([cell].Formula, ", ,", ",""tos.rtd"",", 1)
Else
[cell].Formula = Replace([cell].Formula, ",,", ",""tos.rtd"",", 1)
End If
End If
Next [cell]
[wks].Calculate
Next [wks]
Set [rngFormula] = Nothing
With [Application]
.EnableEvents = True
.ScreenUpdating = True
End With
End Sub
'...................................................................................
I found this, courtesy of Raul Sarin, that may relate to your issue.
VBA code follows:
'..... Code Developed by Rahul Sarin to Fix Excel 2016 RTD issue with TOS........
Public Sub UpdateRTDFunction()
Dim wks As Worksheet
Dim rngFormula As Range, cell As Range
With [Application]
.EnableEvents = False
.ScreenUpdating = False
End With
For Each [wks] In ThisWorkbook.Worksheets
On Error Resume Next
Set [rngFormula] = [wks].Cells.SpecialCells(xlCellTypeFormulas)
On Error GoTo 0
If [rngFormula] Is Nothing Then: Exit Sub
For Each [cell] In [rngFormula]
If InStr(1, [cell].Formula, "RTD") > 0 Then
If InStr(1, [cell].Formula, ", ,") > 0 Then
[cell].Formula = Replace([cell].Formula, ", ,", ",""tos.rtd"",", 1)
Else
[cell].Formula = Replace([cell].Formula, ",,", ",""tos.rtd"",", 1)
End If
End If
Next [cell]
[wks].Calculate
Next [wks]
Set [rngFormula] = Nothing
With [Application]
.EnableEvents = True
.ScreenUpdating = True
End With
End Sub
'...................................................................................
That won't work for me - I do not even have the RTD add-in as an available option when I look in file>options>add-ins. I am quite surprised you are able to run it on Win10 + Excel 2016. What computer are you using? Did you do a 64 bit or 32 bit install of Office 2016? I tried both bit versions and no success.
RTD is NOT an add-in.
If you have TOS, open TOS, open Excel, go to TOS->Trade->All Products Then select your underlying, and option chain, then Export -> Microsoft Excel
Paste to your Excel, then you should have something to observe.
Note: the referenced "Export" above is one of the hiden menu items in the upper right corner of the "All Products" window.
You should be also able to "Google" "RTD John locke" get many hits.
If you have TOS, open TOS, open Excel, go to TOS->Trade->All Products Then select your underlying, and option chain, then Export -> Microsoft Excel
Paste to your Excel, then you should have something to observe.
Note: the referenced "Export" above is one of the hiden menu items in the upper right corner of the "All Products" window.
You should be also able to "Google" "RTD John locke" get many hits.
Already tried all that and a lot of other stuff. Believe me nothing works for me. Maybe my hardware is weird and does not play nice with Windows 10 (alienware). You're right in that it's not an addin in the typical sense. RTD uses a specific DLL that's supposed to preload at Excel launch (sortof like an invisible addin). In my case that DLL does not preload - even if I try to manually force the DLL it ignores it. Anyways I am resigned to my fate and have learned to live with OpenOffice.
I'm very curious. I am not familiar with a specific DLL -- do you know the filename of the DLL? Since you have already tried the obvious things, have you also tried to insure it is not something simple like the RTD ThrottleInterval set to -1 in Excel? -- I'm trying to insure the simple reasons have been investigated.
