Rival One for Excel

Direct from the Microsoft Store

1. Microsoft Store

Inside of Excel

1. In Microsoft Excel, or Excel Online, look for the add-ins icon in the Home tab

2. Select More Add-Ins, and on the Store search page search for Rival One

1. On task pane add, we authenticate using Auth0 with a previously setup an authorized email address.
2. You will receive an OTP email from tokens@rivalsystems.com.

Populates a sheet with data for instruments for which you have a current position and trades.

1. Please note the function name is RIVAL.SUB

2.Select the data you want to display and click Subscribe.

3. To populate a specific cell with data for an instrument for which you have a current position:

Use the RIVAL.SUB formula with the instrument key and data field name.

• Example: =RIVAL.SUB("SIZ3.CME-COMEX", "TotalPnl")

4. To populate a specific cell with market data for an instrument where you don’t currently have a position:

• Use the RIVAL.SUB formula with the symbol as the key and one of the following data field names (“bid”, “ask”, “last”, “bqty”, “aqty”, “lqty”, “settle”, “prevsettle”, “open”, “high”, “low”, “close”).

• Example: =RIVAL.SUB("SIZ3", "bid")