Chart Undo / Redo

You can Undo and Redo up to the last 5 major actions that have been done in a charting session. When a chart window is open, the Undo and Redo buttons can be found on the Context Bar at the bottom of the page. This can also be done using standard keyboard shortcuts. Ctrl+Z for

ChartIt

ChartIt is a premium feature that allows the user to easily import their own proprietary data. Please contact your sales representative in order to have it added to your services. To start importing your own data Open a Chart window in ProphetX. At the bottom of the screen, on the context tool bar, click on

Excel Add-in Field Descriptions

Field Descriptions for fields that can be used in the Excel Add-in % Change Calculated field created by ProphetX – percent change of Last Price from Previous price 52 Week High 52 Week High Price 52 Week High Date Date on which the 52 week high occurred 52 Week Low 52 Week Low Price 52

Add-in Preferences

The Add-in preferences button displays the preferences menu, which set the background preferences in the spreadsheet. Click on Preferences The User Preferences display will pop up. The Themes, light, medium, and dark indicate how intense the color theme will display. The Static Gold theme will use a specific gold theme. The example below displays each

Add-in Change Symbol

Once you have data for quotes, history, or charts, you can change the symbol that is currently in the display to a different one. Double-click on the symbol and change it to a new symbol or expression. The entire display will change to the data for that symbol. Ex:  In the spreadsheet below we have

Add-in Study Properties

When you add a study to a history or chart display you can then highlight the study in the Symbol List and then change the study properties. Start by selecting History, or Charts Enter or look up the symbol(s) you want to display Click on the Action button Add the preferred study Click on the

Add-in Select Study

When creating history or charts, you can also add studies to them. Start by selecting History, or Charts Enter or look up the symbol(s) you want to display Click on the Action button Select Add Study The list of available studies will display Select the study you want to add The study will be added

Add-in Hide/Show Columns

Show/Hide Columns lets you determine which columns you want to display in the Symbol List dialog box. Start by selecting Quotes, History, or Charts Enter or look up the symbol(s) you want to display in the spreadsheet Click on the Action button Select Hide/Show Columns Click to check the columns you want to show. Click

Add-in Lead/Lag

The Lead/Lag selection under Action will shift data “x” number of periods forward (lead) or backward (lag).  An example of where you might want to use this is to compare today’s price to yesterday’s price. Start by selecting History, or Charts Enter or look up the symbol(s) you want to display Click on the Action

Add-in Units Conversion

Units conversion will convert the symbol(s) from one unit to another, just as barrels to gallons, or bushels to tons. Start by selecting Quotes, History, or Charts Enter or look up the symbol(s) you want to display Click on the Action button Select the current units: Select the units to convert to: Examples showing history