Excel analysis as a back testing tool - need help

Looking for help in locating indicators whose logic can be used for collecting statistics and analysing it.

It is a sort of visual Excel backtester where I input hypothetical TP or SL in Pips and hypothetical Open to Close Time in Minutes, price levels being touched by horizontal levels drawn on % percentage and plotted with Minimum and Maximum scale with Pips or % values.

Indicators should not depend on Moving Average or Dynamic values. Values should be constant and of closed candles.

Example: Yesterday High, Low and Mid is good. The value is constant. I can introduce % marked levels instead of Fibo scale or any Pivots.
ADR also falls in same category.

Which other indicators do you think can be used for plotting trades in such a way?

The Excel analysis tool will be for technology-challenged (including Excel newbies) retirees and housewives.

Will also appreciate if links for such a visual tool in Excel are posted .

Thank you in anticipation of your help

1. Dashboard idea for quick analysis of Futures Options trading
Only for BUying of Puts (for bearish view) In the money and Out of the money and for BUying of Calls (for bullish view)

2. Idea is to pull live Excel RTD data into sample spreadsheets provided by Interactive Brokers API.
Re-arrange the IB data and make simple arithmetic calculation and then link with the dashboard.

The Excel RTD tool is basically for the use of elderly and pensioners, most of whom are technology-challenged people.

The main interface will ask a few questions, gather information from IB, and display in the dashboard.

The trader can look for such an interface with his broker because CME does not offer live data for free.

You can use CME simulation tool to execute the trade.

Three strategies will be used based on Current Price of the asset selected.

Weak means the view about the market is bearish.

Go Down
Go Down violently

Moderate means the market is consolidating and is flat

Strong means the market is going to be BUllish
Go Up
Go up strongly

Having got this information, Excel dashboard will pull the information from IB and spreadsheet will do the caluclations and output will be through this tool.

Quick Guide to install IB TWS, and API from the links provided below

1. Get credentials with Paper Trading Account login and Pwd for setting up latest IB trading platform, known as TWS (trading work station) . 64-bit Window version.
2. Install the IBKR API for RTD server. It is 64-bit Excel compatible.
3. Locate a sample RTD spreadsheet which is provided within the API installation directory.


The IBKR API – RTD Server for Excel is a dynamic link library that allows our clients to request real-time market data from IBKR’s Trader Workstation (TWS) via our API, as well as Microsoft Excel. RTD technology is open source and thus very popular. It is a newer technology compared to Excel DDE and easier to use compared to VB-built ActiveX. Take a look at this comparison of Excel API features:
https://www.tradersinsight.news/wp-c...7/image-22.png
Image Source: IBKR API Support Team
Follow the below installation instructions:

1. Install the IBKR API from here http://interactivebrokers.github.io/.
   The RTD Server is built in C# so the source file will be installed in the TWS API/source/CSharpClient/TwsRtdServer directory.
2. The latest TWS from here: https://www.interactivebrokers.com/en/index.php?f=16040

1. Excel RTD Server API serves as a dynamic link library that helps algo traders get real-time market data from TWS via the API using Microsoft Excel. Explore this setup and requirements https://interactivebrokers.github.io...td_server.html

A sample RTD spreadsheet is provided within the API installation directory. Visit the GitHub page for details: https://interactivebrokers.github.io..._examples.html
Important to remember is that API installer for RTD Server is compatible with 64-bit Excel

Step by Step...

Step 1: Install IB API - it's a one time affair. You don't have to touch it later until a new version is available.
Go to:
http://interactivebrokers.github.io
Agree to terms.
Choose the stable version for your operating system (Windows or Mac/Unix).
Download and install.

Step 2: Enable API Access in IB TWS - Trader Workstation - trading platform.
Go to global configuration - API - Setting and check "Enable Activex and Socket Clients"

Step 3: IB Quotes Excel Formulas

The formulas are quite simple. I list a few examples below, but it is best to see official documentation for more examples and full list of parameters:
RTD Server for Excel > Simple Syntax
RTD Server for Excel > TWS RTD Server Samples
There are three types of syntax for these formulas: Simple, Complex, and Mixed. They differ in the way individual inputs (details like symbol, exchange, or currency) are arranged in the formula.

That’s it for the setup. You can now open Excel, write a formula into a cell and if all goes well you will see quotes from IB updated in real time.

Syntax for Simple style:

Forex (and Explanation of General Format)
Let’s get IB bid quote for the EUR/USD exchange rate in Excel.
The formula is:
=RTD("Tws.TwsRtdServerCtrl",,"EUR.USD/CASH", "Bid")

It has four parameters:

 

1. "Tws.TwsRtdServerCtrl" is the same for all formulas.
2. The second is empty (notice there are two commas).
3. Symbol (in this case "EUR.USD/CASH").
4. Type of quote, named Topic in the documentation. It can be "Bid", "Ask", "Last", or some other things. If omitted, it defaults to "Last".

Forex: EUR/USD
Once you enter the formula in an Excel cell and hit Enter, you should see the EUR/USD rate updating in real time.
If something goes wrong, you will see an error message instead of the quote.
For example, if you try to get a quote for an invalid symbol like "ABC.USD/CASH", you will see this text in the Excel cell:
TwsRtdServer error: No security definition has been found for the request,

Futures

With futures you also need to specify expiration:
=RTD("Tws.TwsRtdServerCtrl",,"ES@GLOBEX//FUT/202009///USD", "Bid")

Options

With options you also need the strike and call/put:
=RTD("Tws.TwsRtdServerCtrl",,"AAPL@SMART//OPT/20200717/C/360/USD", "Bid")
Quote Types
Besides bid, ask, and last, there are many different kinds of quotes you can request:

1. “BidSize”
2. “Bid”
3. “Ask”
4. “AskSize”
5. “Last” (default)
6. “LastSize”
7. “High”
8. “Low”
9. “Volume”
10. “Close”
11. “Open”
12. “LastTime”

For options also things such as:

1. “BidImpliedVol”
2. “BidDelta”
3. “BidUndPrice”
4. “AskImpliedVol”

IB treats stock options as Options and Futures Options as FOP.
This link is for stock options for reference.
https://tradersacademy.online/tradin...nt-information

… and much more
https://interactivebrokers.github.io...e_syntax_topic

IB 100 lines limitation

https://ibkr.info/article/3292

Why some financial instruments show question marks instead of data?
There are various functions and tools in TWS using market data: watchlists, charts, trading or analytical tools, alarms. In general, any foreground window which actively uses market data for display or for calculations, will increase the total number of market data channels currently opened. Once you have exceeded the maximum Market Data allowance for your account, you will be prevented from receiving additional market data. In this case, one or more tickers will show a "?" instead of actual quotes and your TWS will display the following warning message:
"You have requested data for XXX contracts simultaneously, which exceeds your account current limit of YYY. You may increase your limit by subscribing to market data Booster Packs."

Another interface I like covers the following: