Thanks for all the upvotes and comments on the previous pieces:submitted by getmrmarket to Forex [link] [comments]
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.
Preparing for quantitative and qualitative releasesThe 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.
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 indexThe 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 reactionsThe 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.
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 factA 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 positionsOne 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 reversalsFairly 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 reversalsSometimes 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.
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 releasesAs 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 decisionsThese 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 payrollsThese 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:
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.
SurveysThere 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.
GDPGross 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.
InflationCountries 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 dataThings 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.
CommentsOften 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.
The real factor behind Forex trading is to get a money set if you take into consideration the base money will certainly raise in worth (value), in connection with the quote money. Oanda is an excellent foreign exchange broker: its charges are wonderful, as well, as it has an excellent internet trading system where you will rapidly forexrating feel comfy. Not all brokers provide a free demonstration account, some will certainly provide them when you have made a down payment, yet this is a usual function of a broker as it permits you to obtain utilized to trading on the system with digital cash before you make a down payment.submitted by One_Seaworthiness_17 to u/One_Seaworthiness_17 [link] [comments]
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.
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.
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.
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.
“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%.
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.
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.
Monday 9.23.19 Before Market Open:
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:
Tuesday 9.24.19 After Market Close:
Wednesday 9.25.19 Before Market Open:
Wednesday 9.25.19 After Market Close:
Thursday 9.26.19 Before Market Open:
Thursday 9.26.19 After Market Close:
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. (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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
I am often asked about linking Interactive Brokers quotes to Macroption calculators and to Excel in general. IB offers several ways to do that and although (or because) their documentation is very detailed, the task may be a bit overwhelming to a non-technical person.. Here is the simplest way you can get Interactive Brokers quotes into Excel, step by step (there are only three steps). TrueFX is a provider of real time forex rates between the most liquid currencies.Both current prices and bid/offer quotes are streamed as quoted by various brokers. If all you want is a very quick and uncomplicated way (three mouse clicks!) to simply get live feeds in your spreadsheet, check out the 30 seconds videos below:. Getting easily live stock prices in Excel 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. The version of Excel in Office 365 allows you to collect the exchange rate of currencies of the current day. Add Exchange Rate. The Office 365 version provides a great new feature ; Data Type. You just have to fill geographic data or financial data and Excel connects to a database to add values to the original one. If you want to add financial data to the name of a stock holder or to return ... Get stock quotes with one click in excel, and company profiles tooDont worry if you dont see the stock quote, that could be because your research type is set to either “all research books” or “thesaurus”, just click the drop-down and select “MSN Money Stock Quotes” - 2nd option from last (Excel … On June 5th, 2019 Microsoft released a feature to Office 365 that allows Excel users to pull real-time stock prices into their spreadsheets. This feature was never truly supported in Excel until now, even though many Excel users used to pull stock data from Yahoo! Finance until the capability end in 2018 (thanks Verizon!). stock-forex-API-XLS. Get stock and forex quotes from API, export them in Excel tables. Brief description: This script gets stock (& ETF) and foreign currency exchange ('forex') quotes from two different online API-s. The relevant data (eg. closing price) is exported and stored in an Ms Excel file, with the spreadsheet table ranges being ...
[index]          
This video demonstrates how you can get live price and other data for stocks and ETFs in your Excel spreadsheets. In the video, I show you how you can select yo... How to get stock quotes in excel using msn money central stock quotes excel is shown in this video. I showed How to get stock prices in excel 2007 and How to... Download the Excel spreadsheet that can automatically get stock quotes from Yahoo Finance - no VBA coding required! http://www.excelclout.com/stock-quotes-in... This video shows one way to import basic stock quote data into an Excel 2013 worksheet. Here is a solution for Mac: http://youtu.be/MtEio4-B31E This is the fast way to get some live data into excel. It's not perfect and there's a 1 minute delay but it's a good start. I wanted to get something up for ... https://www.facebook.com/FreeTutorials *Edit this no longer works due to Yahoo abruptly decommissioning their stock API. Still worth a watch if you want to l... This video is about how to get live updated stock quotes.