RTD Linking Tabular History
Reading Time: 8 minutesRTD (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
Read MoreScrolling News
Reading Time: < 1 minuteThe News Index will display headlines as the stories come in, Double-click on a headline to open the News Page. News Index Display Properties Index Fonts
Read MoreScrolling vs. Fixed News Indexes
Reading Time: 2 minutesProphetX maintains two news databases. The scrolling news database – Scrolling news stories are generated as the news comes in from the various contributors and continually generates additional stories as they come in. If there is new information, a new story is generated and the last story is dropped from the list. Typically, scrolling news
Read MoreSearch Fixed News
Reading Time: 2 minutesExample of search results: Word searching in fixed news uses the same rules as scrolling news above. Using Wildcards in News Searches Entering soy as a keyword will return only headlines with the word “soy” in them. Use the following wildcards to expand the search. Use a question mark to indicate any one character. Examples:
Read MoreSearch Scrolling News
Reading Time: 3 minutesTo search for specific information, Select News/Search Scrolling News from the Main Menu Bar Scrolling news can be searched by all sources (*) or by individual news sources. Make your selection from the list at the top of the dialog box Keywords: Keyword searches allow you to find all news stories that have that word
Read MoreSearching Dow Jones News
Reading Time: 2 minutesMany times Dow Jones News must be searched for by category codes in order to view more extensive news. The list of category codes is located under the Symbol Search and Symbol Guide Selection in the navigation bar on the left side of your screen. Dow Jones Codes DJ Commodities Service Userguide DJ Energy Service
Read MoreSeasonal Charting
Reading Time: 5 minutesA seasonal chart shows a year over year view of an instrument and compares day by day throughout the season. In addition, you can add a seasonal average using the Multi-year average for futures or Seasonal Average for cash priced instruments, as well as a Multi-year range or Season Range for futures and cash instruments.
Read MoreSelecting Chart Instruments
Reading Time: < 1 minuteSymbols on the chart can easily be selected so that various functions can be applied to all the activated instruments at the same time. Click on the “diamond” activation icon next to the chart symbol in the Quote Window. When the “diamond” is activated, right mouse click to adjust the properties for that instrument. Only
Read MoreSelecting Quote Window Areas for Customizing
Reading Time: 2 minutesThe format of ProphetX quote windows is similar to those in common spreadsheet programs. When you right-click on any part of the window, the pop-up menu will display commands available for customizing it. To Customize the Entire Sheet Right-click on the quote sheet, then select Sheet Properties on the pop-up menu. (If a cell, column,
Read MoreSeries Settings
Reading Time: 2 minutesThe Series display shows call and puts in and out of the money for individual options months. Pricing Model Model – Select the default model – Black, Black Scholes, Garman K, CRR European or CRR American IV Curve Select the curve to be calculated. IV Update – Specifies when the options should update Option
Read More