Download Historical Forex Data into Excel

Former investment bank FX trader: Risk management part II

Former investment bank FX trader: Risk management part II
Firstly, thanks for the overwhelming comments and feedback. Genuinely really appreciated. I am pleased 500+ of you find it useful.
If you didn't read the first post you can do so here: risk management part I. You'll need to do so in order to make sense of the topic.
As ever please comment/reply below with questions or feedback and I'll do my best to get back to you.
Part II
  • Letting stops breathe
  • When to change a stop
  • Entering and exiting winning positions
  • Risk:reward ratios
  • Risk-adjusted returns

Letting stops breathe

We talked earlier about giving a position enough room to breathe so it is not stopped out in day-to-day noise.
Let’s consider the chart below and imagine you had a trailing stop. It would be super painful to miss out on the wider move just because you left a stop that was too tight.

Imagine being long and stopped out on a meaningless retracement ... ouch!
One simple technique is simply to look at your chosen chart - let’s say daily bars. And then look at previous trends and use the measuring tool. Those generally look something like this and then you just click and drag to measure.
For example if we wanted to bet on a downtrend on the chart above we might look at the biggest retracement on the previous uptrend. That max drawdown was about 100 pips or just under 1%. So you’d want your stop to be able to withstand at least that.
If market conditions have changed - for example if CVIX has risen - and daily ranges are now higher you should incorporate that. If you know a big event is coming up you might think about that, too. The human brain is a remarkable tool and the power of the eye-ball method is not to be dismissed. This is how most discretionary traders do it.
There are also more analytical approaches.
Some look at the Average True Range (ATR). This attempts to capture the volatility of a pair, typically averaged over a number of sessions. It looks at three separate measures and takes the largest reading. Think of this as a moving average of how much a pair moves.
For example, below shows the daily move in EURUSD was around 60 pips before spiking to 140 pips in March. Conditions were clearly far more volatile in March. Accordingly, you would need to leave your stop further away in March and take a correspondingly smaller position size.

ATR is available on pretty much all charting systems
Professional traders tend to use standard deviation as a measure of volatility instead of ATR. There are advantages and disadvantages to both. Averages are useful but can be misleading when regimes switch (see above chart).
Once you have chosen a measure of volatility, stop distance can then be back-tested and optimised. For example does 2x ATR work best or 5x ATR for a given style and time horizon?
Discretionary traders may still eye-ball the ATR or standard deviation to get a feeling for how it has changed over time and what ‘normal’ feels like for a chosen study period - daily, weekly, monthly etc.

Reasons to change a stop

As a general rule you should be disciplined and not change your stops. Remember - losers average losers. This is really hard at first and we’re going to look at that in more detail later.
There are some good reasons to modify stops but they are rare.
One reason is if another risk management process demands you stop trading and close positions. We’ll look at this later. In that case just close out your positions at market and take the loss/gains as they are.
Another is event risk. If you have some big upcoming data like Non Farm Payrolls that you know can move the market +/- 150 pips and you have no edge going into the release then many traders will take off or scale down their positions. They’ll go back into the positions when the data is out and the market has quietened down after fifteen minutes or so. This is a matter of some debate - many traders consider it a coin toss and argue you win some and lose some and it all averages out.
Trailing stops can also be used to ‘lock in’ profits. We looked at those before. As the trade moves in your favour (say up if you are long) the stop loss ratchets with it. This means you may well end up ‘stopping out’ at a profit - as per the below example.

The mighty trailing stop loss order
It is perfectly reasonable to have your stop loss move in the direction of PNL. This is not exposing you to more risk than you originally were comfortable with. It is taking less and less risk as the trade moves in your favour. Trend-followers in particular love trailing stops.
One final question traders ask is what they should do if they get stopped out but still like the trade. Should they try the same trade again a day later for the same reasons? Nope. Look for a different trade rather than getting emotionally wed to the original idea.
Let’s say a particular stock looked cheap based on valuation metrics yesterday, you bought, it went down and you got stopped out. Well, it is going to look even better on those same metrics today. Maybe the market just doesn’t respect value at the moment and is driven by momentum. Wait it out.
Otherwise, why even have a stop in the first place?

Entering and exiting winning positions

Take profits are the opposite of stop losses. They are also resting orders, left with the broker, to automatically close your position if it reaches a certain price.
Imagine I’m long EURUSD at 1.1250. If it hits a previous high of 1.1400 (150 pips higher) I will leave a sell order to take profit and close the position.
The rookie mistake on take profits is to take profit too early. One should start from the assumption that you will win on no more than half of your trades. Therefore you will need to ensure that you win more on the ones that work than you lose on those that don’t.

Sad to say but incredibly common: retail traders often take profits way too early
This is going to be the exact opposite of what your emotions want you to do. We are going to look at that in the Psychology of Trading chapter.
Remember: let winners run. Just like stops you need to know in advance the level where you will close out at a profit. Then let the trade happen. Don’t override yourself and let emotions force you to take a small profit. A classic mistake to avoid.
The trader puts on a trade and it almost stops out before rebounding. As soon as it is slightly in the money they spook and cut out, instead of letting it run to their original take profit. Do not do this.

Entering positions with limit orders

That covers exiting a position but how about getting into one?
Take profits can also be left speculatively to enter a position. Sometimes referred to as “bids” (buy orders) or “offers” (sell orders). Imagine the price is 1.1250 and the recent low is 1.1205.
You might wish to leave a bid around 1.2010 to enter a long position, if the market reaches that price. This way you don’t need to sit at the computer and wait.
Again, typically traders will use tech analysis to identify attractive levels. Again - other traders will cluster with your orders. Just like the stop loss we need to bake that in.
So this time if we know everyone is going to buy around the recent low of 1.1205 we might leave the take profit bit a little bit above there at 1.1210 to ensure it gets done. Sure it costs 5 more pips but how mad would you be if the low was 1.1207 and then it rallied a hundred points and you didn’t have the trade on?!
There are two more methods that traders often use for entering a position.
Scaling in is one such technique. Let’s imagine that you think we are in a long-term bulltrend for AUDUSD but experiencing a brief retracement. You want to take a total position of 500,000 AUD and don’t have a strong view on the current price action.
You might therefore leave a series of five bids of 100,000. As the price moves lower each one gets hit. The nice thing about scaling in is it reduces pressure on you to pick the perfect level. Of course the risk is that not all your orders get hit before the price moves higher and you have to trade at-market.
Pyramiding is the second technique. Pyramiding is for take profits what a trailing stop loss is to regular stops. It is especially common for momentum traders.

Pyramiding into a position means buying more as it goes in your favour
Again let’s imagine we’re bullish AUDUSD and want to take a position of 500,000 AUD.
Here we add 100,000 when our first signal is reached. Then we add subsequent clips of 100,000 when the trade moves in our favour. We are waiting for confirmation that the move is correct.
Obviously this is quite nice as we humans love trading when it goes in our direction. However, the drawback is obvious: we haven’t had the full amount of risk on from the start of the trend.
You can see the attractions and drawbacks of both approaches. It is best to experiment and choose techniques that work for your own personal psychology as these will be the easiest for you to stick with and build a disciplined process around.

Risk:reward and win ratios

Be extremely skeptical of people who claim to win on 80% of trades. Most traders will win on roughly 50% of trades and lose on 50% of trades. This is why risk management is so important!
Once you start keeping a trading journal you’ll be able to see how the win/loss ratio looks for you. Until then, assume you’re typical and that every other trade will lose money.
If that is the case then you need to be sure you make more on the wins than you lose on the losses. You can see the effect of this below.

A combination of win % and risk:reward ratio determine if you are profitable
A typical rule of thumb is that a ratio of 1:3 works well for most traders.
That is, if you are prepared to risk 100 pips on your stop you should be setting a take profit at a level that would return you 300 pips.
One needn’t be religious about these numbers - 11 pips and 28 pips would be perfectly fine - but they are a guideline.
Again - you should still use technical analysis to find meaningful chart levels for both the stop and take profit. Don’t just blindly take your stop distance and do 3x the pips on the other side as your take profit. Use the ratio to set approximate targets and then look for a relevant resistance or support level in that kind of region.

Risk-adjusted returns

Not all returns are equal. Suppose you are examining the track record of two traders. Now, both have produced a return of 14% over the year. Not bad!
The first trader, however, made hundreds of small bets throughout the year and his cumulative PNL looked like the left image below.
The second trader made just one bet — he sold CADJPY at the start of the year — and his PNL looked like the right image below with lots of large drawdowns and volatility.
Would you rather have the first trading record or the second?
If you were investing money and betting on who would do well next year which would you choose? Of course all sensible people would choose the first trader. Yet if you look only at returns one cannot distinguish between the two. Both are up 14% at that point in time. This is where the Sharpe ratio helps .
A high Sharpe ratio indicates that a portfolio has better risk-adjusted performance. One cannot sensibly compare returns without considering the risk taken to earn that return.
If I can earn 80% of the return of another investor at only 50% of the risk then a rational investor should simply leverage me at 2x and enjoy 160% of the return at the same level of risk.
This is very important in the context of Execution Advisor algorithms (EAs) that are popular in the retail community. You must evaluate historic performance by its risk-adjusted return — not just the nominal return. Incidentally look at the Sharpe ratio of ones that have been live for a year or more ...
Otherwise an EA developer could produce two EAs: the first simply buys at 1000:1 leverage on January 1st ; and the second sells in the same manner. At the end of the year, one of them will be discarded and the other will look incredible. Its risk-adjusted return, however, would be abysmal and the odds of repeated success are similarly poor.

Sharpe ratio

The Sharpe ratio works like this:
  • It takes the average returns of your strategy;
  • It deducts from these the risk-free rate of return i.e. the rate anyone could have got by investing in US government bonds with very little risk;
  • It then divides this total return by its own volatility - the more smooth the return the higher and better the Sharpe, the more volatile the lower and worse the Sharpe.
For example, say the return last year was 15% with a volatility of 10% and US bonds are trading at 2%. That gives (15-2)/10 or a Sharpe ratio of 1.3. As a rule of thumb a Sharpe ratio of above 0.5 would be considered decent for a discretionary retail trader. Above 1 is excellent.
You don’t really need to know how to calculate Sharpe ratios. Good trading software will do this for you. It will either be available in the system by default or you can add a plug-in.

VAR

VAR is another useful measure to help with drawdowns. It stands for Value at Risk. Normally people will use 99% VAR (conservative) or 95% VAR (aggressive). Let’s say you’re long EURUSD and using 95% VAR. The system will look at the historic movement of EURUSD. It might spit out a number of -1.2%.

A 5% VAR of -1.2% tells you you should expect to lose 1.2% on 5% of days, whilst 95% of days should be better than that
This means it is expected that on 5 days out of 100 (hence the 95%) the portfolio will lose 1.2% or more. This can help you manage your capital by taking appropriately sized positions. Typically you would look at VAR across your portfolio of trades rather than trade by trade.
Sharpe ratios and VAR don’t give you the whole picture, though. Legendary fund manager, Howard Marks of Oaktree, notes that, while tools like VAR and Sharpe ratios are helpful and absolutely necessary, the best investors will also overlay their own judgment.
Investors can calculate risk metrics like VaR and Sharpe ratios (we use them at Oaktree; they’re the best tools we have), but they shouldn’t put too much faith in them. The bottom line for me is that risk management should be the responsibility of every participant in the investment process, applying experience, judgment and knowledge of the underlying investments.Howard Marks of Oaktree Capital
What he’s saying is don’t misplace your common sense. Do use these tools as they are helpful. However, you cannot fully rely on them. Both assume a normal distribution of returns. Whereas in real life you get “black swans” - events that should supposedly happen only once every thousand years but which actually seem to happen fairly often.
These outlier events are often referred to as “tail risk”. Don’t make the mistake of saying “well, the model said…” - overlay what the model is telling you with your own common sense and good judgment.

Coming up in part III

Available here
Squeezes and other risks
Market positioning
Bet correlation
Crap trades, timeouts and monthly limits

***
Disclaimer:This content is not investment advice and you should not place any reliance on it. The views expressed are the author's own and should not be attributed to any other person, including their employer.
submitted by getmrmarket to Forex [link] [comments]

Former investment bank FX trader: News trading and second order thinking part 2/2

Former investment bank FX trader: News trading and second order thinking part 2/2
Thanks for all the upvotes and comments on the previous pieces:
From the first half of the news trading note we learned some ways to estimate what is priced in by the market. We learned that we are trading any gap in market expectations rather than the result itself. A good result when the market expected a fantastic result is disappointing! We also looked at second order thinking. After all that, I hope the reaction of prices to events is starting to make more sense to you.

Before you understand the core concepts of pricing in and second order thinking, price reactions to events can seem mystifying at times
We'll add one thought-provoking quote. Keynes (that rare economist who also managed institutional money) offered this analogy. He compared selecting investments to a beauty contest in which newspaper readers would write in with their votes and win a prize if their votes most closely matched the six most popularly selected women across all readers:
It is not a case of choosing those (faces) which, to the best of one’s judgment, are really the prettiest, nor even those which average opinions genuinely thinks the prettiest. We have reached the third degree where we devote our intelligences to anticipating what average opinion expects the average opinion to be.
Trading is no different. You are trying to anticipate how other traders will react to news and how that will move prices. Perhaps you disagree with their reaction. Still, if you can anticipate what it will be you would be sensible to act upon it. Don't forget: meanwhile they are also trying to anticipate what you and everyone else will do.

Part II
  • Preparing for quantitative and qualitative releases
  • Data surprise index
  • Using recent events to predict future reactions
  • Buy the rumour, sell the fact
  • The trimming position effect
  • Reversals
  • Some key FX releases

Preparing for quantitative and qualitative releases

The majority of releases are quantitative. All that means is there’s some number. Like unemployment figures or GDP.
Historic results provide interesting context. We are looking below the Australian unemployment rate which is released monthly. If you plot it out a few years back you can spot a clear trend, which got massively reversed. Knowing this trend gives you additional information when the figure is released. In the same way prices can trend so do economic data.

A great resource that's totally free to use
This makes sense: if for example things are getting steadily better in the economy you’d expect to see unemployment steadily going down.
Knowing the trend and how much noise there is in the data gives you an informational edge over lazy traders.
For example, when we see the spike above 6% on the above you’d instantly know it was crazy and a huge trading opportunity since a) the fluctuations month on month are normally tiny and b) it is a huge reversal of the long-term trend.
Would all the other AUDUSD traders know and react proportionately? If not and yet they still trade, their laziness may be an opportunity for more informed traders to make some money.
Tradingeconomics.com offers really high quality analysis. You can see all the major indicators for each country. Clicking them brings up their history as well as an explanation of what they show.
For example, here’s German Consumer Confidence.

Helpful context
There are also qualitative events. Normally these are speeches by Central Bankers.
There are whole blogs dedicated to closely reading such texts and looking for subtle changes in direction or opinion on the economy. Stuff like how often does the phrase "in a good place" come up when the Chair of the Fed speaks. It is pretty dry stuff. Yet these are leading indicators of how each member may vote to set interest rates. Ed Yardeni is the go-to guy on central banks.

Data surprise index

The other thing you might look at is something investment banks produce for their customers. A data surprise index. I am not sure if these are available in retail land - there's no reason they shouldn't be but the economic calendars online are very basic.
You’ll remember we talked about data not being good or bad of itself but good or bad relative to what was expected. These indices measure this difference.
If results are consistently better than analysts expect then you’ll see a positive number. If they are consistently worse than analysts expect a negative number. You can see they tend to swing from positive to negative.

Mean reversion at its best! Data surprise indices measure how much better or worse data came in vs forecast
There are many theories for this but in general people consider that analysts herd around the consensus. They are scared to be outliers and look ‘wrong’ or ‘stupid’ so they instead place estimates close to the pack of their peers.
When economic conditions change they may therefore be slow to update. When they are wrong consistently - say too bearish - they eventually flip the other way and become too bullish.
These charts can be interesting to give you an idea of how the recent data releases have been versus market expectations. You may try to spot the turning points in macroeconomic data that drive long term currency prices and trends.

Using recent events to predict future reactions

The market reaction function is the most important thing on an economic calendar in many ways. It means: what will happen to the price if the data is better or worse than the market expects?
That seems easy to answer but it is not.
Consider the example of consumer confidence we had earlier.
  • Many times the market will shrug and ignore it.
  • But when the economic recovery is predicated on a strong consumer it may move markets a lot.
Or consider the S&P index of US stocks (Wall Street).
  • If you get good economic data that beats analyst estimates surely it should go up? Well, sometimes that is certainly the case.
  • But good economic data might result in the US Central Bank raising interest rates. Raising interest rates will generally make the stock market go down!
So better than expected data could make the S&P go up (“the economy is great”) or down (“the Fed is more likely to raise rates”). It depends. The market can interpret the same data totally differently at different times.
One clue is to look at what happened to the price of risk assets at the last event.
For example, let’s say we looked at unemployment and it came in a lot worse than forecast last month. What happened to the S&P back then?

2% drop last time on a 'worse than expected' number ... so it it is 'better than expected' best guess is we rally 2% higher
So this tells us that - at least for our most recent event - the S&P moved 2% lower on a far worse than expected number. This gives us some guidance as to what it might do next time and the direction. Bad number = lower S&P. For a huge surprise 2% is the size of move we’d expect.
Again - this is a real limitation of online calendars. They should show next to the historic results (expected/actual) the reaction of various instruments.

Buy the rumour, sell the fact

A final example of an unpredictable reaction relates to the old rule of ‘Buy the rumour, sell the fact.’ This captures the tendency for markets to anticipate events and then reverse when they occur.

Buy the rumour, sell the fact
In short: people take profit and close their positions when what they expected to happen is confirmed.
So we have to decide which driver is most important to the market at any point in time. You obviously cannot ask every participant. The best way to do it is to look at what happened recently. Look at the price action during recent releases and you will get a feel for how much the market moves and in which direction.

Trimming or taking off positions

One thing to note is that events sometimes give smart participants information about positioning. This is because many traders take off or reduce positions ahead of big news events for risk management purposes.
Imagine we see GBPUSD rises in the hour before GDP release. That probably indicates the market is short and has taken off / flattened its positions.

The price action before an event can tell you about speculative positioning
If GDP is merely in line with expectations those same people are likely to add back their positions. They avoided a potential banana skin. This is why sometimes the market moves on an event that seemingly was bang on consensus.
But you have learned something. The speculative market is short and may prove vulnerable to a squeeze.

Two kinds of reversals

Fairly often you’ll see the market move in one direction on a release then turn around and go the other way.
These are known as reversals. Traders will often ‘fade’ a move, meaning bet against it and expect it to reverse.

Logical reversals

Sometimes this happens when the data looks good at first glance but the details don’t support it.
For example, say the headline is very bullish on German manufacturing numbers but then a minute later it becomes clear the company who releases the data has changed methodology or believes the number is driven by a one-off event. Or maybe the headline number is positive but buried in the detail there is a very negative revision to previous numbers.
Fading the initial spike is one way to trade news. Try looking at what the price action is one minute after the event and thirty minutes afterwards on historic releases.

Crazy reversals


Some reversals don't make sense
Sometimes a reversal happens for seemingly no fundamental reason. Say you get clearly positive news that is better than anyone expects. There are no caveats to the positive number. Yet the price briefly spikes up and then falls hard. What on earth?
This is a pure supply and demand thing. Even on bullish news the market cannot sustain a rally. The market is telling you it wants to sell this asset. Try not to get in its way.

Some key releases

As we have already discussed, different releases are important at different times. However, we’ll look at some consistently important ones in this final section.

Interest rates decisions

These can sometimes be unscheduled. However, normally the decisions are announced monthly. The exact process varies for each central bank. Typically there’s a headline decision e.g. maintain 0.75% rate.
You may also see “minutes” of the meeting in which the decision was reached and a vote tally e.g. 7 for maintain, 2 for lower rates. These are always top-tier data releases and have capacity to move the currency a lot.
A hawkish central bank (higher rates) will tend to move a currency higher whilst a dovish central bank (lower rates) will tend to move a currency lower.
A central banker speaking is always a big event

Non farm payrolls

These are released once per month. This is another top-tier release that will move all USD pairs as well as equities.
There are three numbers:
  • The headline number of jobs created (bigger is better)
  • The unemployment rate (smaller is better)
  • Average hourly earnings (depends)
Bear in mind these headline numbers are often off by around 75,000. If a report comes in +/- 25,000 of the forecast, that is probably a non event.
In general a positive response should move the USD higher but check recent price action.
Other countries each have their own unemployment data releases but this is the single most important release.

Surveys

There are various types of surveys: consumer confidence; house price expectations; purchasing managers index etc.
Each one basically asks a group of people if they expect to make more purchases or activity in their area of expertise to rise. There are so many we won’t go into each one here.
A really useful tool is the tradingeconomics.com economic indicators for each country. You can see all the major indicators and an explanation of each plus the historic results.

GDP

Gross Domestic Product is another big release. It is a measure of how much a country’s economy is growing.
In general the market focuses more on ‘advance’ GDP forecasts more than ‘final’ numbers, which are often released at the same time.
This is because the final figures are accurate but by the time they come around the market has already seen all the inputs. The advance figure tends to be less accurate but incorporates new information that the market may not have known before the release.
In general a strong GDP number is good for the domestic currency.

Inflation

Countries tend to release measures of inflation (increase in prices) each month. These releases are important mainly because they may influence the future decisions of the central bank, when setting the interest rate.
See the FX fundamentals section for more details.

Industrial data

Things like factory orders or or inventory levels. These can provide a leading indicator of the strength of the economy.
These numbers can be extremely volatile. This is because a one-off large order can drive the numbers well outside usual levels.
Pay careful attention to previous releases so you have a sense of how noisy each release is and what kind of moves might be expected.

Comments

Often there is really good stuff in the comments/replies. Check out 'squitstoomuch' for some excellent observations on why some news sources are noisy but early (think: Twitter, ZeroHedge). The Softbank story is a good recent example: was in ZeroHedge a day before the FT but the market moved on the FT. Also an interesting comment on mistakes, which definitely happen on breaking news, and can cause massive reversals.

submitted by getmrmarket to Forex [link] [comments]

Trading economic news

The majority of this sub is focused on technical analysis. I regularly ridicule such "tea leaf readers" and advocate for trading based on fundamentals and economic news instead, so I figured I should take the time to write up something on how exactly you can trade economic news releases.
This post is long as balls so I won't be upset if you get bored and go back to your drooping dick patterns or whatever.

How economic news is released

First, it helps to know how economic news is compiled and released. Let's take Initial Jobless Claims, the number of initial claims for unemployment benefits around the United States from Sunday through Saturday. Initial in this context means the first claim for benefits made by an individual during a particular stretch of unemployment. The Initial Jobless Claims figure appears in the Department of Labor's Unemployment Insurance Weekly Claims Report, which compiles information from all of the per-state departments that report to the DOL during the week. A typical number is between 100k and 250k and it can vary quite significantly week-to-week.
The Unemployment Insurance Weekly Claims Report contains data that lags 5 days behind. For example, the Report issued on Thursday March 26th 2020 contained data about the week ending on Saturday March 21st 2020.
In the days leading up to the Report, financial companies will survey economists and run complicated mathematical models to forecast the upcoming Initial Jobless Claims figure. The results of surveyed experts is called the "consensus"; specific companies, experts, and websites will also provide their own forecasts. Different companies will release different consensuses. Usually they are pretty close (within 2-3k), but for last week's record-high Initial Jobless Claims the reported consensuses varied by up to 1M! In other words, there was essentially no consensus.
The Unemployment Insurance Weekly Claims Report is released each Thursday morning at exactly 8:30 AM ET. (On Thanksgiving the Report is released on Wednesday instead.) Media representatives gather at the Frances Perkins Building in Washington DC and are admitted to the "lockup" at 8:00 AM ET. In order to be admitted to the lockup you have to be a credentialed member of a media organization that has signed the DOL lockup agreement. The lockup room is small so there is a limited number of spots.
No phones are allowed. Reporters bring their laptops and connect to a local network; there is a master switch on the wall that prevents/enables Internet connectivity on this network. Once the doors are closed the Unemployment Insurance Weekly Claims Report is distributed, with a heading that announces it is "embargoed" (not to be released) prior to 8:30 AM. Reporters type up their analyses of the report, including extracting key figures like Initial Jobless Claims. They load their write-ups into their companies' software, which prepares to send it out as soon as Internet is enabled. At 8:30 AM the DOL representative in the room flips the wall switch and all of the laptops are connected to the Internet, releasing their write-ups to their companies and on to their companies' partners.
Many of those media companies have externally accessible APIs for distributing news. Media aggregators and squawk services (like RanSquawk and TradeTheNews) subscribe to all of these different APIs and then redistribute the key economic figures from the Report to their own subscribers within one second after Internet is enabled in the DOL lockup.
Some squawk services are text-based while others are audio-based. FinancialJuice.com provides a free audio squawk service; internally they have a paid subscription to a professional squawk service and they simply read out the latest headlines to their own listeners, subsidized by ads on the site. I've been using it for 4 months now and have been pretty happy. It usually lags behind the official release times by 1-2 seconds and occasionally they verbally flub the numbers or stutter and have to repeat, but you can't beat the price!
Important - I’m not affiliated with FinancialJuice and I’m not advocating that you use them over any other squawk. If you use them and they misspeak a number and you lose all your money don’t blame me. If anybody has any other free alternatives please share them!

How the news affects forex markets

Institutional forex traders subscribe to these squawk services and use custom software to consume the emerging data programmatically and then automatically initiate trades based on the perceived change to the fundamentals that the figures represent.
It's important to note that every institution will have "priced in" their own forecasted figures well in advance of an actual news release. Forecasts and consensuses all come out at different times in the days leading up to a news release, so by the time the news drops everybody is really only looking for an unexpected result. You can't really know what any given institution expects the value to be, but unless someone has inside information you can pretty much assume that the market has collectively priced in the experts' consensus. When the news comes out, institutions will trade based on the difference between the actual and their forecast.
Sometimes the news reflects a real change to the fundamentals with an economic effect that will change the demand for a currency, like an interest rate decision. However, in the case of the Initial Jobless Claims figure, which is a backwards-looking metric, trading is really just self-fulfilling speculation that market participants will buy dollars when unemployment is low and sell dollars when unemployment is high. Generally speaking, news that reflects a real economic shift has a bigger effect than news that only matters to speculators.
Massive and extremely fast news-based trades happen within tenths of a second on the ECNs on which institutional traders are participants. Over the next few seconds the resulting price changes trickle down to retail traders. Some economic news, like Non Farm Payroll Employment, has an effect that can last minutes to hours as "slow money" follows behind on the trend created by the "fast money". Other news, like Initial Jobless Claims, has a short impact that trails off within a couple minutes and is subsequently dwarfed by the usual pseudorandom movements in the market.
The bigger the difference between actual and consensus, the bigger the effect on any given currency pair. Since economic news releases generally relate to a single currency, the biggest and most easily predicted effects are seen on pairs where one currency is directly effected and the other is not affected at all. Personally I trade USD/JPY because the time difference between the US and Japan ensures that no news will be coming out of Japan at the same time that economic news is being released in the US.
Before deciding to trade any particular news release you should measure the historical correlation between the release (specifically, the difference between actual and consensus) and the resulting short-term change in the currency pair. Historical data for various news releases (along with historical consensus data) is readily available. You can pay to get it exported into Excel or whatever, or you can scroll through it for free on websites like TradingEconomics.com.
Let's look at two examples: Initial Jobless Claims and Non Farm Payroll Employment (NFP). I collected historical consensuses and actuals for these releases from January 2018 through the present, measured the "surprise" difference for each, and then correlated that to short-term changes in USD/JPY at the time of release using 5 second candles.
I omitted any releases that occurred simultaneously as another major release. For example, occasionally the monthly Initial Jobless Claims comes out at the exact same time as the monthly Balance of Trade figure, which is a more significant economic indicator and can be expected to dwarf the effect of the Unemployment Insurance Weekly Claims Report.
USD/JPY correlation with Initial Jobless Claims (2018 - present)
USD/JPY correlation with Non Farm Payrolls (2018 - present)
The horizontal axes on these charts is the duration (in seconds) after the news release over which correlation was calculated. The vertical axis is the Pearson correlation coefficient: +1 means that the change in USD/JPY over that duration was perfectly linearly correlated to the "surprise" in the releases; -1 means that the change in USD/JPY was perfectly linearly correlated but in the opposite direction, and 0 means that there is no correlation at all.
For Initial Jobless Claims you can see that for the first 30 seconds USD/JPY is strongly negatively correlated with the difference between consensus and actual jobless claims. That is, fewer-than-forecast jobless claims (fewer newly unemployed people than expected) strengthens the dollar and greater-than-forecast jobless claims (more newly unemployed people than expected) weakens the dollar. Correlation then trails off and changes to a moderate/weak positive correlation. I interpret this as algorithms "buying the dip" and vice versa, but I don't know for sure. From this chart it appears that you could profit by opening a trade for 15 seconds (duration with strongest correlation) that is long USD/JPY when Initial Jobless Claims is lower than the consensus and short USD/JPY when Initial Jobless Claims is higher than expected.
The chart for Non Farm Payroll looks very different. Correlation is positive (higher-than-expected payrolls strengthen the dollar and lower-than-expected payrolls weaken the dollar) and peaks at around 45 seconds, then slowly decreases as time goes on. This implies that price changes due to NFP are quite significant relative to background noise and "stick" even as normal fluctuations pick back up.
I wanted to show an example of what the USD/JPY S5 chart looks like when an "uncontested" (no other major simultaneously news release) Initial Jobless Claims and NFP drops, but unfortunately my broker's charts only go back a week. (I can pull historical data going back years through the API but to make it into a pretty chart would be a bit of work.) If anybody can get a 5-second chart of USD/JPY at March 19, 2020, UTC 12:30 and/or at February 7, 2020, UTC 13:30 let me know and I'll add it here.

Backtesting

So without too much effort we determined that (1) USD/JPY is strongly negatively correlated with the Initial Jobless Claims figure for the first 15 seconds after the release of the Unemployment Insurance Weekly Claims Report (when no other major news is being released) and also that (2) USD/JPY is strongly positively correlated with the Non Farms Payroll figure for the first 45 seconds after the release of the Employment Situation report.
Before you can assume you can profit off the news you have to backtest and consider three important parameters.
Entry speed: How quickly can you realistically enter the trade? The correlation performed above was measured from the exact moment the news was released, but realistically if you've got your finger on the trigger and your ear to the squawk it will take a few seconds to hit "Buy" or "Sell" and confirm. If 90% of the price move happens in the first second you're SOL. For back-testing purposes I assume a 5 second delay. In practice I use custom software that opens a trade with one click, and I can reliably enter a trade within 2-3 seconds after the news drops, using the FinancialJuice free squawk.
Minimum surprise: Should you trade every release or can you do better by only trading those with a big enough "surprise" factor? Backtesting will tell you whether being more selective is better long-term or not.
Hold time: The optimal time to hold the trade is not necessarily the same as the time of maximum correlation. That's a good starting point but it's not necessarily the best number. Backtesting each possible hold time will let you find the best one.
The spread: When you're only holding a position open for 30 seconds, the spread will kill you. The correlations performed above used the midpoint price, but in reality you have to buy at the ask and sell at the bid. Brokers aren't stupid and the moment volume on the ECN jumps they will widen the spread for their retail customers. The only way to determine if the news-driven price movements reliably overcome the spread is to backtest.
Stops: Personally I don't use stops, neither take-profit nor stop-loss, since I'm automatically closing the trade after a fixed (and very short) amount of time. Additionally, brokers have a minimum stop distance; the profits from scalping the news are so slim that even the nearest stops they allow will generally not get triggered.
I backtested trading these two news releases (since 2018), using a 5 second entry delay, real historical spreads, and no stops, cycling through different "surprise" thresholds and hold times to find the combination that returns the highest net profit. It's important to maximize net profit, not expected value per trade, so you don't over-optimize and reduce the total number of trades taken to one single profitable trade. If you want to get fancy you can set up a custom metric that combines number of trades, expected value, and drawdown into a single score to be maximized.
For the Initial Jobless Claims figure I found that the best combination is to hold trades open for 25 seconds (that is, open at 5 seconds elapsed and hold until 30 seconds elapsed) and only trade when the difference between consensus and actual is 7k or higher. That leads to 30 trades taken since 2018 and an expected return of... drumroll please... -0.0093 yen per unit per trade.
Yep, that's a loss of approx. $8.63 per lot.
Disappointing right? That's the spread and that's why you have to backtest. Even though the release of the Unemployment Insurance Weekly Claims Report has a strong correlation with movement in USD/JPY, it's simply not something that a retail trader can profit from.
Let's turn to the NFP. There I found that the best combination is to hold trades open for 75 seconds (that is, open at 5 seconds elapsed and hold until 80 seconds elapsed) and trade every single NFP (no minimum "surprise" threshold). That leads to 20 trades taken since 2018 and an expected return of... drumroll please... +0.1306 yen per unit per trade.
That's a profit of approx. $121.25 per lot. Not bad for 75 seconds of work! That's a +6% ROI at 50x leverage.

Make it real

If you want to do this for realsies, you need to run these numbers for all of the major economic news releases. Markit Manufacturing PMI, Factory Orders MoM, Trade Balance, PPI MoM, Export and Import Prices, Michigan Consumer Sentiment, Retail Sales MoM, Industrial Production MoM, you get the idea. You keep a list of all of the releases you want to trade, when they are released, and the ideal hold time and "surprise" threshold. A few minutes before the prescribed release time you open up your broker's software, turn on your squawk, maybe jot a few notes about consensuses and model forecasts, and get your finger on the button. At the moment you hear the release you open the trade in the correct direction, hold it (without looking at the chart!) for the required amount of time, then close it and go on with your day.
Some benefits of trading this way: * Most major economic releases come out at either 8:30 AM ET or 10:00 AM ET, and then you're done for the day. * It's easily backtestable. You can look back at the numbers and see exactly what to expect your return to be. * It's fun! Packing your trading into 30 seconds and knowing that institutions are moving billions of dollars around as fast as they can based on the exact same news you just read is thrilling. * You can wow your friends by saying things like "The St. Louis Fed had some interesting remarks on consumer spending in the latest Beige Book." * No crayons involved.
Some downsides: * It's tricky to be fast enough without writing custom software. Some broker software is very slow and requires multiple dialog boxes before a position is opened, which won't cut it. * The profits are very slim, you're not going to impress your instagram followers to join your expensive trade copying service with your 30-second twice-weekly trades. * Any friends you might wow with your boring-ass economic talking points are themselves the most boring people in the world.
I hope you enjoyed this long as fuck post and you give trading economic news a try!
submitted by thicc_dads_club to Forex [link] [comments]

Thoughts On The Market Series #1 - The New Normal?

Market Outlook: What to Make of This “New Normal”

By ****\*
March 16, 2020
After an incredibly volatile week – which finished with the Dow Jones Industrial Average rallying over 9% on Friday – I suppose my readers might expect me to be quite upbeat about the markets.
Unfortunately, I persist in my overall pessimistic outlook for stocks, and for the economy in general. Friday’s rally essentially negated Thursday’s sell-off, but I don’t expect it to be the start of a sustained turnaround.
We’re getting a taste of that this morning, with the Dow opening down around 7%.
This selloff is coming on the back of an emergency interest rate cut by the Federal Reserve of 100 basis points (to 0%-0.25%) on Sunday… along with the announcement of a new quantitative easing program of $700 billion. (I will write about this further over the next several days.)
As I have been writing for many weeks, the financial bubble – which the Fed created by pumping trillions of dollars into the financial system – has popped. It will take some time for the bubble to deflate to sustainable levels.
Today I’ll walk you through what’s going on in the markets and the economy… what I expect going forward and why… and what it means for us as traders. (You’ll see it’s not all bad news.)

Coronavirus’ Strain on the Global Economy

To start, let’s put things in perspective: This asset deflation was coming one way or another. Covid19 (or coronavirus) has simply accelerated the process.
Major retailers are closing, tourism is getting crushed, universities and schools are sending students home, conventions, sporting events, concerts, and other public gatherings have been cancelled, banks and other financial service firms are going largely virtual, and there has been a massive loss of wealth.
Restaurant data suggests that consumer demand is dropping sharply, and the global travel bans will only worsen the situation.
Commercial real estate is another sector that looks particularly vulnerable. We are almost certain to see a very sharp and pronounced economic slowdown here in the United States, and elsewhere. In fact, I expect a drop of at least 5% of GDP over the next two quarters, which is quite severe by any standard.
Sure, when this cycle is complete, there will be tremendous amounts of pent-up demand by consumers, but for the time being, the consumer is largely on the sidelines.
Of course, the problems aren’t just in the U.S. China’s numbers look awful. In fact, the government there may have to “massage” their numbers a bit to show a positive GDP in the first quarter. Europe’s numbers will also look dreadful, and South Korea’s economy has been hit badly.
All around the world, borders are being shut, all non-essential businesses are being closed, and people in multiple countries are facing a lockdown of historic proportions. The coronavirus is certainly having a powerful impact, and it looks certain that its impact will persist for a while.
Consider global tourism. It added almost $9 trillion to the global economy in 2018, and roughly 320 million jobs. This market is in serious trouble.
Fracking in the U.S. is another business sector that is in a desperate situation. Millions of jobs and tens of billions of loans are now in jeopardy.
The derivative businesses that this sector supports will be likewise devastated as companies are forced to reduce their workforces or shut down due to the collapse in oil prices. This sector’s suffering will probably force banks to book some big losses despite attempts by the government to support this industry.
In a similar way, the derivative businesses that are supported by the universities and colleges across America are going to really suffer.
There are nearly 20 million students in colleges across the U.S. When they go home for spring vacation and do not return, the effect on the local businesses that colleges and university populations support will be devastating.
What does this “new normal” mean going forward? Let’s take a look…

New Normal

The new normal may become increasingly unpleasant for us. We need to be ready to hunker down for quite some time.
Beyond that, the government needs to handle this crisis far better in the future.
The level of stupidity associated with the massive throngs of people trapped in major airports yesterday, for example, was almost unimaginable.
Instead of facilitating the reduction of social contact and halting the further spread of the coronavirus, the management of the crowds at the airports produced a perfect breeding ground for the spread of the virus.
My guess is that more draconian travel restrictions will be implemented soon, matching to some extent the measures taken across Europe.
This will in turn have a further dampening effect on economic activity in the U.S., putting more and more pressure on the Fed and the government to artificially support a rapidly weakening economy.
Where does this end up? It is too early to say, but a very safe bet is that we will have some months of sharply negative growth. Too many sectors of the economy are going to take a hit to expect anything else.
The Fed has already driven interest rates to zero. Will that help? Unlikely. In fact, as I mentioned at the beginning of this update, the markets are voting with a resounding NO.
The businesses that are most affected by the current economic situation will still suffer. Quantitative easing is hardly a cure-all. In fact, it has been one of the reasons that we have such a mess in our markets today.
The markets have become addicted to the easy money, so more of the same will have little or no impact. We will need real economic demand, not an easier monetary policy.
It won’t help support tourism, for example, or the other sectors getting smashed right now. The government will need to spend at least 5% of GDP, or roughly $1 trillion, to offset the weakness I see coming.
Is it surprising that the Fed and the government take emergency steps to try to stabilize economic growth? Not at all. This is essentially what they have been doing for a long time, so it is completely consistent with their playbook.
Next, I would anticipate the government implementing some massive public-works and infrastructure programs over the coming months. That would be very helpful, and almost certainly quite necessary.
But there’s a problem with this kind of intervention from the government…

What Happens When You Eliminate the Business Cycle

The Fed’s foolish attempt to eliminate business cycles is a significant contributing factor to the volatility we are currently experiencing.
Quantitative easing is nothing more than printing lots and lots of money to support a weak economy and give the appearance of growth and prosperity. In fact, it is a devaluation of the currency’s true buying power.
That in turn artificially drives up the prices of other assets, such as stocks, real estate and gold – but it does not create true wealth. That only comes with non-inflationary growth of goods and services and associated increases in economic output.
Inflation is the government’s way to keep people thinking they are doing better.
To that point: We have seen some traditional safe-haven assets getting destroyed during this time of risk aversion. That has certainly compounded the problems of many investors.
Gold is a great example. As the stock market got violently slammed, people were forced to come up with cash to support their losing positions. Gold became a short-term source of liquidity as people sold their gold holdings in somewhat dramatic fashion. It was one of the few holdings of many people that was not dramatically under water, so people sold it.
The move may have seemed perverse, particularly to people who bought gold as a safe-haven asset, but in times of crisis, all assets tend to become highly correlated, at least short term.
We saw a similar thing happen with long yen exposures and long Bitcoin exposures recently.
The dollar had its strongest one-day rally against the yen since November 2016 as people were forced to sell huge amounts of yen to generate liquidity. Many speculators had made some nice profits recently as the dollar dropped sharply from 112 to 101.30, but they have been forced to book whatever profits they had in this position. Again, this was due to massive losses elsewhere in their portfolios.
Is the yen’s sell-off complete? If it is not complete, it is probably at least close to an attractive level for Japanese investors to start buying yen against a basket of currencies. The major supplies of yen have largely been taken off the table for now.
For example, the yen had been a popular funding currency for “carry” plays. People were selling yen and buying higher-yielding currencies to earn the interest rate difference between the liability currency (yen) and the funding currency (for example, the U.S. dollar).
Carry plays are very unpopular in times of great uncertainty and volatility, however, so that supply of yen will be largely gone for quite some time. Plus, the yield advantage of currencies such as the U.S. dollar, Canadian dollar, and Australian dollar versus the yen is nearly gone.
In addition, at the end of the Japanese fiscal year , there is usually heavy demand for yen as Japanese corporations need to bring home a portion of their overseas holdings for balance sheet window dressing. I don’t expect that pressure to be different this year.
Just as the safe-haven assets of yen and gold got aggressively sold, Bitcoin also got hammered. It was driven by a similar theme – people had big losses and they needed to produce liquidity quickly. Selling Bitcoin became one of the sources of that liquidity.

Heavy Price Deflation Ahead

Overall, there is a chance that this scenario turns into something truly ugly, with sustained price deflation across many parts of the economy. We will certainly have price deflation in many sectors, at least on a temporary basis.
Why does that matter over the long term?
Price deflation is the most debilitating economic development in a society that is debt-laden – like the U.S. today. Prices of assets come down… and the debt becomes progressively bigger and bigger.
The balance sheet of oil company Chesapeake Energy is a classic example. It’s carrying almost $10 billion worth of debt… versus a market cap of only about $600 million. Talk about leverage! When the company had a market cap of $10 billion, that debt level didn’t appear so terrifying.
Although this is an extreme example for illustrative purposes, the massive debt loads of China would seem more and more frightening if we were to sink into flat or negative growth cycles for a while. The government’s resources are already being strained, and it can artificially support only so many failing companies.
The U.S. has gigantic levels of debt as well, but it has the advantage of being the world’s true hegemon, and the U.S. dollar is the world’s reserve currency. This creates a tremendous amount of leverage and power in financing its debt.
The U.S. has been able to impose its will on its trading partners to trade major commodities in dollars. This has created a constant demand for the dollar that offsets, to a large extent, the massive trade deficit that the U.S. runs.
For example, if a German company wants to buy oil, then it needs to hold dollars. This creates a constant demand for dollar assets.
In short, the dollar’s status as the true global reserve currency is far more important than most people realize. China does not hold this advantage.

What to Do Now

In terms of how to position ourselves going forward, I strongly recommend that people continue with a defensive attitude regarding stocks. There could be a lot more downside to come. Likewise, we could see some panic selling in other asset classes.
The best thing right now is to be liquid and patient, ready to pounce on special opportunities when they present themselves.
For sure, there will be some exceptional opportunities, but it is too early to commit ourselves to just one industry. These opportunities could come in diverse sectors such as commercial real estate, hospitality, travel and leisure, and others.
As for the forex markets, the volatility in the currencies is extreme, so we are a bit cautious.
I still like the yen as a safe-haven asset. I likewise still want to sell the Australian dollar, the New Zealand dollar, and the Canadian dollar as liability currencies.
Why? The Bank of Canada, the Reserve Bank of Australia, and the Reserve Bank of New Zealand have all taken aggressive steps recently, slashing interest rates. These currencies are all weak, and they will get weaker.
Finding an ideal entry for a trade, however, is tricky. Therefore, we are being extra careful with our trading. We always prioritize the preservation of capital over generating profits, and we will continue with this premise.
At the same time, volatility in the markets is fantastic for traders. We expect many excellent opportunities to present themselves over the coming days and weeks as prices get driven to extreme levels and mispricings appear. So stay tuned.
submitted by ParallaxFX to Forex [link] [comments]

PSA: I forked a Tampermonkey script to extract your order/product data from AliExpress into a csv list.

Aloha!
Export aliexpress orders to clipboard as csv is a Tampermonkey skript that will:
Like all those scripts this one is still depending on scraping the web page. You have to advance through the order pages manually, grabbing every page and pasting it to editoExcel/Sheets....
It grabs the historic exchange rates from api.exchangeratesapi.io. If you're not a EURo guy/gal, you can just ignore the columns, as the script keeps the original amounts, e.g. in USD.
This is basically a fork of two existing scripts that didn't fulfill my needs (credited in the Readme). I even retained their names.

Hope this can be helpful to you. Let me know what you think and have fun using it!
submitted by ohuf to Aliexpress [link] [comments]

Wall Street Week Ahead for the trading week beginning September 23rd, 2019

Good Saturday morning to all of you here on wallstreetbets. I hope everyone on this sub made out pretty nicely in the market this past week, and is ready for the new trading week ahead.
Here is everything you need to know to get you ready for the trading week beginning September 23rd, 2019.

Week ahead: As stocks struggle to break to new highs, markets could be swayed by Fed speakers, trade - (Source)

Developments in U.S.-Chinese trade talks and the comments from a host of Fed speakers could be important for markets in the week ahead, as stocks struggle to regain highs.
The Fed in the past week cut interest rates for the second time in two months, but the latest forecasts of Fed officials showed just how divided they are on the need for future rate cuts. Five wanted deeper cuts, five didn’t want any cuts and another seven were happy with the Fed’s action.
“The market seems like it’s pretty jumpy based on what the say. i think it would flip back and forth depending on how the headlines come out,” said Tom Simons, money market economist at Jefferies. Simons said the focus will also be on the Fed’s operations in the short-term funding market, after turbulence in the overnight market in the past week temporarily sent some overnight rates sharply higher.
There are nearly a dozen Fed speakers on the calendar in the coming week, but Fed Chairman Jerome Powell is not scheduled to speak.
Trade developments could continue to cause volatility in markets. Reports Friday that Chinese agriculture officials canceled visits to farms in Montana and Nebraska sent stocks lower, for fear it signaled that talks were not making progress.
Stocks in the past week were lower, with the S&P off about 0.5% to 2,992. The index had been around 1% away from its all-time high for a few weeks.
“Tech that has been out of play and is acting faulty. it’s now turning into a headwind, and that could cause a problem for the bulls,” said Scott Redler, partner with T3Live.com. “I haven’t seen so many mixed signals in the market in quite some time.”
“It’s hard for the market to make new highs without tech. At best, it’s concerning when you see key names, like Amazon and Netflix, not just failing to lead but faltering,” he said. Netflix was down more than 8% for the week, and Amazon was off 2.6%.
Redler said it was a concern that shares of market leader Microsoft gave up its initial gains and turned negative, soon after it announced a buyback and raised its dividend. “Strength was sold instead of embraced,” he said. “That was good news. What are they going to do when bad news happens?”
Following the attacks on Saudi Aramco last week, the United Nations General Assembly in New York and meetings around it take on more importance for markets. U.S. and Saudi Arabian officials have said Iran was behind the attack, which knocked a significant amount of Saudi oil production off line. Iran has denied involvement, and Houthi rebels in Yemen have claimed responsibility.
Iran’ President Hassan Rouhani has been given a visa to travel to New York for the UN. Before the attack on Saudi Arabia last week, President Donald Trump had suggested he would speak to Rouhani but there seems little chance of that now. Oil have been highly volatile, with Brent crude futures up 7% since the attack as Saudi Arabia sought to assure markets that it would be able to bring its operations back on line.
There is some economic data that will also be important to markets. There is manufacturing PMI Monday, important after ISM manufacturing data showed a contraction in August. Durable goods will also be important on Friday, as will personal consumption data, which includes the Fed’s preferred inflation indicator, the core PCE deflator.
“What Powell said in his remarks was inflation was below his target,” said Marc Chandler, chief market strategist at Bannockburn Global Forex. “But even the core PCE deflator is expected to be 1.8, a new high for the year.” The Fed’s target inflation rate is 2%, and other inflation measures have been above that, including core CPI.
The Fed will also be in focus after problems in the overnight funding market, used by banks in need of short term cash. Rates spiked for repo, or repurchase agreements, in a chaotic two-day period Monday and Tuesday. The Fed’s target fed funds rate also moved above its target range, in an unusual move.
The market has since calmed after the Fed carried out open market operations to add liquidity to the market. On Friday, it announced three 14-day operations involving $30 billion as well as continued overnight operations of at least $75 billion each.
“I think the Fed has absolute control over short term rates. It was caught sleeping at the wheel,” said Chandler.
Powell said the Fed would monitor the market and take whatever action is needed. The market is considered the basic plumbing for financial markets, where banks who have a short-term need for cash come to fund themselves. The odd spike in rates was viewed as the result of a cash crunch, not a credit crisis.
Bond market pros have been concerned that the Fed would again see strains in the market at month end, when there’s more activity in the overnight funding market.
“It gets you further past quarter end,” said Jon Hill, rate strategist at BMO. “A 14-day pushes them further into October. I think nerves will have calmed. The fact you’ll see fed funds print clearly in the range will reassert confidence. These operations will serve as a reminder that the Fed can have absolute control the front end if and when it wants to. This is a good thing.”
The funds rate was at 1.90% Thursday, within the target rate range of 1.75% to 2%.
“They’re removing any doubt of their ability to take control of fed funds in the modern framework. They just announced $165 billion over quarter-end , and we may go bigger. They haven’t done a repo injection in 10 years,” said Hill.

This past week saw the following moves in the S&P:

(CLICK HERE FOR THE FULL S&P TREE MAP FOR THE PAST WEEK!)

Major Indices for this past week:

(CLICK HERE FOR THE MAJOR INDICES FOR THE PAST WEEK!)

Major Futures Markets as of Friday's close:

(CLICK HERE FOR THE MAJOR FUTURES INDICES AS OF FRIDAY!)

Economic Calendar for the Week Ahead:

(CLICK HERE FOR THE FULL ECONOMIC CALENDAR FOR THE WEEK AHEAD!)

Sector Performance WTD, MTD, YTD:

(CLICK HERE FOR FRIDAY'S PERFORMANCE!)
(CLICK HERE FOR THE WEEK-TO-DATE PERFORMANCE!)
(CLICK HERE FOR THE MONTH-TO-DATE PERFORMANCE!)
(CLICK HERE FOR THE 3-MONTH PERFORMANCE!)
(CLICK HERE FOR THE YEAR-TO-DATE PERFORMANCE!)
(CLICK HERE FOR THE 52-WEEK PERFORMANCE!)

Percentage Changes for the Major Indices, WTD, MTD, QTD, YTD as of Friday's close:

(CLICK HERE FOR THE CHART!)

S&P Sectors for the Past Week:

(CLICK HERE FOR THE CHART!)

Major Indices Pullback/Correction Levels as of Friday's close:

(CLICK HERE FOR THE CHART!

Major Indices Rally Levels as of Friday's close:

(CLICK HERE FOR THE CHART!)

Most Anticipated Earnings Releases for this week:

(CLICK HERE FOR THE CHART!)

Here are the upcoming IPO's for this week:

(CLICK HERE FOR THE CHART!)

Friday's Stock Analyst Upgrades & Downgrades:

(CLICK HERE FOR THE CHART LINK #1!)
(CLICK HERE FOR THE CHART LINK #2!)
(CLICK HERE FOR THE CHART LINK #3!)

S&P 500 down 23 of 29 during week after September options expiration, average loss 0.95%

The week after September options expiration week, next week, has a dreadful history of declines especially since 1990. The week after September options expiration week has been a nearly constant source of pain with only a few meaningful exceptions over the past 29 years. Substantial and across the board gains have occurred just three times: 1998, 2001, 2010 and 2016 while many more weeks were hit with sizable losses.
Full stats are in the following sea-of-red table. Average losses since 1990 are even worse; DJIA –1.02%, S&P 500 –0.95%, NASDAQ –0.90% and a sizable –1.38% for Russell 2000. End-of-Q3 portfolio restructuring is the most likely explanation for this trend as managers trim summer losers and position for the fourth quarter.
(CLICK HERE FOR THE CHART!)

October Challenging in Pre-Election Years

October often evokes fear on Wall Street as memories are stirred of crashes in 1929, 1987, the 554-point drop on October 27, 1997, back-to-back massacres in 1978 and 1979, Friday the 13th in 1989 and the 733-point drop on October 15, 2008. During the week ending October 10, 2008, Dow lost 1,874.19 points (18.2%), the worst weekly decline in our database going back to 1901, in point and percentage terms. The term “Octoberphobia” has been used to describe the phenomenon of major market drops occurring during the month. Market calamities can become a self-fulfilling prophecy, so stay on the lookout and don’t get whipsawed if it happens.
(CLICK HERE FOR THE CHART!)
Pre-election year Octobers are ranked second from last for DJIA, S&P 500 and NASDAQ while Russell 2000 is dead last with an average loss of 1.9%. Eliminating gruesome 1987 from the calculation provides only a moderate amount of relief. Should a meaningful decline materialize in October it is likely to be an excellent buying opportunity, especially for depressed technology and small-cap shares.

Where’s That September Volatility?

September is historically known as one of the worst for stocks, yet in 2019 the S&P 500 Index is up 2.7% so far amid a sea of scary headlines. Incredibly, the S&P 500 has wavered less than 0.1% from its previous close 6 of the past 10 trading sessions, as it consolidates just beneath all-time highs.
“Over the past two weeks we’ve had the European Central Bank meeting, the Federal Reserve meeting, higher inflation, a historic jump in crude oil, Middle East turmoil, trouble in the repo market, and even multiple NFL quarterbacks sustaining major injuries,” said LPL Financial Senior Market Strategist Ryan Detrick. “Yet, with all of those scary headlines, stocks are actually in the midst of one of the least volatile two-week stretches we’ve seen in years.”
We are quite encouraged by the overall change in market tone we’ve heard recently, with more cyclical names taking the baton and leading, but with the S&P 500 up near our fair value target of 3,000, we would be on the lookout for this sea of tranquility to get rougher at any time. In fact, according to historical calendars, we may need to be on high guard for the second half of September.
As shown in the LPL Chart of the Day, The Second Half of September Can Be Tricky For Stocks, later in the month of September is when we’ve seen seasonal weakness. Things have been going well for equities in the face of some worrisome headlines, but don’t get complacent, as the calendar could be one of the biggest near-term risks.
(CLICK HERE FOR THE CHART!)

The Fed Hits It Down The Middle

“History does not repeat itself, but it rhymes.” Mark Twain
As expected, the Federal Reserve’s (Fed) policy committee cut its policy rate by 25 basis points (.25%) to a target range of 1.75%–2%. This comes on the heels of the first rate cut in more than 10 years at the end of July. This cut is somewhat more controversial, however, because the overall U.S. economic data has been improving, and there’s been a tick higher in inflation.
One of the most important questions heading into this meeting was how many voting Fed members would support additional rate cuts. There were two dissenting voting members at the July rate cut, and once again there were two votes opposed to today’s cut—but unlike last time, there was also one dissenter who favored a larger 50 basis point (.50%) cut. Materials in the economic projections indicated 10 of 17 participants (which includes non-voting members) did not believe additional cuts would be needed over the remainder of the year, although evolving economic conditions could certainly lead to a shift.
As the quote from Mark Twain suggests, by looking back at history we can potentially find clues as to what might happen in the future.
Looking back at the previous two recessions (2001 and 2008), the Fed cut rates 50 basis points (.50%) to kick off the new cycle of rate cuts. We looked back at what the Fed said at the time, and policymakers didn’t foresee a recession; the larger .50% cut might have been their way of showing how worried they really were at the time. In other words, maybe the Fed knew there potentially was trouble under the surface.
Compare this with three consecutive 25 basis point (.25%) cuts in the 1995/1996 and 1998 rate cut cycles, which led to continued equity gains and avoided recessions. Given we foresee one more cut this year, could it be another three cuts of 25 basis points (.25%) and then an economic acceleration?
“Here’s the catch. When the first two cuts in a new cycle of rate cuts are only 25 basis points, this could be the Fed’s way of truly viewing the cuts as insurance,” explained LPL Financial Senior Market Strategist Ryan Detrick. “In fact, the past five cycles of cuts that started with two 25 basis point cuts saw the S&P 500 Index move higher 6 and 12 months later every single time.”
As shown in the LPL Chart of the Day, Stocks Have Historically Done Well If The First Two Fed Rate Cuts Are 25 Basis Points, the S&P 500 was up an average of 9.7% six months after the second of two 25 basis point cuts to kick off a new cycle of rate cuts. Going out a year, the S&P 500 had gained a very impressive average of 16.7%.
(CLICK HERE FOR THE CHART!)

Strong Start for September, but Second Half Could Bring Trouble

As of Friday’s close the market is well above historical average performance in September. DJIA was up nearly 3.1%, S&P 500 was up 2.8%, NASDAQ and Russell 1000 were up 2.7% while Russell 2000 was up 5.6%. Small-caps outperforming large-caps recently is not unusual and they did so again today. However, the second half of September has historically been weaker than the first half. The week after options expiration week can be treacherous with S&P 500 logging 23 weekly losses in 29 years since 1990. End-of-quarter portfolio restructuring, and window dressing can amplify the impacts of any negative headlines.
(CLICK HERE FOR THE CHART!)

Broader Transports Still Outperforming YTD

With shares of FedEx (FDX) on pace for their second worst earnings reaction day since at least 2001, the Dow Transports, an index in which FDX has a weighting of over 8% (after today's decline), is down close to 2%. Historically, the Transports have been considered a leading indicator of the economy, so the weakness in FDX, and by extension, the Dow Transports, is resulting in heightened concerns over the state of the economy. Looking at the chart below, the picture for the Transports doesn't look pretty. The timing of today's decline couldn't have been worse as it came just as the Transports were attempting to break above the highs from July, but now it just looks like the second lower high this year. Following today's declines, the Dow Transports are up 14.7% YTD which is about five percentage points behind the performance of the S&P 500.
(CLICK HERE FOR THE CHART!)
Given the changes in the US economy over time, we've been skeptical of the continued predictive ability of the Transports, but even putting that aside for a moment, a broader look at Transports shows a less pessimistic picture. The chart below shows the performance of the stocks in the S&P 1500 index on an equal-weighted basis so far in 2019. By this measure, today's decline comes after the index made a higher high, and while it's back below those former highs today, with a gain of 20.5% YTD, this broader look at transports is still outperforming the S&P 500 on a YTD basis. It may not be a great picture for this group of transport stocks, but it doesn't really look bad either.
(CLICK HERE FOR THE CHART!)

STOCK MARKET VIDEO: Stock Market Analysis Video for Week Ending September 20th, 2019

(CLICK HERE FOR THE YOUTUBE VIDEO!)

STOCK MARKET VIDEO: ShadowTrader Video Weekly 09.22.19

(CLICK HERE FOR THE YOUTUBE VIDEO!)
Here are the most notable companies (tickers) reporting earnings in this upcoming trading week ahead-
  • $MU
  • $NIO
  • $AZO
  • $KMX
  • $NKE
  • $BB
  • $RAD
  • $CMD
  • $ACN
  • $UXIN
  • $JBL
  • $INFO
  • $CAG
  • $DAVA
  • $MANU
  • $SNX
  • $FDS
  • $KBH
  • $UEPS
  • $ATU
  • $CTAS
  • $MTN
  • $AGTC
  • $WOR
  • $PIR
  • $ISR
  • $DLNG
  • $CAMP
  • $AIR
  • $FUL
  • $PRGS
  • $CMTL
  • $DYNT
  • $RBZ
(CLICK HERE FOR NEXT WEEK'S MOST NOTABLE EARNINGS RELEASES!)
(CLICK HERE FOR NEXT WEEK'S HIGHEST VOLATILITY EARNINGS RELEASES!)
(CLICK HERE FOR MOST ANTICIPATED EARNINGS RELEASES FOR THE NEXT 5 WEEKS!)
Below are some of the notable companies coming out with earnings releases this upcoming trading week ahead which includes the date/time of release & consensus estimates courtesy of Earnings Whispers:

Monday 9.23.19 Before Market Open:

(CLICK HERE FOR MONDAY'S PRE-MARKET EARNINGS TIME & ESTIMATES!)

Monday 9.23.19 After Market Close:

([CLICK HERE FOR MONDAY'S AFTER-MARKET EARNINGS TIME & ESTIMATES LINK!]())
NONE.

Tuesday 9.24.19 Before Market Open:

(CLICK HERE FOR TUESDAY'S PRE-MARKET EARNINGS TIME & ESTIMATES LINK!)

Tuesday 9.24.19 After Market Close:

(CLICK HERE FOR TUESDAY'S AFTER-MARKET EARNINGS TIME & ESTIMATES LINK!)

Wednesday 9.25.19 Before Market Open:

(CLICK HERE FOR WEDNESDAY'S PRE-MARKET EARNINGS TIME & ESTIMATES LINK!)

Wednesday 9.25.19 After Market Close:

(CLICK HERE FOR WEDNESDAY'S AFTER-MARKET EARNINGS TIME & ESTIMATES LINK!)

Thursday 9.26.19 Before Market Open:

(CLICK HERE FOR THURSDAY'S PRE-MARKET EARNINGS TIME & ESTIMATES LINK!)

Thursday 9.26.19 After Market Close:

(CLICK HERE FOR THURSDAY'S AFTER-MARKET EARNINGS TIME & ESTIMATES LINK!)

Friday 9.27.19 Before Market Open:

([CLICK HERE FOR FRIDAY'S PRE-MARKET EARNINGS TIME & ESTIMATES!]())
NONE.

Friday 9.27.19 After Market Close:

([CLICK HERE FOR FRIDAY'S AFTER-MARKET EARNINGS TIME & ESTIMATES!]())
NONE.

Micron Technology, Inc. $49.16

Micron Technology, Inc. (MU) is confirmed to report earnings at approximately 4:05 PM ET on Thursday, September 26, 2019. The consensus earnings estimate is $0.43 per share on revenue of $4.51 billion and the Earnings Whisper ® number is $0.49 per share. Investor sentiment going into the company's earnings release has 67% expecting an earnings beat The company's guidance was for earnings of $0.38 to $0.52 per share. Consensus estimates are for earnings to decline year-over-year by 87.92% with revenue decreasing by 46.56%. Short interest has decreased by 21.7% since the company's last earnings release while the stock has drifted higher by 37.1% from its open following the earnings release to be 23.2% above its 200 day moving average of $39.90. Overall earnings estimates have been revised lower since the company's last earnings release. On Friday, September 20, 2019 there was some notable buying of 12,865 contracts of the $50.00 put expiring on Friday, September 27, 2019. Option traders are pricing in a 7.5% move on earnings and the stock has averaged a 7.1% move in recent quarters.

(CLICK HERE FOR THE CHART!)

NIO Inc. $3.04

NIO Inc. (NIO) is confirmed to report earnings at approximately 4:30 AM ET on Tuesday, September 24, 2019. Investor sentiment going into the company's earnings release has 51% expecting an earnings beat The company's guidance was for revenue of $169.00 million to $193.00 million. Short interest has increased by 25.8% since the company's last earnings release while the stock has drifted lower by 26.2% from its open following the earnings release to be 39.6% below its 200 day moving average of $5.03. On Wednesday, September 4, 2019 there was some notable buying of 40,590 contracts of the $1.50 put expiring on Friday, November 15, 2019. Option traders are pricing in a 17.1% move on earnings and the stock has averaged a 9.7% move in recent quarters.

(CLICK HERE FOR THE CHART!)

AutoZone, Inc. -

AutoZone, Inc. (AZO) is confirmed to report earnings at approximately 7:00 AM ET on Tuesday, September 24, 2019. The consensus earnings estimate is $21.64 per share on revenue of $3.94 billion and the Earnings Whisper ® number is $21.98 per share. Investor sentiment going into the company's earnings release has 62% expecting an earnings beat. Consensus estimates are for year-over-year earnings growth of 16.72% with revenue increasing by 10.71%. Short interest has increased by 23.5% since the company's last earnings release while the stock has drifted higher by 15.1% from its open following the earnings release to be 15.6% above its 200 day moving average of $1,003.22. Overall earnings estimates have been revised higher since the company's last earnings release. Option traders are pricing in a 5.8% move on earnings and the stock has averaged a 6.7% move in recent quarters.

(CLICK HERE FOR THE CHART!)

CarMax, Inc. $84.63

CarMax, Inc. (KMX) is confirmed to report earnings at approximately 7:35 AM ET on Tuesday, September 24, 2019. The consensus earnings estimate is $1.33 per share on revenue of $5.03 billion and the Earnings Whisper ® number is $1.38 per share. Investor sentiment going into the company's earnings release has 63% expecting an earnings beat. Consensus estimates are for year-over-year earnings growth of 7.26% with revenue increasing by 5.54%. Short interest has increased by 0.7% since the company's last earnings release while the stock has drifted lower by 3.6% from its open following the earnings release to be 14.9% above its 200 day moving average of $73.63. Overall earnings estimates have been revised higher since the company's last earnings release. On Friday, September 6, 2019 there was some notable buying of 1,023 contracts of the $92.50 call expiring on Friday, October 18, 2019. Option traders are pricing in a 7.2% move on earnings and the stock has averaged a 6.0% move in recent quarters.

(CLICK HERE FOR THE CHART!)

Nike Inc $86.68

Nike Inc (NKE) is confirmed to report earnings at approximately 4:15 PM ET on Tuesday, September 24, 2019. The consensus earnings estimate is $0.71 per share on revenue of $10.45 billion and the Earnings Whisper ® number is $0.76 per share. Investor sentiment going into the company's earnings release has 65% expecting an earnings beat. Consensus estimates are for year-over-year earnings growth of 5.97% with revenue increasing by 5.05%. Short interest has increased by 0.4% since the company's last earnings release while the stock has drifted higher by 3.2% from its open following the earnings release to be 5.1% above its 200 day moving average of $82.50. Overall earnings estimates have been revised lower since the company's last earnings release. On Monday, September 16, 2019 there was some notable buying of 4,646 contracts of the $84.00 call expiring on Friday, September 27, 2019. Option traders are pricing in a 5.2% move on earnings and the stock has averaged a 4.5% move in recent quarters.

(CLICK HERE FOR THE CHART!)

BlackBerry Limited $7.54

BlackBerry Limited (BB) is confirmed to report earnings at approximately 7:00 AM ET on Tuesday, September 24, 2019. The consensus estimate is for a loss of $0.01 per share and the Earnings Whisper ® number is $0.01 per share. Investor sentiment going into the company's earnings release has 32% expecting an earnings beat. Consensus estimates are for earnings to decline year-over-year by 150.00% with revenue increasing by 375.71%. Short interest has increased by 1.0% since the company's last earnings release while the stock has drifted lower by 9.2% from its open following the earnings release to be 6.9% below its 200 day moving average of $8.10. Overall earnings estimates have been revised higher since the company's last earnings release. On Tuesday, September 17, 2019 there was some notable buying of 2,012 contracts of the $8.00 call expiring on Friday, September 27, 2019. Option traders are pricing in a 9.9% move on earnings and the stock has averaged a 7.9% move in recent quarters.

(CLICK HERE FOR THE CHART!)

Rite Aid Corp. $7.40

Rite Aid Corp. (RAD) is confirmed to report earnings at approximately 7:00 AM ET on Thursday, September 26, 2019. The consensus earnings estimate is $0.08 per share on revenue of $5.42 billion and the Earnings Whisper ® number is $0.10 per share. Investor sentiment going into the company's earnings release has 50% expecting an earnings beat. Consensus estimates are for year-over-year earnings growth of 900.00% with revenue decreasing by 0.03%. Short interest has increased by 22.2% since the company's last earnings release while the stock has drifted higher by 5.1% from its open following the earnings release to be 36.4% below its 200 day moving average of $11.64. On Wednesday, September 18, 2019 there was some notable buying of 580 contracts of the $7.00 call expiring on Friday, October 18, 2019. Option traders are pricing in a 20.7% move on earnings and the stock has averaged a 20.5% move in recent quarters.

(CLICK HERE FOR THE CHART!)

Cantel Medical Corp. $85.02

Cantel Medical Corp. (CMD) is confirmed to report earnings at approximately 8:00 AM ET on Monday, September 23, 2019. The consensus earnings estimate is $0.61 per share on revenue of $238.60 million and the Earnings Whisper ® number is $0.61 per share. Investor sentiment going into the company's earnings release has 55% expecting an earnings beat. Consensus estimates are for earnings to decline year-over-year by 1.61% with revenue increasing by 4.26%. Short interest has increased by 47.7% since the company's last earnings release while the stock has drifted higher by 27.5% from its open following the earnings release to be 10.7% above its 200 day moving average of $76.78. Overall earnings estimates have been revised lower since the company's last earnings release. On Friday, September 20, 2019 there was some notable buying of 571 contracts of the $90.00 call expiring on Friday, October 18, 2019. Option traders are pricing in a 7.0% move on earnings and the stock has averaged a 6.9% move in recent quarters.

(CLICK HERE FOR THE CHART!)

Accenture Ltd. $193.09

Accenture Ltd. (ACN) is confirmed to report earnings at approximately 6:50 AM ET on Thursday, September 26, 2019. The consensus earnings estimate is $1.71 per share on revenue of $11.08 billion and the Earnings Whisper ® number is $1.74 per share. Investor sentiment going into the company's earnings release has 67% expecting an earnings beat. Consensus estimates are for year-over-year earnings growth of 8.23% with revenue increasing by 4.11%. Short interest has increased by 23.3% since the company's last earnings release while the stock has drifted higher by 8.0% from its open following the earnings release to be 11.3% above its 200 day moving average of $173.47. Overall earnings estimates have been unchanged since the company's last earnings release. On Friday, September 13, 2019 there was some notable buying of 1,279 contracts of the $115.00 put expiring on Friday, November 15, 2019. Option traders are pricing in a 4.5% move on earnings and the stock has averaged a 4.2% move in recent quarters.

(CLICK HERE FOR THE CHART!)

Uxin Limited $3.26

Uxin Limited (UXIN) is confirmed to report earnings before the market opens on Monday, September 23, 2019. The consensus estimate is for a loss of $0.09 per share. Investor sentiment going into the company's earnings release has 66% expecting an earnings beat The company's guidance was for revenue of $130.00 million to $137.00 million. Consensus estimates are for earnings to decline year-over-year by 200.00% with revenue increasing by 892.95%. The stock has drifted higher by 44.9% from its open following the earnings release to be 4.5% below its 200 day moving average of $3.41. Overall earnings estimates have been revised lower since the company's last earnings release. On Friday, September 20, 2019 there was some notable buying of 509 contracts of the $4.00 call expiring on Friday, October 18, 2019. Option traders are pricing in a 24.5% move on earnings and the stock has averaged a 10.5% move in recent quarters.

(CLICK HERE FOR THE CHART!)

DISCUSS!

What are you all watching for in this upcoming trading week?
I hope you all have a wonderful weekend and a great trading week ahead wallstreetbets.
submitted by bigbear0083 to wallstreetbets [link] [comments]

Download historical exchange rates

Howdy!
I've been trying to build into my spreadsheet a way to download historical foreign exchange rate, but so far no luck. I've found this link with a spreadsheet downloading info from an Ohana website, but apparently it doesn't work anymore. (Or it's now a paid service which doesn't work for me either way)
Any ideas on how to do this?
EDIT: So, just as an addendum to my issue, this spreadsheet will be opened once every other week (maybe), but every time it opens it needs to update with all the exchange rates from the passed days.
My current code that sort of works
 Sub GetData() Dim str As String Dim iRow As Integer Dim rngCambio As Range Set DataSheet = Worksheets("CAMBIO") Application.ScreenUpdating = False Application.DisplayAlerts = False Application.Calculation = xlCalculationManual QueryQuote: With Sheets("CAMBIO").QueryTables.Add(Connection:="URL;https://www.currency-converter.org.uk/currency-rates/historical/table/EUR-RON.html", Destination:=Sheets("CAMBIO").Range("a1")) .BackgroundQuery = True .TablesOnlyFromHTML = False .Refresh BackgroundQuery:=False .SaveData = True End With ActiveSheet.Hyperlinks.Delete Range("A1,C1,E1").EntireColumn.Delete Range("A1:A66").EntireRow.Delete iRow = Range("B:B").Cells.Find(What:="", SearchOrder:=xlRows, SearchDirection:=xlNext, LookIn:=xlValues).Row - 1 Set rngCambio = Range("B1", "B" & iRow) For Each Cell In rngCambio Cell.Value = Left(Cell.Value, InStr(Cell.Value, " ") - 1) Next Cell 
End Sub
submitted by NickNunes26 to excel [link] [comments]

Elaborating on Datadash's 50k BTC Prediction: Why We Endorse the Call

As originally published via CoinLive
I am the Co-Founder at CoinLive. Prior to founding Coinlive.io, my area of expertise was inter-market analysis. I came across Datadash 50k BTC prediction this week, and I must take my hats off to what I believe is an excellent interpretation of the inter-connectivity of various markets.
At your own convenience, you can find a sample of Intermarket analysis I've written in the past before immersing myself into cryptos full-time.
Gold inter-market: 'Out of sync' with VIX, takes lead from USD/JPY
USD/JPY inter-market: Watch divergence US-Japan yield spread
EUUSD intermarket: US yields collapse amid supply environment
Inter-market analysis: Risk back in vogue, but for how long?
USD/JPY intermarket: Bulls need higher adj in 10-y US-JP spread
The purpose of this article is to dive deeper into the factors Datadash presents in his video and how they can help us draw certain conclusions about the potential flows of capital into crypto markets and the need that will exist for a BTC ETF.
Before I do so, as a brief explainer, let's touch on what exactly Intermarket analysis refers to:
Intermarket analysis is the global interconnectivity between equities, bonds, currencies, commodities, and any other asset class; Global markets are an ever-evolving discounting and constant valuation mechanism and by studying their interconnectivity, we are much better positioned to explain and elaborate on why certain moves occur, future directions and gain insights on potential misalignments that the market may not have picked up on yet or might be ignoring/manipulating.
While such interconnectivity has proven to be quite limiting when it comes to the value one can extract from analyzing traditional financial assets and the crypto market, Datadash has eloquently been able to build a hypothesis, which as an Intermarket analyst, I consider very valid, and that matches up my own views. Nicolas Merten constructs a scenario which leads him to believe that a Bitcoin ETF is coming. Let's explore this hypothesis.
I will attempt to summarize and provide further clarity on why the current events in traditional asset classes, as described by Datadash, will inevitably result in a Bitcoin ETF. Make no mistake, Datadash's call for Bitcoin at 50k by the end of 2018 will be well justified once a BTC ETF is approved. While the timing is the most challenging part t get right, the end result won't vary.
If one wishes to learn more about my personal views on why a BTC ETF is such a big deal, I encourage you to read my article from late March this year.
Don't Be Misled by Low Liquidity/Volume - Fundamentals Never Stronger
The first point Nicholas Merten makes is that despite depressed volume levels, the fundamentals are very sound. That, I must say, is a point I couldn't agree more. In fact, I recently wrote an article titled The Paradox: Bitcoin Keeps Selling as Intrinsic Value Set to Explode where I state "the latest developments in Bitcoin's technology makes it paradoxically an ever increasingly interesting investment proposition the cheaper it gets."
However, no article better defines where we stand in terms of fundamentals than the one I wrote back on May 15th titled Find Out Why Institutions Will Flood the Bitcoin Market, where I look at the ever-growing list of evidence that shows why a new type of investors, the institutional ones, looks set to enter the market in mass.
Nicholas believes that based on the supply of Bitcoin, the market capitalization can reach about $800b. He makes a case that with the fundamentals in bitcoin much stronger, it wouldn't be that hard to envision the market cap more than double from its most recent all-time high of more than $300b.
Interest Rates Set to Rise Further
First of all, one of the most immediate implications of higher rates is the increased difficulty to bear the costs by borrowers, which leads Nicholas to believe that banks the likes of Deutsche Bank will face a tough environment going forward. The CEO of the giant German lender has actually warned that second-quarter results would reflect a “revenue environment [that] remains challenging."
Nicholas refers to the historical chart of Eurodollar LIBOR rates as illustrated below to strengthen the case that interest rates are set to follow an upward trajectory in the years to come as Central Banks continue to normalize monetary policies after a decade since the global financial crisis. I'd say, that is a correct assumption, although one must take into account the Italian crisis to be aware that a delay in higher European rates is a real possibility now.
![](https://coinlive.io/ckeditor_assets/pictures/947/content_2018-05-30_1100.png)
Let's look at the following combinations: Fed Fund Rate Contract (green), German 2-year bond yields (black) and Italy's 10-year bond yield (blue) to help us clarify what's the outlook for interest rates both in Europe and the United States in the foreseeable future. The chart suggests that while the Federal Reserve remains on track to keep increasing interest rates at a gradual pace, there has been a sudden change in the outlook for European rates in the short-end of the curve.
While the European Central Bank is no longer endorsing proactive policies as part of its long-standing QE narrative, President Mario Draghi is still not ready to communicate an exit strategy to its unconventional stimulus program due to protectionism threats in the euro-area, with Italy the latest nightmare episode.
Until such major step is taken in the form of a formal QE conclusion, interest rates in the European Union will remain depressed; the latest drastic spike in Italy's benchmark bond yield to default levels is pre-emptive of lower rates for longer, an environment that on one hand may benefit the likes of Deutsche Bank on lower borrowing costs, but on the other hand, sets in motion a bigger headache as risk aversion is set to dominate financial markets, which leads to worse financial consequences such as loss of confidence and hence in equity valuations.
![](https://coinlive.io/ckeditor_assets/pictures/948/content_2018-05-30_1113.png)
Deutsche Bank - End of the Road?
Nicholas argues that as part of the re-restructuring process in Deutsche Bank, they will be facing a much more challenging environment as lending becomes more difficult on higher interest rates. At CoinLive, we still believe this to be a logical scenario to expect, even if a delay happens as the ECB tries to deal with the Italian political crisis which once again raises the question of whether or not Italy should be part of the EU. Reference to an article by Zerohedge is given, where it states:
"One day after the WSJ reported that the biggest German bank is set to "decimate" its workforce, firing 10,000 workers or one in ten, this morning Deutsche Bank confirmed plans to cut thousands of jobs as part of new CEO Christian Sewing's restructuring and cost-cutting effort. The German bank said its headcount would fall “well below” 90,000, from just over 97,000. But the biggest gut punch to employee morale is that the bank would reduce headcount in its equities sales and trading business by about 25%."
There is an undeniably ongoing phenomenon of a migration in job positions from traditional financial markets into blockchain, which as we have reported in the past, it appears to be a logical and rational step to be taken, especially in light of the new revenue streams the blockchain sector has to offer. Proof of that is the fact that Binance, a crypto exchange with around 200 employees and less than 1 year of operations has overcome Deutsche Bank, in total profits. What this communicates is that the opportunities to grow an institution’s revenue stream are formidable once they decide to integrate cryptocurrencies into their business models.
One can find an illustration of Deutsche Bank's free-fall in prices below:
![](https://coinlive.io/ckeditor_assets/pictures/946/content_2018-05-30_1052.png)
Nicholas takes notes of a chart in which one can clearly notice a worrying trend for Italian debt. "Just about every other major investor type has become a net seller (to the ECB) or a non-buyer of BTPs over the last couple of years. Said differently, for well over a year, the only marginal buyer of Italian bonds has been the ECB!", the team of Economists at Citi explained. One can find the article via ZeroHedge here.
![](https://coinlive.io/ckeditor_assets/pictures/953/content_2018-05-30_1451.png)
Equities & Housing to Suffer the Consequences
Nicholas notes that trillions of dollars need to exit these artificially-inflated equity markets. He even mentions a legendary investor such as George Soros, who has recently warned that the world could be on the brink of another devastating financial crisis, on lingering debt concerns in Europe and a strengthening US dollar, as a destabilizing factor for both the US's emerging- and developed-market rivals.
Ray Dalio, another legend in the investing world and Founder of Bridgewater Associates, the world’s largest hedge fund, "has ramped up its short positions in European equities in recent weeks, bringing their total value to an estimated $22 billion", MarketWatch reports.
Nicholas extracts a chart by John Del Vecchio at lmtr.com where it illustrates the ratio between stocks and commodities at the lowest in over 50 years.
As the author states:
"I like to look for extremes in the markets. Extremes often pinpoint areas where returns can be higher and risk lower than in other time periods. Take the relationship between commodities and stocks. The chart below shows that commodities haven not been cheaper than stocks in a generation. We often hear this time it is different” to justify what’s going on in the world. But, one thing that never changes is human nature. People push markets to extremes. Then they revert. "
![](https://coinlive.io/ckeditor_assets/pictures/954/content_2018-05-30_1459.png)
Bitcoin ETF the Holy Grail for a Cyclical Multi-Year Bull Run
It is precisely from this last chart above that leads Nicholas to believe we are on the verge of a resurgence in commodity prices. Not only that but amid the need of all this capital to exit stocks and to a certain extent risky bonds (Italian), a new commodity-based digital currency ETF based on Bitcoin will emerge in 2018.
The author of Datadash highlights the consideration to launching a Bitcoin ETF by the SEC. At CoinLive, our reporting of the subject can be found below:
"Back in April, it was reported that the US Securities and Exchange Commission (SEC) has put back on the table two Bitcoin ETF proposals, according to public documents. The agency is under formal proceedings to approve a rule change that would allow NYSE Arca to list two exchange-traded funds (ETFs) proposed by fund provider ProShares. The introduction of an ETF would make Bitcoin available to a much wider share of market participants, with the ability to directly buy the asset at the click of a button, essentially simplifying the current complexity that involves having to deal with all the cumbersome steps currently in place."
Nicholas refers to the support the Bitcoin ETF has been receiving by the Cboe president Chris Concannon, which is a major positive development. CoinLive reported on the story back in late March, noting that "a Bitcoin ETF will without a doubt open the floodgates to an enormous tsunami of fresh capital entering the space, which based on the latest hints by Concannon, the willingness to keep pushing for it remains unabated as the evolution of digital assets keeps its course."
It has been for quite some time CoinLive's conviction, now supported by no other than Nicholas Merten from Datadash, that over the next 6 months, markets will start factoring in the event of the year, that is, the approval of a Bitcoin ETF that will serve as a alternative vehicle to accommodate the massive flows of capital leaving some of the traditional asset classes. As Nicholas suggests, the SEC will have little choice but to provide alternative investments.
Bitcoin as a Hedge to Lower Portfolios' Volatility
Last but not least, crypto assets such as Bitcoin and the likes have an almost non-existent correlation to other traditional assets such as stocks, bonds, and commodities, which makes for a very attractive and broadly-applicable diversification strategy for the professional money as it reduces one’s portfolio volatility. The moment a Bitcoin ETF is confirmed, expect the non-correlation element of Bitcoin as a major driving force to attract further capital.
Anyone Can Be Wrong Datadash, But You Won't be Wrong Alone
Having analyzed the hypothesis by Nicholas Merten, at CoinLive we believe that the conclusion reached, that is, the creation of a Bitcoin ETF that will provide shelter to a tsunami of capital motivated by the diversification and store of value appeal of Bitcoin, is the next logical step. As per the timing of it, we also anticipate, as Nicholas notes, that it will most likely be subject to the price action in traditional assets. Should equities and credit markets hold steady, it may result in a potential delay, whereas disruption in the capital market may see the need for a BTC ETF accelerate. Either scenario, we will conclude with a quote we wrote back in March.
"It appears as though an ETF on Bitcoin is moving from a state of "If" to "When."
Datadash is certainly not alone on his 50k call. BitMEX CEO Arthur Hayes appears to think along the same line.
On behalf of the CoinLive Team, we want to thank Nicholas Merten at Datadash for such enlightening insights.
submitted by Ivo333 to BitcoinMarkets [link] [comments]

Wall Street Week Ahead for the trading week beginning September 23rd, 2019

Good Saturday morning to all of you here on stocks. I hope everyone on this sub made out pretty nicely in the market this past week, and is ready for the new trading week ahead.
Here is everything you need to know to get you ready for the trading week beginning September 23rd, 2019.

Week ahead: As stocks struggle to break to new highs, markets could be swayed by Fed speakers, trade - (Source)

Developments in U.S.-Chinese trade talks and the comments from a host of Fed speakers could be important for markets in the week ahead, as stocks struggle to regain highs.
The Fed in the past week cut interest rates for the second time in two months, but the latest forecasts of Fed officials showed just how divided they are on the need for future rate cuts. Five wanted deeper cuts, five didn’t want any cuts and another seven were happy with the Fed’s action.
“The market seems like it’s pretty jumpy based on what the say. i think it would flip back and forth depending on how the headlines come out,” said Tom Simons, money market economist at Jefferies. Simons said the focus will also be on the Fed’s operations in the short-term funding market, after turbulence in the overnight market in the past week temporarily sent some overnight rates sharply higher.
There are nearly a dozen Fed speakers on the calendar in the coming week, but Fed Chairman Jerome Powell is not scheduled to speak.
Trade developments could continue to cause volatility in markets. Reports Friday that Chinese agriculture officials canceled visits to farms in Montana and Nebraska sent stocks lower, for fear it signaled that talks were not making progress.
Stocks in the past week were lower, with the S&P off about 0.5% to 2,992. The index had been around 1% away from its all-time high for a few weeks.
“Tech that has been out of play and is acting faulty. it’s now turning into a headwind, and that could cause a problem for the bulls,” said Scott Redler, partner with T3Live.com. “I haven’t seen so many mixed signals in the market in quite some time.”
“It’s hard for the market to make new highs without tech. At best, it’s concerning when you see key names, like Amazon and Netflix, not just failing to lead but faltering,” he said. Netflix was down more than 8% for the week, and Amazon was off 2.6%.
Redler said it was a concern that shares of market leader Microsoft gave up its initial gains and turned negative, soon after it announced a buyback and raised its dividend. “Strength was sold instead of embraced,” he said. “That was good news. What are they going to do when bad news happens?”
Following the attacks on Saudi Aramco last week, the United Nations General Assembly in New York and meetings around it take on more importance for markets. U.S. and Saudi Arabian officials have said Iran was behind the attack, which knocked a significant amount of Saudi oil production off line. Iran has denied involvement, and Houthi rebels in Yemen have claimed responsibility.
Iran’ President Hassan Rouhani has been given a visa to travel to New York for the UN. Before the attack on Saudi Arabia last week, President Donald Trump had suggested he would speak to Rouhani but there seems little chance of that now. Oil have been highly volatile, with Brent crude futures up 7% since the attack as Saudi Arabia sought to assure markets that it would be able to bring its operations back on line.
There is some economic data that will also be important to markets. There is manufacturing PMI Monday, important after ISM manufacturing data showed a contraction in August. Durable goods will also be important on Friday, as will personal consumption data, which includes the Fed’s preferred inflation indicator, the core PCE deflator.
“What Powell said in his remarks was inflation was below his target,” said Marc Chandler, chief market strategist at Bannockburn Global Forex. “But even the core PCE deflator is expected to be 1.8, a new high for the year.” The Fed’s target inflation rate is 2%, and other inflation measures have been above that, including core CPI.
The Fed will also be in focus after problems in the overnight funding market, used by banks in need of short term cash. Rates spiked for repo, or repurchase agreements, in a chaotic two-day period Monday and Tuesday. The Fed’s target fed funds rate also moved above its target range, in an unusual move.
The market has since calmed after the Fed carried out open market operations to add liquidity to the market. On Friday, it announced three 14-day operations involving $30 billion as well as continued overnight operations of at least $75 billion each.
“I think the Fed has absolute control over short term rates. It was caught sleeping at the wheel,” said Chandler.
Powell said the Fed would monitor the market and take whatever action is needed. The market is considered the basic plumbing for financial markets, where banks who have a short-term need for cash come to fund themselves. The odd spike in rates was viewed as the result of a cash crunch, not a credit crisis.
Bond market pros have been concerned that the Fed would again see strains in the market at month end, when there’s more activity in the overnight funding market.
“It gets you further past quarter end,” said Jon Hill, rate strategist at BMO. “A 14-day pushes them further into October. I think nerves will have calmed. The fact you’ll see fed funds print clearly in the range will reassert confidence. These operations will serve as a reminder that the Fed can have absolute control the front end if and when it wants to. This is a good thing.”
The funds rate was at 1.90% Thursday, within the target rate range of 1.75% to 2%.
“They’re removing any doubt of their ability to take control of fed funds in the modern framework. They just announced $165 billion over quarter-end , and we may go bigger. They haven’t done a repo injection in 10 years,” said Hill.

This past week saw the following moves in the S&P:

(CLICK HERE FOR THE FULL S&P TREE MAP FOR THE PAST WEEK!)

Major Indices for this past week:

(CLICK HERE FOR THE MAJOR INDICES FOR THE PAST WEEK!)

Major Futures Markets as of Friday's close:

(CLICK HERE FOR THE MAJOR FUTURES INDICES AS OF FRIDAY!)

Economic Calendar for the Week Ahead:

(CLICK HERE FOR THE FULL ECONOMIC CALENDAR FOR THE WEEK AHEAD!)

Sector Performance WTD, MTD, YTD:

(CLICK HERE FOR FRIDAY'S PERFORMANCE!)
(CLICK HERE FOR THE WEEK-TO-DATE PERFORMANCE!)
(CLICK HERE FOR THE MONTH-TO-DATE PERFORMANCE!)
(CLICK HERE FOR THE 3-MONTH PERFORMANCE!)
(CLICK HERE FOR THE YEAR-TO-DATE PERFORMANCE!)
(CLICK HERE FOR THE 52-WEEK PERFORMANCE!)

Percentage Changes for the Major Indices, WTD, MTD, QTD, YTD as of Friday's close:

(CLICK HERE FOR THE CHART!)

S&P Sectors for the Past Week:

(CLICK HERE FOR THE CHART!)

Major Indices Pullback/Correction Levels as of Friday's close:

(CLICK HERE FOR THE CHART!

Major Indices Rally Levels as of Friday's close:

(CLICK HERE FOR THE CHART!)

Most Anticipated Earnings Releases for this week:

(CLICK HERE FOR THE CHART!)

Here are the upcoming IPO's for this week:

(CLICK HERE FOR THE CHART!)

Friday's Stock Analyst Upgrades & Downgrades:

(CLICK HERE FOR THE CHART LINK #1!)
(CLICK HERE FOR THE CHART LINK #2!)
(CLICK HERE FOR THE CHART LINK #3!)

S&P 500 down 23 of 29 during week after September options expiration, average loss 0.95%

The week after September options expiration week, next week, has a dreadful history of declines especially since 1990. The week after September options expiration week has been a nearly constant source of pain with only a few meaningful exceptions over the past 29 years. Substantial and across the board gains have occurred just three times: 1998, 2001, 2010 and 2016 while many more weeks were hit with sizable losses.
Full stats are in the following sea-of-red table. Average losses since 1990 are even worse; DJIA –1.02%, S&P 500 –0.95%, NASDAQ –0.90% and a sizable –1.38% for Russell 2000. End-of-Q3 portfolio restructuring is the most likely explanation for this trend as managers trim summer losers and position for the fourth quarter.
(CLICK HERE FOR THE CHART!)

October Challenging in Pre-Election Years

October often evokes fear on Wall Street as memories are stirred of crashes in 1929, 1987, the 554-point drop on October 27, 1997, back-to-back massacres in 1978 and 1979, Friday the 13th in 1989 and the 733-point drop on October 15, 2008. During the week ending October 10, 2008, Dow lost 1,874.19 points (18.2%), the worst weekly decline in our database going back to 1901, in point and percentage terms. The term “Octoberphobia” has been used to describe the phenomenon of major market drops occurring during the month. Market calamities can become a self-fulfilling prophecy, so stay on the lookout and don’t get whipsawed if it happens.
(CLICK HERE FOR THE CHART!)
Pre-election year Octobers are ranked second from last for DJIA, S&P 500 and NASDAQ while Russell 2000 is dead last with an average loss of 1.9%. Eliminating gruesome 1987 from the calculation provides only a moderate amount of relief. Should a meaningful decline materialize in October it is likely to be an excellent buying opportunity, especially for depressed technology and small-cap shares.

Where’s That September Volatility?

September is historically known as one of the worst for stocks, yet in 2019 the S&P 500 Index is up 2.7% so far amid a sea of scary headlines. Incredibly, the S&P 500 has wavered less than 0.1% from its previous close 6 of the past 10 trading sessions, as it consolidates just beneath all-time highs.
“Over the past two weeks we’ve had the European Central Bank meeting, the Federal Reserve meeting, higher inflation, a historic jump in crude oil, Middle East turmoil, trouble in the repo market, and even multiple NFL quarterbacks sustaining major injuries,” said LPL Financial Senior Market Strategist Ryan Detrick. “Yet, with all of those scary headlines, stocks are actually in the midst of one of the least volatile two-week stretches we’ve seen in years.”
We are quite encouraged by the overall change in market tone we’ve heard recently, with more cyclical names taking the baton and leading, but with the S&P 500 up near our fair value target of 3,000, we would be on the lookout for this sea of tranquility to get rougher at any time. In fact, according to historical calendars, we may need to be on high guard for the second half of September.
As shown in the LPL Chart of the Day, The Second Half of September Can Be Tricky For Stocks, later in the month of September is when we’ve seen seasonal weakness. Things have been going well for equities in the face of some worrisome headlines, but don’t get complacent, as the calendar could be one of the biggest near-term risks.
(CLICK HERE FOR THE CHART!)

The Fed Hits It Down The Middle

“History does not repeat itself, but it rhymes.” Mark Twain
As expected, the Federal Reserve’s (Fed) policy committee cut its policy rate by 25 basis points (.25%) to a target range of 1.75%–2%. This comes on the heels of the first rate cut in more than 10 years at the end of July. This cut is somewhat more controversial, however, because the overall U.S. economic data has been improving, and there’s been a tick higher in inflation.
One of the most important questions heading into this meeting was how many voting Fed members would support additional rate cuts. There were two dissenting voting members at the July rate cut, and once again there were two votes opposed to today’s cut—but unlike last time, there was also one dissenter who favored a larger 50 basis point (.50%) cut. Materials in the economic projections indicated 10 of 17 participants (which includes non-voting members) did not believe additional cuts would be needed over the remainder of the year, although evolving economic conditions could certainly lead to a shift.
As the quote from Mark Twain suggests, by looking back at history we can potentially find clues as to what might happen in the future.
Looking back at the previous two recessions (2001 and 2008), the Fed cut rates 50 basis points (.50%) to kick off the new cycle of rate cuts. We looked back at what the Fed said at the time, and policymakers didn’t foresee a recession; the larger .50% cut might have been their way of showing how worried they really were at the time. In other words, maybe the Fed knew there potentially was trouble under the surface.
Compare this with three consecutive 25 basis point (.25%) cuts in the 1995/1996 and 1998 rate cut cycles, which led to continued equity gains and avoided recessions. Given we foresee one more cut this year, could it be another three cuts of 25 basis points (.25%) and then an economic acceleration?
“Here’s the catch. When the first two cuts in a new cycle of rate cuts are only 25 basis points, this could be the Fed’s way of truly viewing the cuts as insurance,” explained LPL Financial Senior Market Strategist Ryan Detrick. “In fact, the past five cycles of cuts that started with two 25 basis point cuts saw the S&P 500 Index move higher 6 and 12 months later every single time.”
As shown in the LPL Chart of the Day, Stocks Have Historically Done Well If The First Two Fed Rate Cuts Are 25 Basis Points, the S&P 500 was up an average of 9.7% six months after the second of two 25 basis point cuts to kick off a new cycle of rate cuts. Going out a year, the S&P 500 had gained a very impressive average of 16.7%.
(CLICK HERE FOR THE CHART!)

Strong Start for September, but Second Half Could Bring Trouble

As of Friday’s close the market is well above historical average performance in September. DJIA was up nearly 3.1%, S&P 500 was up 2.8%, NASDAQ and Russell 1000 were up 2.7% while Russell 2000 was up 5.6%. Small-caps outperforming large-caps recently is not unusual and they did so again today. However, the second half of September has historically been weaker than the first half. The week after options expiration week can be treacherous with S&P 500 logging 23 weekly losses in 29 years since 1990. End-of-quarter portfolio restructuring, and window dressing can amplify the impacts of any negative headlines.
(CLICK HERE FOR THE CHART!)

Broader Transports Still Outperforming YTD

With shares of FedEx (FDX) on pace for their second worst earnings reaction day since at least 2001, the Dow Transports, an index in which FDX has a weighting of over 8% (after today's decline), is down close to 2%. Historically, the Transports have been considered a leading indicator of the economy, so the weakness in FDX, and by extension, the Dow Transports, is resulting in heightened concerns over the state of the economy. Looking at the chart below, the picture for the Transports doesn't look pretty. The timing of today's decline couldn't have been worse as it came just as the Transports were attempting to break above the highs from July, but now it just looks like the second lower high this year. Following today's declines, the Dow Transports are up 14.7% YTD which is about five percentage points behind the performance of the S&P 500.
(CLICK HERE FOR THE CHART!)
Given the changes in the US economy over time, we've been skeptical of the continued predictive ability of the Transports, but even putting that aside for a moment, a broader look at Transports shows a less pessimistic picture. The chart below shows the performance of the stocks in the S&P 1500 index on an equal-weighted basis so far in 2019. By this measure, today's decline comes after the index made a higher high, and while it's back below those former highs today, with a gain of 20.5% YTD, this broader look at transports is still outperforming the S&P 500 on a YTD basis. It may not be a great picture for this group of transport stocks, but it doesn't really look bad either.
(CLICK HERE FOR THE CHART!)

STOCK MARKET VIDEO: Stock Market Analysis Video for Week Ending September 20th, 2019

([CLICK HERE FOR THE YOUTUBE VIDEO!]())
(VIDEO NOT YET UP!)

STOCK MARKET VIDEO: ShadowTrader Video Weekly 09.22.19

([CLICK HERE FOR THE YOUTUBE VIDEO!]())
(VIDEO NOT YET UP!)
Here are the most notable companies (tickers) reporting earnings in this upcoming trading week ahead-
  • $MU
  • $NIO
  • $AZO
  • $KMX
  • $NKE
  • $BB
  • $RAD
  • $CMD
  • $ACN
  • $UXIN
  • $JBL
  • $INFO
  • $CAG
  • $DAVA
  • $MANU
  • $SNX
  • $FDS
  • $KBH
  • $UEPS
  • $ATU
  • $CTAS
  • $MTN
  • $AGTC
  • $WOR
  • $PIR
  • $ISR
  • $DLNG
  • $CAMP
  • $AIR
  • $FUL
  • $PRGS
  • $CMTL
  • $DYNT
  • $RBZ
(CLICK HERE FOR NEXT WEEK'S MOST NOTABLE EARNINGS RELEASES!)
(CLICK HERE FOR NEXT WEEK'S HIGHEST VOLATILITY EARNINGS RELEASES!)
(CLICK HERE FOR MOST ANTICIPATED EARNINGS RELEASES FOR THE NEXT 5 WEEKS!)
Below are some of the notable companies coming out with earnings releases this upcoming trading week ahead which includes the date/time of release & consensus estimates courtesy of Earnings Whispers:

Monday 9.23.19 Before Market Open:

(CLICK HERE FOR MONDAY'S PRE-MARKET EARNINGS TIME & ESTIMATES!)

Monday 9.23.19 After Market Close:

([CLICK HERE FOR MONDAY'S AFTER-MARKET EARNINGS TIME & ESTIMATES LINK!]())
NONE.

Tuesday 9.24.19 Before Market Open:

(CLICK HERE FOR TUESDAY'S PRE-MARKET EARNINGS TIME & ESTIMATES LINK!)

Tuesday 9.24.19 After Market Close:

(CLICK HERE FOR TUESDAY'S AFTER-MARKET EARNINGS TIME & ESTIMATES LINK!)

Wednesday 9.25.19 Before Market Open:

(CLICK HERE FOR WEDNESDAY'S PRE-MARKET EARNINGS TIME & ESTIMATES LINK!)

Wednesday 9.25.19 After Market Close:

(CLICK HERE FOR WEDNESDAY'S AFTER-MARKET EARNINGS TIME & ESTIMATES LINK!)

Thursday 9.26.19 Before Market Open:

(CLICK HERE FOR THURSDAY'S PRE-MARKET EARNINGS TIME & ESTIMATES LINK!)

Thursday 9.26.19 After Market Close:

(CLICK HERE FOR THURSDAY'S AFTER-MARKET EARNINGS TIME & ESTIMATES LINK!)

Friday 9.27.19 Before Market Open:

([CLICK HERE FOR FRIDAY'S PRE-MARKET EARNINGS TIME & ESTIMATES!]())
NONE.

Friday 9.27.19 After Market Close:

([CLICK HERE FOR FRIDAY'S AFTER-MARKET EARNINGS TIME & ESTIMATES!]())
NONE.

Micron Technology, Inc. $49.16

Micron Technology, Inc. (MU) is confirmed to report earnings at approximately 4:05 PM ET on Thursday, September 26, 2019. The consensus earnings estimate is $0.43 per share on revenue of $4.51 billion and the Earnings Whisper ® number is $0.49 per share. Investor sentiment going into the company's earnings release has 67% expecting an earnings beat The company's guidance was for earnings of $0.38 to $0.52 per share. Consensus estimates are for earnings to decline year-over-year by 87.92% with revenue decreasing by 46.56%. Short interest has decreased by 21.7% since the company's last earnings release while the stock has drifted higher by 37.1% from its open following the earnings release to be 23.2% above its 200 day moving average of $39.90. Overall earnings estimates have been revised lower since the company's last earnings release. On Friday, September 20, 2019 there was some notable buying of 12,865 contracts of the $50.00 put expiring on Friday, September 27, 2019. Option traders are pricing in a 7.5% move on earnings and the stock has averaged a 7.1% move in recent quarters.

(CLICK HERE FOR THE CHART!)

NIO Inc. $3.04

NIO Inc. (NIO) is confirmed to report earnings at approximately 4:30 AM ET on Tuesday, September 24, 2019. Investor sentiment going into the company's earnings release has 51% expecting an earnings beat The company's guidance was for revenue of $169.00 million to $193.00 million. Short interest has increased by 25.8% since the company's last earnings release while the stock has drifted lower by 26.2% from its open following the earnings release to be 39.6% below its 200 day moving average of $5.03. On Wednesday, September 4, 2019 there was some notable buying of 40,590 contracts of the $1.50 put expiring on Friday, November 15, 2019. Option traders are pricing in a 17.1% move on earnings and the stock has averaged a 9.7% move in recent quarters.

(CLICK HERE FOR THE CHART!)

AutoZone, Inc. -

AutoZone, Inc. (AZO) is confirmed to report earnings at approximately 7:00 AM ET on Tuesday, September 24, 2019. The consensus earnings estimate is $21.64 per share on revenue of $3.94 billion and the Earnings Whisper ® number is $21.98 per share. Investor sentiment going into the company's earnings release has 62% expecting an earnings beat. Consensus estimates are for year-over-year earnings growth of 16.72% with revenue increasing by 10.71%. Short interest has increased by 23.5% since the company's last earnings release while the stock has drifted higher by 15.1% from its open following the earnings release to be 15.6% above its 200 day moving average of $1,003.22. Overall earnings estimates have been revised higher since the company's last earnings release. Option traders are pricing in a 5.8% move on earnings and the stock has averaged a 6.7% move in recent quarters.

(CLICK HERE FOR THE CHART!)

CarMax, Inc. $84.63

CarMax, Inc. (KMX) is confirmed to report earnings at approximately 7:35 AM ET on Tuesday, September 24, 2019. The consensus earnings estimate is $1.33 per share on revenue of $5.03 billion and the Earnings Whisper ® number is $1.38 per share. Investor sentiment going into the company's earnings release has 63% expecting an earnings beat. Consensus estimates are for year-over-year earnings growth of 7.26% with revenue increasing by 5.54%. Short interest has increased by 0.7% since the company's last earnings release while the stock has drifted lower by 3.6% from its open following the earnings release to be 14.9% above its 200 day moving average of $73.63. Overall earnings estimates have been revised higher since the company's last earnings release. On Friday, September 6, 2019 there was some notable buying of 1,023 contracts of the $92.50 call expiring on Friday, October 18, 2019. Option traders are pricing in a 7.2% move on earnings and the stock has averaged a 6.0% move in recent quarters.

(CLICK HERE FOR THE CHART!)

Nike Inc $86.68

Nike Inc (NKE) is confirmed to report earnings at approximately 4:15 PM ET on Tuesday, September 24, 2019. The consensus earnings estimate is $0.71 per share on revenue of $10.45 billion and the Earnings Whisper ® number is $0.76 per share. Investor sentiment going into the company's earnings release has 65% expecting an earnings beat. Consensus estimates are for year-over-year earnings growth of 5.97% with revenue increasing by 5.05%. Short interest has increased by 0.4% since the company's last earnings release while the stock has drifted higher by 3.2% from its open following the earnings release to be 5.1% above its 200 day moving average of $82.50. Overall earnings estimates have been revised lower since the company's last earnings release. On Monday, September 16, 2019 there was some notable buying of 4,646 contracts of the $84.00 call expiring on Friday, September 27, 2019. Option traders are pricing in a 5.2% move on earnings and the stock has averaged a 4.5% move in recent quarters.

(CLICK HERE FOR THE CHART!)

BlackBerry Limited $7.54

BlackBerry Limited (BB) is confirmed to report earnings at approximately 7:00 AM ET on Tuesday, September 24, 2019. The consensus estimate is for a loss of $0.01 per share and the Earnings Whisper ® number is $0.01 per share. Investor sentiment going into the company's earnings release has 32% expecting an earnings beat. Consensus estimates are for earnings to decline year-over-year by 150.00% with revenue increasing by 375.71%. Short interest has increased by 1.0% since the company's last earnings release while the stock has drifted lower by 9.2% from its open following the earnings release to be 6.9% below its 200 day moving average of $8.10. Overall earnings estimates have been revised higher since the company's last earnings release. On Tuesday, September 17, 2019 there was some notable buying of 2,012 contracts of the $8.00 call expiring on Friday, September 27, 2019. Option traders are pricing in a 9.9% move on earnings and the stock has averaged a 7.9% move in recent quarters.

(CLICK HERE FOR THE CHART!)

Rite Aid Corp. $7.40

Rite Aid Corp. (RAD) is confirmed to report earnings at approximately 7:00 AM ET on Thursday, September 26, 2019. The consensus earnings estimate is $0.08 per share on revenue of $5.42 billion and the Earnings Whisper ® number is $0.10 per share. Investor sentiment going into the company's earnings release has 50% expecting an earnings beat. Consensus estimates are for year-over-year earnings growth of 900.00% with revenue decreasing by 0.03%. Short interest has increased by 22.2% since the company's last earnings release while the stock has drifted higher by 5.1% from its open following the earnings release to be 36.4% below its 200 day moving average of $11.64. On Wednesday, September 18, 2019 there was some notable buying of 580 contracts of the $7.00 call expiring on Friday, October 18, 2019. Option traders are pricing in a 20.7% move on earnings and the stock has averaged a 20.5% move in recent quarters.

(CLICK HERE FOR THE CHART!)

Cantel Medical Corp. $85.02

Cantel Medical Corp. (CMD) is confirmed to report earnings at approximately 8:00 AM ET on Monday, September 23, 2019. The consensus earnings estimate is $0.61 per share on revenue of $238.60 million and the Earnings Whisper ® number is $0.61 per share. Investor sentiment going into the company's earnings release has 55% expecting an earnings beat. Consensus estimates are for earnings to decline year-over-year by 1.61% with revenue increasing by 4.26%. Short interest has increased by 47.7% since the company's last earnings release while the stock has drifted higher by 27.5% from its open following the earnings release to be 10.7% above its 200 day moving average of $76.78. Overall earnings estimates have been revised lower since the company's last earnings release. On Friday, September 20, 2019 there was some notable buying of 571 contracts of the $90.00 call expiring on Friday, October 18, 2019. Option traders are pricing in a 7.0% move on earnings and the stock has averaged a 6.9% move in recent quarters.

(CLICK HERE FOR THE CHART!)

Accenture Ltd. $193.09

Accenture Ltd. (ACN) is confirmed to report earnings at approximately 6:50 AM ET on Thursday, September 26, 2019. The consensus earnings estimate is $1.71 per share on revenue of $11.08 billion and the Earnings Whisper ® number is $1.74 per share. Investor sentiment going into the company's earnings release has 67% expecting an earnings beat. Consensus estimates are for year-over-year earnings growth of 8.23% with revenue increasing by 4.11%. Short interest has increased by 23.3% since the company's last earnings release while the stock has drifted higher by 8.0% from its open following the earnings release to be 11.3% above its 200 day moving average of $173.47. Overall earnings estimates have been unchanged since the company's last earnings release. On Friday, September 13, 2019 there was some notable buying of 1,279 contracts of the $115.00 put expiring on Friday, November 15, 2019. Option traders are pricing in a 4.5% move on earnings and the stock has averaged a 4.2% move in recent quarters.

(CLICK HERE FOR THE CHART!)

Uxin Limited $3.26

Uxin Limited (UXIN) is confirmed to report earnings before the market opens on Monday, September 23, 2019. The consensus estimate is for a loss of $0.09 per share. Investor sentiment going into the company's earnings release has 66% expecting an earnings beat The company's guidance was for revenue of $130.00 million to $137.00 million. Consensus estimates are for earnings to decline year-over-year by 200.00% with revenue increasing by 892.95%. The stock has drifted higher by 44.9% from its open following the earnings release to be 4.5% below its 200 day moving average of $3.41. Overall earnings estimates have been revised lower since the company's last earnings release. On Friday, September 20, 2019 there was some notable buying of 509 contracts of the $4.00 call expiring on Friday, October 18, 2019. Option traders are pricing in a 24.5% move on earnings and the stock has averaged a 10.5% move in recent quarters.

(CLICK HERE FOR THE CHART!)

DISCUSS!

What are you all watching for in this upcoming trading week?
I hope you all have a wonderful weekend and a great trading week ahead stocks.
submitted by bigbear0083 to stocks [link] [comments]

Wall Street Week Ahead for the trading week beginning September 23rd, 2019

Good Saturday morning to all of you here on StockMarket. I hope everyone on this sub made out pretty nicely in the market this past week, and is ready for the new trading week ahead.
Here is everything you need to know to get you ready for the trading week beginning September 23rd, 2019.

Week ahead: As stocks struggle to break to new highs, markets could be swayed by Fed speakers, trade - (Source)

Developments in U.S.-Chinese trade talks and the comments from a host of Fed speakers could be important for markets in the week ahead, as stocks struggle to regain highs.
The Fed in the past week cut interest rates for the second time in two months, but the latest forecasts of Fed officials showed just how divided they are on the need for future rate cuts. Five wanted deeper cuts, five didn’t want any cuts and another seven were happy with the Fed’s action.
“The market seems like it’s pretty jumpy based on what the say. i think it would flip back and forth depending on how the headlines come out,” said Tom Simons, money market economist at Jefferies. Simons said the focus will also be on the Fed’s operations in the short-term funding market, after turbulence in the overnight market in the past week temporarily sent some overnight rates sharply higher.
There are nearly a dozen Fed speakers on the calendar in the coming week, but Fed Chairman Jerome Powell is not scheduled to speak.
Trade developments could continue to cause volatility in markets. Reports Friday that Chinese agriculture officials canceled visits to farms in Montana and Nebraska sent stocks lower, for fear it signaled that talks were not making progress.
Stocks in the past week were lower, with the S&P off about 0.5% to 2,992. The index had been around 1% away from its all-time high for a few weeks.
“Tech that has been out of play and is acting faulty. it’s now turning into a headwind, and that could cause a problem for the bulls,” said Scott Redler, partner with T3Live.com. “I haven’t seen so many mixed signals in the market in quite some time.”
“It’s hard for the market to make new highs without tech. At best, it’s concerning when you see key names, like Amazon and Netflix, not just failing to lead but faltering,” he said. Netflix was down more than 8% for the week, and Amazon was off 2.6%.
Redler said it was a concern that shares of market leader Microsoft gave up its initial gains and turned negative, soon after it announced a buyback and raised its dividend. “Strength was sold instead of embraced,” he said. “That was good news. What are they going to do when bad news happens?”
Following the attacks on Saudi Aramco last week, the United Nations General Assembly in New York and meetings around it take on more importance for markets. U.S. and Saudi Arabian officials have said Iran was behind the attack, which knocked a significant amount of Saudi oil production off line. Iran has denied involvement, and Houthi rebels in Yemen have claimed responsibility.
Iran’ President Hassan Rouhani has been given a visa to travel to New York for the UN. Before the attack on Saudi Arabia last week, President Donald Trump had suggested he would speak to Rouhani but there seems little chance of that now. Oil have been highly volatile, with Brent crude futures up 7% since the attack as Saudi Arabia sought to assure markets that it would be able to bring its operations back on line.
There is some economic data that will also be important to markets. There is manufacturing PMI Monday, important after ISM manufacturing data showed a contraction in August. Durable goods will also be important on Friday, as will personal consumption data, which includes the Fed’s preferred inflation indicator, the core PCE deflator.
“What Powell said in his remarks was inflation was below his target,” said Marc Chandler, chief market strategist at Bannockburn Global Forex. “But even the core PCE deflator is expected to be 1.8, a new high for the year.” The Fed’s target inflation rate is 2%, and other inflation measures have been above that, including core CPI.
The Fed will also be in focus after problems in the overnight funding market, used by banks in need of short term cash. Rates spiked for repo, or repurchase agreements, in a chaotic two-day period Monday and Tuesday. The Fed’s target fed funds rate also moved above its target range, in an unusual move.
The market has since calmed after the Fed carried out open market operations to add liquidity to the market. On Friday, it announced three 14-day operations involving $30 billion as well as continued overnight operations of at least $75 billion each.
“I think the Fed has absolute control over short term rates. It was caught sleeping at the wheel,” said Chandler.
Powell said the Fed would monitor the market and take whatever action is needed. The market is considered the basic plumbing for financial markets, where banks who have a short-term need for cash come to fund themselves. The odd spike in rates was viewed as the result of a cash crunch, not a credit crisis.
Bond market pros have been concerned that the Fed would again see strains in the market at month end, when there’s more activity in the overnight funding market.
“It gets you further past quarter end,” said Jon Hill, rate strategist at BMO. “A 14-day pushes them further into October. I think nerves will have calmed. The fact you’ll see fed funds print clearly in the range will reassert confidence. These operations will serve as a reminder that the Fed can have absolute control the front end if and when it wants to. This is a good thing.”
The funds rate was at 1.90% Thursday, within the target rate range of 1.75% to 2%.
“They’re removing any doubt of their ability to take control of fed funds in the modern framework. They just announced $165 billion over quarter-end , and we may go bigger. They haven’t done a repo injection in 10 years,” said Hill.

This past week saw the following moves in the S&P:

(CLICK HERE FOR THE FULL S&P TREE MAP FOR THE PAST WEEK!)

Major Indices for this past week:

(CLICK HERE FOR THE MAJOR INDICES FOR THE PAST WEEK!)

Major Futures Markets as of Friday's close:

(CLICK HERE FOR THE MAJOR FUTURES INDICES AS OF FRIDAY!)

Economic Calendar for the Week Ahead:

(CLICK HERE FOR THE FULL ECONOMIC CALENDAR FOR THE WEEK AHEAD!)

Sector Performance WTD, MTD, YTD:

(CLICK HERE FOR FRIDAY'S PERFORMANCE!)
(CLICK HERE FOR THE WEEK-TO-DATE PERFORMANCE!)
(CLICK HERE FOR THE MONTH-TO-DATE PERFORMANCE!)
(CLICK HERE FOR THE 3-MONTH PERFORMANCE!)
(CLICK HERE FOR THE YEAR-TO-DATE PERFORMANCE!)
(CLICK HERE FOR THE 52-WEEK PERFORMANCE!)

Percentage Changes for the Major Indices, WTD, MTD, QTD, YTD as of Friday's close:

(CLICK HERE FOR THE CHART!)

S&P Sectors for the Past Week:

(CLICK HERE FOR THE CHART!)

Major Indices Pullback/Correction Levels as of Friday's close:

(CLICK HERE FOR THE CHART!

Major Indices Rally Levels as of Friday's close:

(CLICK HERE FOR THE CHART!)

Most Anticipated Earnings Releases for this week:

(CLICK HERE FOR THE CHART!)

Here are the upcoming IPO's for this week:

(CLICK HERE FOR THE CHART!)

Friday's Stock Analyst Upgrades & Downgrades:

(CLICK HERE FOR THE CHART LINK #1!)
(CLICK HERE FOR THE CHART LINK #2!)
(CLICK HERE FOR THE CHART LINK #3!)

S&P 500 down 23 of 29 during week after September options expiration, average loss 0.95%

The week after September options expiration week, next week, has a dreadful history of declines especially since 1990. The week after September options expiration week has been a nearly constant source of pain with only a few meaningful exceptions over the past 29 years. Substantial and across the board gains have occurred just three times: 1998, 2001, 2010 and 2016 while many more weeks were hit with sizable losses.
Full stats are in the following sea-of-red table. Average losses since 1990 are even worse; DJIA –1.02%, S&P 500 –0.95%, NASDAQ –0.90% and a sizable –1.38% for Russell 2000. End-of-Q3 portfolio restructuring is the most likely explanation for this trend as managers trim summer losers and position for the fourth quarter.
(CLICK HERE FOR THE CHART!)

October Challenging in Pre-Election Years

October often evokes fear on Wall Street as memories are stirred of crashes in 1929, 1987, the 554-point drop on October 27, 1997, back-to-back massacres in 1978 and 1979, Friday the 13th in 1989 and the 733-point drop on October 15, 2008. During the week ending October 10, 2008, Dow lost 1,874.19 points (18.2%), the worst weekly decline in our database going back to 1901, in point and percentage terms. The term “Octoberphobia” has been used to describe the phenomenon of major market drops occurring during the month. Market calamities can become a self-fulfilling prophecy, so stay on the lookout and don’t get whipsawed if it happens.
(CLICK HERE FOR THE CHART!)
Pre-election year Octobers are ranked second from last for DJIA, S&P 500 and NASDAQ while Russell 2000 is dead last with an average loss of 1.9%. Eliminating gruesome 1987 from the calculation provides only a moderate amount of relief. Should a meaningful decline materialize in October it is likely to be an excellent buying opportunity, especially for depressed technology and small-cap shares.

Where’s That September Volatility?

September is historically known as one of the worst for stocks, yet in 2019 the S&P 500 Index is up 2.7% so far amid a sea of scary headlines. Incredibly, the S&P 500 has wavered less than 0.1% from its previous close 6 of the past 10 trading sessions, as it consolidates just beneath all-time highs.
“Over the past two weeks we’ve had the European Central Bank meeting, the Federal Reserve meeting, higher inflation, a historic jump in crude oil, Middle East turmoil, trouble in the repo market, and even multiple NFL quarterbacks sustaining major injuries,” said LPL Financial Senior Market Strategist Ryan Detrick. “Yet, with all of those scary headlines, stocks are actually in the midst of one of the least volatile two-week stretches we’ve seen in years.”
We are quite encouraged by the overall change in market tone we’ve heard recently, with more cyclical names taking the baton and leading, but with the S&P 500 up near our fair value target of 3,000, we would be on the lookout for this sea of tranquility to get rougher at any time. In fact, according to historical calendars, we may need to be on high guard for the second half of September.
As shown in the LPL Chart of the Day, The Second Half of September Can Be Tricky For Stocks, later in the month of September is when we’ve seen seasonal weakness. Things have been going well for equities in the face of some worrisome headlines, but don’t get complacent, as the calendar could be one of the biggest near-term risks.
(CLICK HERE FOR THE CHART!)

The Fed Hits It Down The Middle

“History does not repeat itself, but it rhymes.” Mark Twain
As expected, the Federal Reserve’s (Fed) policy committee cut its policy rate by 25 basis points (.25%) to a target range of 1.75%–2%. This comes on the heels of the first rate cut in more than 10 years at the end of July. This cut is somewhat more controversial, however, because the overall U.S. economic data has been improving, and there’s been a tick higher in inflation.
One of the most important questions heading into this meeting was how many voting Fed members would support additional rate cuts. There were two dissenting voting members at the July rate cut, and once again there were two votes opposed to today’s cut—but unlike last time, there was also one dissenter who favored a larger 50 basis point (.50%) cut. Materials in the economic projections indicated 10 of 17 participants (which includes non-voting members) did not believe additional cuts would be needed over the remainder of the year, although evolving economic conditions could certainly lead to a shift.
As the quote from Mark Twain suggests, by looking back at history we can potentially find clues as to what might happen in the future.
Looking back at the previous two recessions (2001 and 2008), the Fed cut rates 50 basis points (.50%) to kick off the new cycle of rate cuts. We looked back at what the Fed said at the time, and policymakers didn’t foresee a recession; the larger .50% cut might have been their way of showing how worried they really were at the time. In other words, maybe the Fed knew there potentially was trouble under the surface.
Compare this with three consecutive 25 basis point (.25%) cuts in the 1995/1996 and 1998 rate cut cycles, which led to continued equity gains and avoided recessions. Given we foresee one more cut this year, could it be another three cuts of 25 basis points (.25%) and then an economic acceleration?
“Here’s the catch. When the first two cuts in a new cycle of rate cuts are only 25 basis points, this could be the Fed’s way of truly viewing the cuts as insurance,” explained LPL Financial Senior Market Strategist Ryan Detrick. “In fact, the past five cycles of cuts that started with two 25 basis point cuts saw the S&P 500 Index move higher 6 and 12 months later every single time.”
As shown in the LPL Chart of the Day, Stocks Have Historically Done Well If The First Two Fed Rate Cuts Are 25 Basis Points, the S&P 500 was up an average of 9.7% six months after the second of two 25 basis point cuts to kick off a new cycle of rate cuts. Going out a year, the S&P 500 had gained a very impressive average of 16.7%.
(CLICK HERE FOR THE CHART!)

Strong Start for September, but Second Half Could Bring Trouble

As of Friday’s close the market is well above historical average performance in September. DJIA was up nearly 3.1%, S&P 500 was up 2.8%, NASDAQ and Russell 1000 were up 2.7% while Russell 2000 was up 5.6%. Small-caps outperforming large-caps recently is not unusual and they did so again today. However, the second half of September has historically been weaker than the first half. The week after options expiration week can be treacherous with S&P 500 logging 23 weekly losses in 29 years since 1990. End-of-quarter portfolio restructuring, and window dressing can amplify the impacts of any negative headlines.
(CLICK HERE FOR THE CHART!)

Broader Transports Still Outperforming YTD

With shares of FedEx (FDX) on pace for their second worst earnings reaction day since at least 2001, the Dow Transports, an index in which FDX has a weighting of over 8% (after today's decline), is down close to 2%. Historically, the Transports have been considered a leading indicator of the economy, so the weakness in FDX, and by extension, the Dow Transports, is resulting in heightened concerns over the state of the economy. Looking at the chart below, the picture for the Transports doesn't look pretty. The timing of today's decline couldn't have been worse as it came just as the Transports were attempting to break above the highs from July, but now it just looks like the second lower high this year. Following today's declines, the Dow Transports are up 14.7% YTD which is about five percentage points behind the performance of the S&P 500.
(CLICK HERE FOR THE CHART!)
Given the changes in the US economy over time, we've been skeptical of the continued predictive ability of the Transports, but even putting that aside for a moment, a broader look at Transports shows a less pessimistic picture. The chart below shows the performance of the stocks in the S&P 1500 index on an equal-weighted basis so far in 2019. By this measure, today's decline comes after the index made a higher high, and while it's back below those former highs today, with a gain of 20.5% YTD, this broader look at transports is still outperforming the S&P 500 on a YTD basis. It may not be a great picture for this group of transport stocks, but it doesn't really look bad either.
(CLICK HERE FOR THE CHART!)

STOCK MARKET VIDEO: Stock Market Analysis Video for Week Ending September 20th, 2019

(CLICK HERE FOR THE YOUTUBE VIDEO!)

STOCK MARKET VIDEO: ShadowTrader Video Weekly 09.22.19

(CLICK HERE FOR THE YOUTUBE VIDEO!)
Here are the most notable companies (tickers) reporting earnings in this upcoming trading week ahead-
  • $MU
  • $NIO
  • $AZO
  • $KMX
  • $NKE
  • $BB
  • $RAD
  • $CMD
  • $ACN
  • $UXIN
  • $JBL
  • $INFO
  • $CAG
  • $DAVA
  • $MANU
  • $SNX
  • $FDS
  • $KBH
  • $UEPS
  • $ATU
  • $CTAS
  • $MTN
  • $AGTC
  • $WOR
  • $PIR
  • $ISR
  • $DLNG
  • $CAMP
  • $AIR
  • $FUL
  • $PRGS
  • $CMTL
  • $DYNT
  • $RBZ
(CLICK HERE FOR NEXT WEEK'S MOST NOTABLE EARNINGS RELEASES!)
(CLICK HERE FOR NEXT WEEK'S HIGHEST VOLATILITY EARNINGS RELEASES!)
(CLICK HERE FOR MOST ANTICIPATED EARNINGS RELEASES FOR THE NEXT 5 WEEKS!)
Below are some of the notable companies coming out with earnings releases this upcoming trading week ahead which includes the date/time of release & consensus estimates courtesy of Earnings Whispers:

Monday 9.23.19 Before Market Open:

(CLICK HERE FOR MONDAY'S PRE-MARKET EARNINGS TIME & ESTIMATES!)

Monday 9.23.19 After Market Close:

([CLICK HERE FOR MONDAY'S AFTER-MARKET EARNINGS TIME & ESTIMATES LINK!]())
NONE.

Tuesday 9.24.19 Before Market Open:

(CLICK HERE FOR TUESDAY'S PRE-MARKET EARNINGS TIME & ESTIMATES LINK!)

Tuesday 9.24.19 After Market Close:

(CLICK HERE FOR TUESDAY'S AFTER-MARKET EARNINGS TIME & ESTIMATES LINK!)

Wednesday 9.25.19 Before Market Open:

(CLICK HERE FOR WEDNESDAY'S PRE-MARKET EARNINGS TIME & ESTIMATES LINK!)

Wednesday 9.25.19 After Market Close:

(CLICK HERE FOR WEDNESDAY'S AFTER-MARKET EARNINGS TIME & ESTIMATES LINK!)

Thursday 9.26.19 Before Market Open:

(CLICK HERE FOR THURSDAY'S PRE-MARKET EARNINGS TIME & ESTIMATES LINK!)

Thursday 9.26.19 After Market Close:

(CLICK HERE FOR THURSDAY'S AFTER-MARKET EARNINGS TIME & ESTIMATES LINK!)

Friday 9.27.19 Before Market Open:

([CLICK HERE FOR FRIDAY'S PRE-MARKET EARNINGS TIME & ESTIMATES!]())
NONE.

Friday 9.27.19 After Market Close:

([CLICK HERE FOR FRIDAY'S AFTER-MARKET EARNINGS TIME & ESTIMATES!]())
NONE.

Micron Technology, Inc. $49.16

Micron Technology, Inc. (MU) is confirmed to report earnings at approximately 4:05 PM ET on Thursday, September 26, 2019. The consensus earnings estimate is $0.43 per share on revenue of $4.51 billion and the Earnings Whisper ® number is $0.49 per share. Investor sentiment going into the company's earnings release has 67% expecting an earnings beat The company's guidance was for earnings of $0.38 to $0.52 per share. Consensus estimates are for earnings to decline year-over-year by 87.92% with revenue decreasing by 46.56%. Short interest has decreased by 21.7% since the company's last earnings release while the stock has drifted higher by 37.1% from its open following the earnings release to be 23.2% above its 200 day moving average of $39.90. Overall earnings estimates have been revised lower since the company's last earnings release. On Friday, September 20, 2019 there was some notable buying of 12,865 contracts of the $50.00 put expiring on Friday, September 27, 2019. Option traders are pricing in a 7.5% move on earnings and the stock has averaged a 7.1% move in recent quarters.

(CLICK HERE FOR THE CHART!)

NIO Inc. $3.04

NIO Inc. (NIO) is confirmed to report earnings at approximately 4:30 AM ET on Tuesday, September 24, 2019. Investor sentiment going into the company's earnings release has 51% expecting an earnings beat The company's guidance was for revenue of $169.00 million to $193.00 million. Short interest has increased by 25.8% since the company's last earnings release while the stock has drifted lower by 26.2% from its open following the earnings release to be 39.6% below its 200 day moving average of $5.03. On Wednesday, September 4, 2019 there was some notable buying of 40,590 contracts of the $1.50 put expiring on Friday, November 15, 2019. Option traders are pricing in a 17.1% move on earnings and the stock has averaged a 9.7% move in recent quarters.

(CLICK HERE FOR THE CHART!)

AutoZone, Inc. -

AutoZone, Inc. (AZO) is confirmed to report earnings at approximately 7:00 AM ET on Tuesday, September 24, 2019. The consensus earnings estimate is $21.64 per share on revenue of $3.94 billion and the Earnings Whisper ® number is $21.98 per share. Investor sentiment going into the company's earnings release has 62% expecting an earnings beat. Consensus estimates are for year-over-year earnings growth of 16.72% with revenue increasing by 10.71%. Short interest has increased by 23.5% since the company's last earnings release while the stock has drifted higher by 15.1% from its open following the earnings release to be 15.6% above its 200 day moving average of $1,003.22. Overall earnings estimates have been revised higher since the company's last earnings release. Option traders are pricing in a 5.8% move on earnings and the stock has averaged a 6.7% move in recent quarters.

(CLICK HERE FOR THE CHART!)

CarMax, Inc. $84.63

CarMax, Inc. (KMX) is confirmed to report earnings at approximately 7:35 AM ET on Tuesday, September 24, 2019. The consensus earnings estimate is $1.33 per share on revenue of $5.03 billion and the Earnings Whisper ® number is $1.38 per share. Investor sentiment going into the company's earnings release has 63% expecting an earnings beat. Consensus estimates are for year-over-year earnings growth of 7.26% with revenue increasing by 5.54%. Short interest has increased by 0.7% since the company's last earnings release while the stock has drifted lower by 3.6% from its open following the earnings release to be 14.9% above its 200 day moving average of $73.63. Overall earnings estimates have been revised higher since the company's last earnings release. On Friday, September 6, 2019 there was some notable buying of 1,023 contracts of the $92.50 call expiring on Friday, October 18, 2019. Option traders are pricing in a 7.2% move on earnings and the stock has averaged a 6.0% move in recent quarters.

(CLICK HERE FOR THE CHART!)

Nike Inc $86.68

Nike Inc (NKE) is confirmed to report earnings at approximately 4:15 PM ET on Tuesday, September 24, 2019. The consensus earnings estimate is $0.71 per share on revenue of $10.45 billion and the Earnings Whisper ® number is $0.76 per share. Investor sentiment going into the company's earnings release has 65% expecting an earnings beat. Consensus estimates are for year-over-year earnings growth of 5.97% with revenue increasing by 5.05%. Short interest has increased by 0.4% since the company's last earnings release while the stock has drifted higher by 3.2% from its open following the earnings release to be 5.1% above its 200 day moving average of $82.50. Overall earnings estimates have been revised lower since the company's last earnings release. On Monday, September 16, 2019 there was some notable buying of 4,646 contracts of the $84.00 call expiring on Friday, September 27, 2019. Option traders are pricing in a 5.2% move on earnings and the stock has averaged a 4.5% move in recent quarters.

(CLICK HERE FOR THE CHART!)

BlackBerry Limited $7.54

BlackBerry Limited (BB) is confirmed to report earnings at approximately 7:00 AM ET on Tuesday, September 24, 2019. The consensus estimate is for a loss of $0.01 per share and the Earnings Whisper ® number is $0.01 per share. Investor sentiment going into the company's earnings release has 32% expecting an earnings beat. Consensus estimates are for earnings to decline year-over-year by 150.00% with revenue increasing by 375.71%. Short interest has increased by 1.0% since the company's last earnings release while the stock has drifted lower by 9.2% from its open following the earnings release to be 6.9% below its 200 day moving average of $8.10. Overall earnings estimates have been revised higher since the company's last earnings release. On Tuesday, September 17, 2019 there was some notable buying of 2,012 contracts of the $8.00 call expiring on Friday, September 27, 2019. Option traders are pricing in a 9.9% move on earnings and the stock has averaged a 7.9% move in recent quarters.

(CLICK HERE FOR THE CHART!)

Rite Aid Corp. $7.40

Rite Aid Corp. (RAD) is confirmed to report earnings at approximately 7:00 AM ET on Thursday, September 26, 2019. The consensus earnings estimate is $0.08 per share on revenue of $5.42 billion and the Earnings Whisper ® number is $0.10 per share. Investor sentiment going into the company's earnings release has 50% expecting an earnings beat. Consensus estimates are for year-over-year earnings growth of 900.00% with revenue decreasing by 0.03%. Short interest has increased by 22.2% since the company's last earnings release while the stock has drifted higher by 5.1% from its open following the earnings release to be 36.4% below its 200 day moving average of $11.64. On Wednesday, September 18, 2019 there was some notable buying of 580 contracts of the $7.00 call expiring on Friday, October 18, 2019. Option traders are pricing in a 20.7% move on earnings and the stock has averaged a 20.5% move in recent quarters.

(CLICK HERE FOR THE CHART!)

Cantel Medical Corp. $85.02

Cantel Medical Corp. (CMD) is confirmed to report earnings at approximately 8:00 AM ET on Monday, September 23, 2019. The consensus earnings estimate is $0.61 per share on revenue of $238.60 million and the Earnings Whisper ® number is $0.61 per share. Investor sentiment going into the company's earnings release has 55% expecting an earnings beat. Consensus estimates are for earnings to decline year-over-year by 1.61% with revenue increasing by 4.26%. Short interest has increased by 47.7% since the company's last earnings release while the stock has drifted higher by 27.5% from its open following the earnings release to be 10.7% above its 200 day moving average of $76.78. Overall earnings estimates have been revised lower since the company's last earnings release. On Friday, September 20, 2019 there was some notable buying of 571 contracts of the $90.00 call expiring on Friday, October 18, 2019. Option traders are pricing in a 7.0% move on earnings and the stock has averaged a 6.9% move in recent quarters.

(CLICK HERE FOR THE CHART!)

Accenture Ltd. $193.09

Accenture Ltd. (ACN) is confirmed to report earnings at approximately 6:50 AM ET on Thursday, September 26, 2019. The consensus earnings estimate is $1.71 per share on revenue of $11.08 billion and the Earnings Whisper ® number is $1.74 per share. Investor sentiment going into the company's earnings release has 67% expecting an earnings beat. Consensus estimates are for year-over-year earnings growth of 8.23% with revenue increasing by 4.11%. Short interest has increased by 23.3% since the company's last earnings release while the stock has drifted higher by 8.0% from its open following the earnings release to be 11.3% above its 200 day moving average of $173.47. Overall earnings estimates have been unchanged since the company's last earnings release. On Friday, September 13, 2019 there was some notable buying of 1,279 contracts of the $115.00 put expiring on Friday, November 15, 2019. Option traders are pricing in a 4.5% move on earnings and the stock has averaged a 4.2% move in recent quarters.

(CLICK HERE FOR THE CHART!)

Uxin Limited $3.26

Uxin Limited (UXIN) is confirmed to report earnings before the market opens on Monday, September 23, 2019. The consensus estimate is for a loss of $0.09 per share. Investor sentiment going into the company's earnings release has 66% expecting an earnings beat The company's guidance was for revenue of $130.00 million to $137.00 million. Consensus estimates are for earnings to decline year-over-year by 200.00% with revenue increasing by 892.95%. The stock has drifted higher by 44.9% from its open following the earnings release to be 4.5% below its 200 day moving average of $3.41. Overall earnings estimates have been revised lower since the company's last earnings release. On Friday, September 20, 2019 there was some notable buying of 509 contracts of the $4.00 call expiring on Friday, October 18, 2019. Option traders are pricing in a 24.5% move on earnings and the stock has averaged a 10.5% move in recent quarters.

(CLICK HERE FOR THE CHART!)

DISCUSS!

What are you all watching for in this upcoming trading week?
I hope you all have a wonderful weekend and a great trading week ahead StockMarket.
submitted by bigbear0083 to StockMarket [link] [comments]

Import real time currency exchange rates in Excel - YouTube Forex Rollover and Swap Currency Exchange Rates Excel 2010 - YouTube Forex Excel Trading, MetaTrader Excel How to download historical price data from Yahoo to Excel ... Forex Cross Rates Finance in Excel 2 - Import and Chart Historical Stock ... Outstanding! Exchange Rates Debut in Excel - 2274 - YouTube How to extract Nigerian exchange rates, current and ... Download Historical Exchange Rates into Excel with a Click ...

Excel then downloads the previous close, open, and current bid/ask rates for the currency pair. Clicking the button again refreshes the quotes with the most recent values. Automatically Updated Real-Time Forex in Excel. Now, here’s where we can be clever and get Excel to automatically update the exchange rates live. 1. Excel Price Feed is ideal for populating your Excel spreadsheet with live currency exchange rates. Introduction If you run an international business that deals in a variety of currencies or are simply trying to work out how much you spent on holiday then you have no doubt spent time updating a spreadsheet with the latest exchange rates. Historical Exchange Rates Get access to our expert weekly market analyses and discover how your currency has been tracking with our exchange rate tools. Ready to transfer? Register below REGISTER NOW. View twenty years of exchange rate data for over 55 currencies. Choose currency pair ... Download historical rates to excel. Use our currency converter below to download historical exchange rates. Easy and free access to historical FX rates going back 20 years. High quality and accuracy guaranteed. All our currency pairs are based on the official exchange rates from the European Central Bank. Rates are updated daily at 4:30 PM Central Eastern Time. Downloaded historical rates are ... The Historical Currency Converter is a simple way to access up to 25 years of historical exchange rates for 200+ currencies, metals, and cryptocurrencies. OANDA Rates® cover 38,000 FX currency pairs, and are easily downloadable into an Excel ready, CSV formatted file. This tool is ideal for auditors, CPAs, tax professionals, and anyone who needs accurate and authoritative foreign exchange ... This Excel spreadsheet downloads historical Forex data from the Internet. You can ask for bid, ask and mid rates for a range of historical currencies. You can use this data to backtest your trading strategies, and perform technical analysis (such as plotting the EMA, RSI or MACD). The spreadsheet is easy to use. You simply enter two three-letter currency symbols, two dates, and specify whether ... So in this post, I'm going to show you where to get free Forex historical data for Excel analysis and tailor it to suit your needs. This skill will give you more ways of analyzing the markets and extracting profitable trading patterns. Where To Get Forex Data. There are a few ways to download historical Forex data. I provide my latest finds on the Resources page. Most quality sources provide ...

[index] [5499] [20464] [26055] [21942] [2503] [27307] [11588] [4527] [26032] [15676]

Import real time currency exchange rates in Excel - YouTube

Just four months ago, the views of my podcast asked if Microsoft could add exchange rates in addition to the stock data type. Breaking news: Excel will now p... Premium Course: https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube Learn how to Import and quickly Chart historical stock p... The video demonstrates how to import real time currency exchange rates in Excel. Excel tool for Forex Trading Analysis - Duration: 4:59. myforexdashboard 43,425 views. 4:59 . Consolidate Data in Excel that has Multiple Duplicate Values On the Same Excel Worksheet - Duration: 5 ... http://www.amazon.com/Honest-Guide-Stock-Trading-Market-Beating-ebook/dp/B00IRR20V0/ In this video you will learn how to transfer historical price data from ... Get current and historical exchange rates of Naira against the major global currencies in Microsoft Excel Learn how Forex cross-rates work. 10 Websites That Will Pay You DAILY Within 24 hours! (Easy Work From Home Jobs) - Duration: 13:08. Kevin David Recommended for you Shows how to convert from one currency to another in Microsoft Excel. An explanation of how rollover and swap works in the forex market. Interest rates are based on overnight lending rates, which are then applied to leveraged forex trades. Download the Excel file that can pull historical exchange rate data right into Excel with a click. http://www.excelclout.com/historical-exchange-rates-in-exc...

http://binary-optiontrade.guzdorabve.tk