Search results

Excel Macros to turn formulas on/off start/stop label/formula enable/disable Sub FormulaON() Application.ScreenUpdating = False '''Makes the code run a lot faster Application.Calculation = xlManual Range("A1:A5").Select '''Cells containing...

Excel-DDE-V2.xls handles both Stock and Option Quotes.

Dynamic Data Exchange (DDE) with Thinkorswim and Excel See the attached spreadsheet for a Quick and easy way to use DDE with Thinkorswim and Excel.

Turning Dynamic Data Exchange DDE on and off Click here to see what Microsoft says about turning DDE on/off According to Microsoft: “When a new workbook is created, the default value for the UpdateRemoteReferences property is True and dynamic data exchange (DDE) links and OLE links...

I know this doesn't sound logical, but I've found doing a replace on the equal sign can activate DDE formulas after they are copied in Excel. The VBA statement is: Selection.Replace What:="=", Replacement:="="

This is how I do it (a Document is also attached): Sub MakeDDE() Dim ExpDt As Date For CurRow = 2 To 11 DDERoot = "=TOS|MARK!'" 'Single then Double Quote at the end StkSym = "." & Cells(CurRow, 1) '''Period is needed for Options ExpDt...