@Garfiled Can you please have a look at the attached Template with VBA for executing commands? I used the (For Loop with If). I have not yet included the Stop Loss/Target profit (in the VBA) as I was not sure if I need an Identifier for each trade ...

@Garfield Your test results are correct. I checked them when I went back home. I am attaching the Test Results with an additional sheet (Analytics tab). I will use it as a template for recording future test results. The sections can be copied down ...

Yes, all columns are extended to the last row. I am attaching GBOUSD and USDCAD. I first tested each one after another. Not the same one over. Alternated between them. The first two rounds, they matched. In the third round, they differed. ...

It was not specific to any pair. Attached some of the Data I was testing.

Thanks, Garfield. You are a true champ.. I am attaching a small test report for random 10 pairs. The percentages were 0.2 Percent. I think I may open a new account and fund it for the purpose of testing all pairs. Or go demo for 28 pairs..

The first sheet is AUDCHF15 Row 158 and 159 have short TP hit twice. The Second sheet is EURCAD15 Rows 135 and 136 have Long TP Hit twice There may be more as I have not scrolled down to the end of the data series. Thanks,

@Garfield Hey Garfield, Here is the template with stochastics 5, 14, 24, 36, and also EMAs 20, 34, 50... On the left of the sheet, there is a row colored in red. Since I am using the Excel history formula, it can be replaced by any .CSV data as long ...

It was such a long time since Excel has announced the stock history function. They released a beta version enclosed to certain subscribers. I just learned that it is now available for 365 Excel subscribers. It is offering Daily/Weekly/Monthly for ...

I will my short story and opinion. In short: Not so far... I tried with my broker and opened a demo account for MT5 which has stocks. I could not retrieve any data. However, I was able to retrieve a symbol list of the instruments in this attached ...

Backtesting: I am working on a templatge to backtest any strategy. It is still a work in progress.. The strategy is a simple one: 1- Long when Close is above SMA 10 and close is above SMA 20. 2- SMA10 is bigger than SMA 20 and SMA10 a bar ago is ...

Multi Time Frame Candlestick Direction (M5 to weekly) This is a dashboard that calculates (current price - open / open * 100) for M5,M15,M30, H1,H4,D,W). @Garfield It seems that when retrieving highs and lows for many pairs in multiple time frames, ...

Changed Xlook UP to VLook up. Placed the percentage column next to the symbols column and then changed the function.

Attached a template for One Time Frame. You can copy it and only type the TF at the top and everything will be adjusted accordingly. The calculation I made: 1- Retrieved EMA (10) data for 10 bars including the current bar (from current 0 to 9 bars ...

Breakout Dashboard... It is becoming a favorite and has traded the last three trades (in my other thread) based on it. Of course, I do not trade blindly based on a dashboard only but use it as a head-up for where I should look for an anticipated ...

I have it ready now. Please check it and I will check it again tomorrow as I have not had enough time to test it. My head is spinning around. It took more time than I thought. This Sheet will show if the trend is down or up and show 50 and 61.8 fib ...

Single Pairs' Strength and Currency strength based on Fractals/swing indicator... The 'Pairs Swing Strength' Sheet has 5 inputs you can change. The first three are for time frames. The fourth input (Swing Bars) are for choosing how many bars for the ...

Hi garfield, Attached your workbook with FIBS. When the cell says "one level", it is either 0.5 or 61.8. I followed the same logic you want in the dashboard. When it says "both levels", it means the price is close to both 50 and 61.8 within the ...

Candlestick Direction in MTF A simple workbook to find candlestick direction in multi-timeframe and the percentage of the move (close - open)/open *100. Then I added the %move for each currency group. The first column on the left has all pairs and ...

Thank you for checking the indicator's values with MT4. It was a mistake from my part as I referenced "close" within the indicator and it was unnecessary and influenced the output value somehow. I am reattaching the same workbook with corrected ...

Hi garfield75, I am attaching a workbook for Fibonacci calculations based on legs that has two sheets; each one of them has a different calculation. The first sheet named "Swing High Low" is using the @swingh and @swingl indicators. Swing high and ...