Hanover replies to PMs

I want to thank you hanover for everything you have done.
I am currently updating some of the libraries and code you have created
I have built a server to fetch format data using custom API calls documented API's and Undocumented API's for MT4 and MT5 Intergration
Thank you so much for all of your efforts and guidance from previous posts..

Thank you so much.
My appreciation for your work on FF can not be expressed it is worth more than words can express..

I hope you are aware of my b600+ updated file of hanover's b509 utilities: hanover --- extensible functions b600 (np).mqh

... from my thread: Modified, useful MQ4 utilities, indicators, and related tips

When you said you "built a server to fetch format data", by chance do you mean you have code to download ForexFactory HTML news and convert it to a .csv file? If yes, please share.

If you make further updates, please post them here and/or in my thread.

Thanks, and as always, thanks Hanover for the utilities!

Kent (pips4life)

I didnt know.. I will check it out soon after I post this..

Good luck dear hanover You are one of those brutally honest guys around here, among many good people here among my time, if i remember correctly
Just logged in here myself after 3 yrs (after an earlier halt of half decade or so), but can't prevent myself replying to this

Guys, read what this guys says. You won't get some ready made recipe to make dough, but will get some good nuggets
In my 13+ yrs of my trading, among all things online, i have seen total nuggets of the size of bucket and useless noise/BS of the size of solar system. So when someone points towards something, read/listen

may u provide me economic calandar csv file from 2004 to 2021?

wow.. you are amazing what wealth of fx info. Thank you for your thread.

A one-off post: one of the most dastardly difficult problems I’ve found with Excel formulae is to devise one that will convert text to a number value (in a single cell), by stripping out everything not in the set {0,1,2,3,4,5,6,7,8,9,.,-}

I’d like to share a formula that will achieve the following:

1. l The digits 0-9 are retained, in order, from left to right
2. l The first occurrence of a period/fullstop from the left is to be deemed to be a decimal point
3. l If there are one or more occurrences of a minus symbol anywhere within the text, the value is considered to be negative
4. l If the rightmost character is T, B (or G), M, or K, these are deemed to be trillion (or tera-), billion (or giga-), million (or mega-) and thousand, respectively
5. l If the rightmost character is a % symbol, the result is divided by 100, converting the percentage to a decimal fraction
6. l For the sake of FF’s calendar, any entry including a vertical bar (|) remains as is (this is because | is used to separate multiple values)
7. l All other characters (including $,£,¢, etc) are omitted from the result, and everything remaining is converted into a number value
8. l If there are no digits (0-9) found in the cell, the result is 0

Below is the formula which should achieve all of this. It assumes that the text cell to be converted is B4 (change every occurrence of ‘B4’ to any cell reference you need). I should point out that I’ve used the free Excel-lookalike product WPS Office; perhaps somebody would like to confirm that the formula also works correctly in the different Microsoft Excel products.

Credit where credit’s due: I learned a lot (especially about creating arrays and spills using INDIRECT()), and used this as my starting point:
https://exceltrick.com/how-to/extrac...ells-in-excel/

If you prefer to use a comma as your decimal point, just change every occurrence of "." in the formula to ","
But if you otherwise want to modify the formula, you’re on your own. I don’t want to spend time replying to posts. Sorry.

Here’s the final formula. I’m sure that it could be simplified to something more concise (have fun!):

=IF(ISERR(FIND("|",B4)),(10^-SUM(1*INDEX(ISNUMBER(--MID(RIGHT(B4,IF(ISERR(FIND(".",B4)),0,LEN(B4)-FIND(".",B4))),ROW(INDIRECT("$1:$"&LEN(RIGHT(B4,IF(ISERR(FIND(".",B4)),0,LEN(B4)-FIND(".",B4)))))),1)),0)))*(1-2*(SIGN(LEN(B4)-LEN(SUBSTITUTE(B4,"-","")))))*VALUE("0"&IF(SUM(LEN(B4)-LEN(SUBSTITUTE(B4,{"0","1","2","3","4","5","6","7","8","9"},"")))>0,SUMPRODUCT(MID(0&B4,LARGE(INDEX(ISNUMBER(--MID(B4,ROW(INDIRECT("$1:$"&LEN(B4))),1))*ROW(INDIRECT("$1:$"&LEN(B4))),0),ROW(INDIRECT("$1:$"&LEN(B4))))+1,1)*10^ROW(INDIRECT("$1:$"&LEN(B4)))/10),""))*IF(RIGHT(UPPER(B4))="T",10^12,IF(OR(RIGHT(UPPER(B4))="B",RIGHT(UPPER(B4))="G"),10^9,IF(RIGHT(UPPER(B4))="M",10^6,IF(RIGHT(UPPER(B4))="K",10^3,IF(RIGHT(B4)="%",0.01,1))))),B4)


The formula can be broken down as follows:
This section handles the decimal point
This section handles any negative sign
This is the main part of the conversion
This section handles the T, B (or G), M, K, % multipliers

It has been tested on the following:

There are plenty of YouTube videos explaining how to use AI (e.g. ChatGPT) to write simple MT4/5 EAs, including entry rules, SL, TP, sizing and risk management. I won't recommend anything specifically, because I don't want to be accused of promoting anybody. However, it's easy to get ideas using YouTube's search engine (e.g. "How to create a MT5 EA using ChatGPT"). Why go to the trouble and cost of engaging a coder if it's possible to do it yourself?

Admittedly, you need to be very specific and unambiguous with your instructions to ChatGPT, and it can take multiple attempts (and revisions of the code it generates) until it understands you fully. If you get compile errors, simply copy and paste the error messages into the chat session, and the AI should be smart enough to fix the code for you. It's not perfect yet -- but its intelligence is rapidly improving as technology continues to progress -- and it's still pretty amazing what it can do.

I'm not doing any MT4/5 at the moment, but I've been using youchat (ChatGPT's little brother) as an assistant to write, debug, translate and document sections of python code. It can save many hours of work, once you become familiar with how to use it optimally. Breaking a project down to small individual tasks and modules is the best way that I've found, at least so far. Last year I gained a diploma in AI, but I'm still very much learning myself.

And please don't assume from this that I'm promoting trading as an alternative to conventional employment. I'm a software developer, NOT A PRO TRADER.

Sorry, but I'm not offering any help with this, I just want to make people aware of what's possible nowadays. You have nothing to lose by giving it a try.

I have tried everything to make the recent sr indicator work and nothing, is it working for everybody else?

Response is in Recent SR thread.

Two unique indicators

Here and here are two indicators that could potentially be added as an adjunct to any existing day trading system. They look at two aspects of daily price movement from an independent perspective, one that's not covered by 'conventional' indicators.

First, a disclaimer: I'm definitely NOT a pro trader, although I did spend more than 15 years studying the financial markets, and coding and testing indicators and automated strategies (EAs) for MT4. I also attended pay-for-view tutorials and workshops from 4-5 people who claimed to be institutional traders. So is it possible to make a systematic income from trading retail forex? I don't know whether the emergence of new tech while I've been absent for the last 3-4 years has increased or decreased the level of difficulty involved; and I've been away too long to know if any honest and reputable MT4/5 brokers exist. I do remember reaching the conclusion that there are instruments (stock indices, metals, cryptos, ...) that 'trend' more cleanly and reliably, and have less conflicting forces manipulating them, than currency pairs.

Anyway, about these two indicators:

The first link is to the 'Daily H-L histogram'. This looks at past daily highs and lows and the hour during the day which they occurred. It plots a frequency histogram of how often past highs and lows have occurred during each one of the 24 hours in the day. Because sessions for different markets (Asian, European, American) are open, and also overlap, at various times during the day, and heavyweight traders go through various routines (of course there are more bots trading now), the highs and lows tend to form something approaching a uniform distribution. Presumably there's an advantage in knowing how likely, statistically, that a local high/low might turn out to be the day's absolute high/low. There's enough consistency in the distribution to suggest to me that it's not a random coincidence.

The second link is to the 'Room to move' indicator. This works on the ADR, and plots lines where price would need to move to, based on the high and low so far during the day, to achieve 50%, 75% and 100% (or any % values that you wish) of the ADR for the given instrument. There's a graphic in the link showing how the values are calculated, and more info on what they mean. This is based on the statistical assumption that, on average, price is unlikely to exceed its ADR by a large amount. Again, this information could be useful in confirming whether an entry or exit is more likely to be at an extreme, based on price's average 'room to move'.

Please feel welcome to experiment with these indicators. It's best to load only the .ex4 files, as the .mq4s were probably compiled using the build 509 compiler, which means that they will likely compile with a zillion errors if compiled using the latest MT4 version. For more info, please see the links.

Please feel welcome to let everybody know if these indicators are advantageous in improving trading performance, and if so, how best to use them.

Thanks,
David

Footnote: I don't have MT5 versions of these indicators. Sorry.