![]() | Thanks for all the upvotes and comments on the previous pieces: submitted by getmrmarket to Forex [link] [comments] 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 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. 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 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. Crazy reversalsSome 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. |
![]() | https://preview.redd.it/vrq329h41vs51.png?width=1000&format=png&auto=webp&s=a9cdd74e5bfd8c7ca678fcb6663d37d87bc9f7b2 submitted by benebit to CryptocurrencyICO [link] [comments] With the dramatic increase in the number of traders and investors in Canada that are using PrimeXBT, one question has been asked recently more than others which is whether PrimeXBT is safe for Canadian traders. The number of Canadian users at PrimeXBT has been growing rapidly throughout 2020 as a sign that the tools and features on the platform are opening up new opportunities for interacting in the market in more optimal ways. This guide covers whether or not PrimeXBT is safe for Canadian traders, and looks at some of the features and tools of the platform. The Canadian Market in 2020 Like much of the rest of the world, the Canadian market has seen some of the highest levels of all volatility in 2020 that have been seen in many years, or even at all throughout the history of cryptocurrency. The Canadian market has seen renewed growth following the contractions throughout 2018 and much of 2019 when the global bear market in the cryptocurrency space drove many retail investors back out of the market after the exponential growth of 2017. This has led many Canadian traders to wonder whether we are on the brink of another major bull run as was seen both in 2017 as well as 2013, and that would potentially see the price of Bitcoin driven up to the range of $50,000 or more. The Exponential Growth of PrimeXBT With the backdrop of the excitement within the global cryptocurrency market in general, and the Canadian cryptocurrency market more specifically, PrimeXBT has been perfectly positioned for exponential growth since its launch in early 2018. The platform initially launched at the start of 2018 with a waiting list of more than 150,000 traders, and this showed the interest in the platform that was present even before it came onto the market. As a result of the unique tools and features provided by PrimeXBT, it has grown exponentially over the past few years to become the world’s leading multi-asset margin trading platform and today managing up to $2 billion worth of global trade every day. What is PrimeXBT? https://preview.redd.it/iax449j91vs51.png?width=1000&format=png&auto=webp&s=24ea73d33d4f74afedf75a55b5a51967e95dea04 PrimeXBT is a margin trading-centric platform that provides high leverage trading on a wide range of cryptoassets as well as many of the world’s leading traditional assets. Traders at PrimeXBT are able to access up to 100X leverage on a wide range of cryptoassets that include BTC, ETH, XRP, LTC, and EOS. This is whilst also being able to access up to 500X leverage on a range of traditional assets like stock indices such as the S&P500 and FTSE100, forex pairs such as USD/EUR and AUD/CAD, and commodities such as gold and oil. PrimeXBT: Security Features From a security perspective, PrimeXBT is one of the leading trading platforms in the crypto market, and has built a strong reputation for being a safe and reliable platform to trade on. Much of this is as a result of the bank-grade security features that are implemented throughout PrimeXBT that include mandatory Bitcoin address whitelisting and hardware security modules with rating of FIPS PUB 140-2 Level 3 or higher. By working to add advanced security solutions throughout its platform, PrimeXBT has shown a strong commitment to protecting the funds and data of its users. PrimeXBT: Security Track Record While there are many other platforms in the cryptocurrency space that have suffered devastating hacks over the past 2 or 3 years, PrimeXBT is one of a small number of top tier platforms that have remained hack-free throughout this period. A good example of this is the Binance hack in 2019 that saw the platform lose more than $40 million of its users’ funds, and more recently the KuCoin hack where more than $150 million was lost by that platform. In contrast, PrimeXBT has never been hacked and has never been breached by hackers and as such remains as one of the most trusted platforms in the market, having a clean security track record. PrimeXBT: Excellent Customer Support In 2019, a study of the top 5 crypto margin trading platforms found that PrimeXBT has the best customer service of all 5, and also was the only platform out of the 5 to have full marks for all for metrics. These metrics were politeness, responsiveness, helpfulness, and the range of different communication channels that were available to users. By having an excellent customer support structure, PrimeXBT has ensured that its users are able to get fast and easy solutions to the problems and that there is always a direct line of communication open with the admin at the platform to be able to effectively deal with any issues that arise. Other Advantages of Using PrimeXBT PrimeXBT also provides a number of other advantages that are unique to the platform including providing the lowest fee schedule of any major cryptocurrency trading platform in the market with a low flat rate of 0.05% applied to all trades, irrespective of the size of a trade or the asset being traded. As well as this, PrimeXBT’s users can enjoy a robust trading engine that is built into the core of the PrimeXBT platform and that can execute up to 12,000 trades per second with an average trade time of less than 7.02 ms. PrimeXBT also has a unique 4-tier referral program where the traders can generate revenue streams from direct referrals, as well as indirect referrals up to 4 levels deep, with this dramatically increasing the profitability of affiliate activities, and netting the top 3 affiliates on the platform more than $1 million in 2019. In Summary PrimeXBT is a safe and well-reputed trading platform for Canadian traders and this is the reason for its exponential growth of users and volume within Canada over the past months. As well as being a safe platform to trade at, PrimeXBT also provides a range of unique tools and features to use in order to maximize profitability in the cryptocurrency and traditional asset markets. To understand more about the security features on PrimeXBT that have protected its users, check out PrimeXBT’s Security page. |
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 ... All the available MT4 trading attributes are collected from the available history and output to the CSV file. In addition, some calculated values are output as well. These are: Sequence Number. Used to keep the data in order or to re-sort it back into order. ServerCloseTime. This is Excel compatible version of the server datetime close value. MT4 account history can be exported to Excel in two different ways. The first one is to generate reports, go to HTML files, and copy manually whole text to Excel file. The second one is to use an online converter from HTML to Excel. Manually copy/paste conversion is the safest and usually the best option to avoid mistakes. YouTube - Microsoft Excel Tutorial for Beginners #1 - Overview This spreadsheet will calculate the total profits or losses (including commissions as well), your percentage of winning trades (and losers), average profit or loss per trade, average percentage profit on winners (and losers as well), risk/reward ratio, number of winners (and losers) and total profits and total losses. Forex Trading Journal Trade Insights Trading Journal. Whilst not the prettiest of designs, for a free journal it comes with a lot of benefits and features. With the Trade Insights journal you have the ability to import your trading history from a broker or via a file. Forex Forum The Global-View Forex Forum is the hub for currency trading on the web. Founded in 1996, it was the original forex forum and is still the place where forex traders around the globe come 24/7 looking for currency trading ideas, breaking forex news, fx trading rumors, fx flows and more. This is where you can find a full suite of forex trading tools, including a complete fx database ... If you’re looking for Free Forex Historical Data, you’re in the right place! Here, you’ll be able to find free forex historical data ready to be imported into your favorite application like MetaTrader, NinjaTrader, MetaStock or any other trading platform.. Since the data is delivered in .CSV format (comma separated values), you can use it in any almost any application that allows you to ... These files are well suited for backtesting trading strategies under MetaTrader 4 and MetaTrader 5 platform. Please, select: M1 (1 Minute Bar) Data. Generic ASCII. For generic use, this format allows importing M1 (1 Minute Bar) Data into any 3rd application. Please, select: M1 (1 Minute Bar) Data Tick Data. Microsoft Excel. For this file format we'll have M1 (1 Minute Bar) Data only. These ... However, as I don't know how to integrate Excel and MT4 I have to prepare orders in two stages; Firstly, calculate the position size etc in Excel, then secondly, input the details in MT4. What I would like to be able to do is code a send procedure to send the trade details to MT4 and have it open a trade, then for MT4 to report back to Excel when the trade is opened and closed. I would also ...
[index] [15378] [21995] [26538] [18239] [20924] [15203] [17792] [19394] [23954] [4665]
Learn how to manipulate live streaming data with excel in addition to placing orders directly from the excel spreadsheet. All of this can be done in R Trader Pro. For a FREE R Trader Pro Demo ... Update Smart Excel Trader V1.01. FREE WEBINAR: Forex Math Analysis Trading with Excel spreadsheets and real-time Data. Learn about our new offering in API trading. Use excel to monitor feeds, order, and positions in real time. Also, build your own strategies in excel using re... Real time forex rates in Excel form True FX. Very fast and easy. Includes real time bid and offer quotes from selected brokers. Please check the newest video... How to Build A Forex Trading Journal Using Excel Spreadsheet - Duration: 24:21. Federico Sellitti 16,446 views. 24:21 . EL MEJOR DIARIO DE TRADING QUE HE TENIDO 📖⚡ - Duration: 17:12. Oscar ... 95% Winning Forex Trading Formula - Beat The Market Maker📈 - Duration: 37:53. ... MT4: How to export your account history to Excel - Duration: 2:10. ActivTrades UK 17,741 views. 2:10. 20 Habits ... FxDialogue offers Meta Trader users a powerful Excel trading application that provides an alternative to building trading strategies. Using the calculation capacity of Microsoft Excel with real ... This demo video shows how to create an automated trading system in Excel using TraderXL for TD AMERITRADE software. Please visit www.analyzerxl.com for more ... FOREX Trading Excel Workbook... Shows main currency pairs, calculates trade values, allows input of support and resistance levels, gives colour coded warning...