Home                           

 Try Investor/RT             

 Investor/RT Tour           

 Getting Started              

 What's New                  

 Testimonials                 

  Q&A - Broken down by Topic . . .      Complete List of Questions - All Topics
     Charts and Technical Indicators      TPO Charts
     RTL: Scans, Signals, and Custom Indicators      Importing and Exporting
     Trading Systems and Backtesting      Schedules
     Quotepages, Portfolios and Custom Columns      Alarms / Alerts
     Data: Historical Data, the Database, and Data Services      User Variables (T# and V#)
     Custom Instruments: Spreads and Pairs      General / Miscellaneous
     Controls, Windows, and the Button Indicator      Autotrading
     Slide Shows      Product Line

 
Q&A Home

Investor/RT Answer
Answers to Common Questions

   

Question

My "Change", "%Change", and/or "Prev Close" columns is not showing the correct values.  What can I do?
   

Answer

This "Change" value is computed as a difference in price from the "Prev Close" (Previous day's closing price) quotepage column.  Some data services provide and update this previous close value each time you log in, while others do not.  Those that update it automatically should reliably show accurate Change, %Change, and Prev Close values.

If your data service is not reliably supplying this value, a custom column may be create to simulate the Change column.

Right-click on any column heading and choose "Add Custom Column".  Then double-click on the "New" choice in the list.  A new Custom Column Setup window should appear.

In the "Type" tab, select "Custom Indicator" and then click the "New Cust. Ind." button.  Create a custom indicator with the simple syntax:

SET(PREV, CL.1);
CL - CL.1

and save this custom indicator with a name like "myChange".  This custom indicator will serve two purposes.  The first line will set the Prev Close quotepage value to the close of the previous daily bar.  The second line will return a result of "Change" or current close minus previous days close.  By setting the Prev Close here properly, the %Change, Change, and Prev Close columns should reflect this.

Now, back in the Custom Column Setup window, make sure the new "myChange" custom indicator is selected from the list.  Also, make sure the periodicity control is set to "Daily" (to which it should default).

Now, click the "Add to Quotepage" button.  It should ask you for a name for this custom column, to which you might want to use something like "Chg".  Now, the Chg column should appear in the quotepage.  If the values still appear to be inaccurate, it's likely because the daily data is incomplete.  The last two daily bars are required (to be complete) in order for this to work properly.  Simply download a few days of daily data on the quotepage (click Download Data button in main toolbar) to correct this problem.

You may use the "Rules" tab of the Custom Column Setup window to customize the look of up/down prices, etc. (green for >0, red for <0, etc).