Morning guys
I did try and continue, but as it’s not my thread it didn’t let me post more than 3 times in a row. So thanks for replying and unlocking it ! 
5 Likes
I am back! I hope everyone made money in my absence, Thank you to everyone who kept things going while I was away.
5 Likes
Welcome back, not much has happened, and I am cautious about the US election this week.
Question: do you sort the pairs manually as this is not the 1st time I noticed a mix up in the numbers? Why not make Excel do the sorting as well as the math?
Included my current sort, which matches pretty much spot on, considering how close the numbers are.
1 Like
Welcome back Dennis,
Hope all went well for you.
2 Likes
Yes, and I do make mistakes, so don’t bet the farm on anything you see here
1 Like
I think this looks right, if you see any big differences let me know, There could be a flight to safety until the election results are final
2 Likes
Hello guys
As Dennis dedication and consistency inspired me to keep my own spreadsheet, I have added bond yields for USD, GBP, EUR and JPY. I focus mainly on these currencies only. I have a 2 year bond yield spread that I fill in daily that I can post on here from time to time if people find useful?
2 Likes
Welcome back!
1 Like
Watch out for some big volatility as the election results start coming in, it could be a wild night
I would say the markets like the way the US election went
4 Likes
2 Likes
Blood hell you’re still running this thread
2 Likes
2 Likes
Hi Mr Dennis, welcome back,
For some reason my numbers are quite different from yours, even though the currencies positions are the same.
Could you tell me what the closing price and the 200ma of the dollar on the 6th and 7th to figuere out what I am doing wrong, considering that my numbers were very close before you went on vacation.
I apologize for bothering you with this request and thank in advance
miguel arrieche.
1 Like
I’m not Dennis but here are some numbers to get you started, the more the merrier I always say. When you say “the dollar”, I hope you mean the USDJPY figures, here they are for 3 days, and supporting charts, broker is Blackbull.
Nov. 6 - C - 154.553, SMA - 148.950
Nov. 7 - C - 152.844, SMA - 149.246
Nov. 8 - C - 152.507, SMA - 149.511
When you say that your numbers are quite different, can you show us what you mean next time; more information when trouble shooting is helpful for all concerned.
And a bonus, here are the calculations for Close of the week, note: I don’t use decimal, makes it easier to do the data entry and make no difference, also my numbers are different from Dennis, but the order is usually the same, as you can see. And take no notice of Gold, it’s just something I do.
I used to try and see what the top players consider strong and and weak by obviously looking at the COT report, beautifully put together from https://www.tradingster.com/cot
I would divide long vs short positions of non commercials to generate a ratio that indicates how strong or weak a currency is
120,737/75,653=1.59593142374
60,334/104,501=0.57735332676
Therefore we have a GBPJPY long trade
1 Like
So you’re just looking at Commercial sentiment? Not including Retail sentiment? And you just trade with the bias apparently.
Surely you have seen the well-known theory of trading opposite Retail sentiment once it is at an extreme level.
There are sites that do this calculation, including many other fundamental data, not just sentiment; it must be laborious to do this for 28 pairs, good luck.
2 Likes
I am looking at Non-commercial which if I remember correctly from some youtube educational videos about the COT report, is where the big players are listed under.
I don’t include retail. Is it the third column under non-reportables? Any good use in it? Btw how come do you use the word ‘sentiment’ in your reply?
Defnietly. @The_Baller on here has mentioned, also the no nonsense forex youtube channel and then bumoed onto some twitter forex guy who showed a graph where the more the retail traders long, the more the price dives…and of course vice versa.
oh mane, I mnaully had to create a freaking excel spreadsheet to save myself some time then hired some freelnacer. what websites are these?
1 Like
Yen pairs closed the week on a down note, but US stocks had their best week in four years, and Bitcoin was at record highs. I would say the markets are giving their approval of how the US elections went
3 Likes
People wher confused . The election buy was for crypto not stocks , stocks will start their crash today especially Nivida crash
Chf jpy wil crash too