The History selection in the ProphetX Excel Add-in retrieves historic data for the symbol or expression entered in the Symbol List. With History you can also specify the order the data will be displayed, the time interval and how far back you want to retrieve the history. In addition, the history can also be converted
Excel
Excel Add-In Action Button
Symbols When creating quotes, history, or charts in Excel Add-in, the Action button shown under the symbol list in the dialog box. Various activities can be chosen depending on which selection you’ve made. Before selecting the Action you must enter the symbol. In the “Add symbol or expression” text box, either type the
Quotes Add-in
The Quotes selection in the Excel Add-in will display individual quotes or futures chains. In addition, you can do currency or units conversions on the data and select the fields and layout orientation. Select Quotes from the ProphetX Add-in menu. The Quotes dialog box opens for your criteria. Under Add Symbol, either type the symbol
Installing and Troubleshooting the ProphetX Excel Add-in
Run Prophet X installer. You can download by clicking here Navigate through the installer until you get to the Choose Components screen. Here you will make sure both Prophet X and Prophet X Excel Add-in are checked. After it is completed, you want to start Prophet X and log in before you do anything with
DDE Linking Tabular History
ProphetX’s tabular displays allow you to dynamically link historical data to a spreadsheet. Right-click in the tabular window and select Format Excel Link… from the pop-up menu. In the linking dialog box, select the Fields in the Time Range or Size (the number of rows to link). If you’ve already highlighted all the data you
RTD (Real Time Data) Linking Quotes
RTD offers an updated alternative to DDE linking to Excel spreadsheets. RTD offers the following advantages: Has Excel function-like syntax Puts the real-time data in a cell Can use cell references as part of the formula Updates in real time, frequency based on user configurations Is extremely efficient Is able to drive calculation; formulas based
DDE Linking Quotes
Linking Live Quote Data Into Excel You can link real-time prices from a quote sheet into an Excel spreadsheet. The linked prices will continue to update in real time. Note: ProphetX no longer uses DDE as the Default linking into Excel instead it uses RTD Linking. You can still use DDE but you will need
Linking Data From the Options Strike View
When linking from Options, you have the choice of doing standard DDE linking or the updated RTD linking. For additional information on the differences between RTD and DDE, go to RTD Linking and DDE Linking under Linking Quote Data to Spreadsheets. To select your preference: Select the Settings button () or File/Settings from the Main
Linking Data from the Options Series View
Linking Options Data from the Series View Display When linking from Options, you have the choice of doing standard DDE linking or the updated RTD linking. To select your preference: Select the Settings button () or File/Settings from the Main Menu Bar Click on the General selection Under Format Links as, select DDE The
RTD Linking Tabular History
RTD (Real Time Data) is an updated alternative to DDE that allows you to dynamically link historical data to a spreadsheet. This method offers the following advantages over DDE: Has Excel function-like syntax Can use cell references as part of the formula Updates in real time, frequency based on user configurations Is extremely efficient