Creating (Sales Price) Index Formulas

Creating (Sales Price) Index Formulas

cieTrade allows you to create Index Formulas for Brokerage transactions that will determine your Purchase or Buy Price from the Sales or Sell Price on each specific Worksheet. We call these (Sales Price) Index Formulas.

To enter a new (Sales Price) Index Formula:

1. Navigate to Pricing > Index Formulas and click the New Formula button that appears in the top right corner. 
2. Select the (Sales Price) option from the Index Name drop-down menu. 
3. A (Sales Price) Formula can be entered using one of two Formula Type calculation methods:

• Fixed - This is a fixed dollar amount to be added to or subtracted from (use - to indicate a reduction in price) the Sales Price. Enter the amount in the Discount field.

• Percentage - This is a numeric percentage value by which you will alter the index (use of - is permitted). Enter the percentage in the Factor field.

4. Use the Min. Price and Max Price fields to set an acceptable range in which the calculated price should fall.

5. Click Save Changes to add your new formula.

If you have additional questions, please contact the Support Team via email to support@cietrade.net.