Add Real-Time Stock Prices And Metrics To Excel — The ...
Add Real-Time Stock Prices And Metrics To Excel — The ...
Commodity Data and Prices in Excel - cmdtyView Excel cmdty
Market Data in Excel from TrueFX - Resources
Live Currency Rates in Excel MrExcel Message Board
Excel: easily get the latest currency exchange rates ...
Real Time Stock Prices in Excel - Risk Management Guru
How to import live forex prices into Microsoft Excel
Forex Rates: Live Currency Rates at DailyFX
Real-Time Forex Rates in Excel
Excel Price Feed - Real Time Financial Prices Add-in ...
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
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.
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.
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 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.
50 + Free & Best Selling Discounted Udemy: Business Analytics, Agile Project Management 200+ Tools with Kanban Scrum Devops , Big Data on Amazon web services (AWS), Front End Web Development , PHP MySQL & CodeIgniter Course: Complete Guide, Fundamentals of Engineering Thermodynamics and more
Business Analytics, Agile Project Management 200+ Tools with Kanban Scrum Devops , Big Data on Amazon web services (AWS), Front End Web Development , PHP MySQL & CodeIgniter Course: Complete Guide, Fundamentals of Engineering Thermodynamics
Disclaimer: None of this is financial advice. I have no idea what I'm doing. Please do your own research or you will certainly lose money. I'm not a statistician, data scientist, well-seasoned trader, or anything else that would qualify me to make statements such as the below with any weight behind them. Take them for the incoherent ramblings that they are. TL;DR at the bottom for those not interested in the details. This is a bit of a novel, sorry about that. It was mostly for getting my own thoughts organized, but if even one person reads the whole thing I will feel incredibly accomplished.
For those of you not familiar, please see the various threads on this trading system here. I can't take credit for this system, all glory goes to ParallaxFX! I wanted to see how effective this system was at H1 for a couple of reasons: 1) My current broker is TD Ameritrade - their Forex minimum is a mini lot, and I don't feel comfortable enough yet with the risk to trade mini lots on the higher timeframes(i.e. wider pip swings) that ParallaxFX's system uses, so I wanted to see if I could scale it down. 2) I'm fairly impatient, so I don't like to wait days and days with my capital tied up just to see if a trade is going to win or lose. This does mean it requires more active attention since you are checking for setups once an hour instead of once a day or every 4-6 hours, but the upside is that you trade more often this way so you end up winning or losing faster and moving onto the next trade. Spread does eat more of the trade this way, but I'll cover this in my data below - it ends up not being a problem. I looked at data from 6/11 to 7/3 on all pairs with a reasonable spread(pairs listed at bottom above the TL;DR). So this represents about 3-4 weeks' worth of trading. I used mark(mid) price charts. Spreadsheet link is below for anyone that's interested.
I'm pretty much using ParallaxFX's system textbook, but since there are a few options in his writeups, I'll include all the discretionary points here:
I'm using the stop entry version - so I wait for the price to trade beyond the confirmation candle(in the direction of my trade) before entering. I don't have any data to support this decision, but I've always preferred this method over retracement-limit entries. Maybe I just like the feeling of a higher winrate even though there can be greater R:R using a limit entry. Variety is the spice of life.
I put my stop loss right at the opposite edge of the confirmation candle. NOT at the edge of the 2-candle pattern that makes up the system. I'll get into this more below - not enough trades are saved to justify the wider stops. (Wider stop means less $ per pip won, assuming you still only risk 1%).
All my profit/loss statistics are based on a 1% risk per trade. Because 1 is real easy to multiply.
There are definitely some questionable trades in here, but I tried to make it as mechanical as possible for evaluation purposes. They do fit the definitions of the system, which is why I included them. You could probably improve the winrate by being more discretionary about your trades by looking at support/resistance or other techniques.
I didn't use MBB much for either entering trades, or as support/resistance indicators. Again, trying to be pretty mechanical here just for data collection purposes. Plus, we all make bad trading decisions now and then, so let's call it even.
As stated in the title, this is for H1 only. These results may very well not play out for other time frames - who knows, it may not even work on H1 starting this Monday. Forex is an unpredictable place.
I collected data to show efficacy of taking profit at three different levels: -61.8%, -100% and -161.8% fib levels described in the system using the passive trade management method(set it and forget it). I'll have more below about moving up stops and taking off portions of a position.
And now for the fun. Results!
Total Trades: 241
TP at -61.8%: 177 out of 241: 73.44%
TP at -100%: 156 out of 241: 64.73%
TP at -161.8%: 121 out of 241: 50.20%
Adjusted Proft % (takes spread into account):
TP at -61.8%: 5.22%
TP at -100%: 23.55%
TP at -161.8%: 29.14%
As you can see, a higher target ended up with higher profit despite a much lower winrate. This is partially just how things work out with profit targets in general, but there's an additional point to consider in our case: the spread. Since we are trading on a lower timeframe, there is less overall price movement and thus the spread takes up a much larger percentage of the trade than it would if you were trading H4, Daily or Weekly charts. You can see exactly how much it accounts for each trade in my spreadsheet if you're interested. TDA does not have the best spreads, so you could probably improve these results with another broker. EDIT: I grabbed typical spreads from other brokers, and turns out while TDA is pretty competitive on majors, their minors/crosses are awful! IG beats them by 20-40% and Oanda beats them 30-60%! Using IG spreads for calculations increased profits considerably (another 5% on top) and Oanda spreads increased profits massively (another 15%!). Definitely going to be considering another broker than TDA for this strategy. Plus that'll allow me to trade micro-lots, so I can be more granular(and thus accurate) with my position sizing and compounding.
A Note on Spread
As you can see in the data, there were scenarios where the spread was 80% of the overall size of the trade(the size of the confirmation candle that you draw your fibonacci retracements over), which would obviously cut heavily into your profits. Removing any trades where the spread is more than 50% of the trade width improved profits slightly without removing many trades, but this is almost certainly just coincidence on a small sample size. Going below 40% and even down to 30% starts to cut out a lot of trades for the less-common pairs, but doesn't actually change overall profits at all(~1% either way). However, digging all the way down to 25% starts to really make some movement. Profit at the -161.8% TP level jumps up to 37.94% if you filter out anything with a spread that is more than 25% of the trade width! And this even keeps the sample size fairly large at 187 total trades. You can get your profits all the way up to 48.43% at the -161.8% TP level if you filter all the way down to only trades where spread is less than 15% of the trade width, however your sample size gets much smaller at that point(108 trades) so I'm not sure I would trust that as being accurate in the long term. Overall based on this data, I'm going to only take trades where the spread is less than 25% of the trade width. This may bias my trades more towards the majors, which would mean a lot more correlated trades as well(more on correlation below), but I think it is a reasonable precaution regardless.
Time of Day
Time of day had an interesting effect on trades. In a totally predictable fashion, a vast majority of setups occurred during the London and New York sessions: 5am-12pm Eastern. However, there was one outlier where there were many setups on the 11PM bar - and the winrate was about the same as the big hours in the London session. No idea why this hour in particular - anyone have any insight? That's smack in the middle of the Tokyo/Sydney overlap, not at the open or close of either. On many of the hour slices I have a feeling I'm just dealing with small number statistics here since I didn't have a lot of data when breaking it down by individual hours. But here it is anyway - for all TP levels, these three things showed up(all in Eastern time):
7pm-4am: Fewer setups, but winrate high.
5am-6am: Lots of setups, but but winrate low.
12pm-3pm Medium number of setups, but winrate low.
I don't have any reason to think these timeframes would maintain this behavior over the long term. They're almost certainly meaningless. EDIT: When you de-dup highly correlated trades, the number of trades in these timeframes really drops, so from this data there is no reason to think these timeframes would be any different than any others in terms of winrate. That being said, these time frames work out for me pretty well because I typically sleep 12am-7am Eastern time. So I automatically avoid the 5am-6am timeframe, and I'm awake for the majority of this system's setups.
Moving stops up to breakeven
This section goes against everything I know and have ever heard about trade management. Please someone find something wrong with my data. I'd love for someone to check my formulas, but I realize that's a pretty insane time commitment to ask of a bunch of strangers. Anyways. What I found was that for these trades moving stops up...basically at all...actually reduced the overall profitability. One of the data points I collected while charting was where the price retraced back to after hitting a certain milestone. i.e. once the price hit the -61.8% profit level, how far back did it retrace before hitting the -100% profit level(if at all)? And same goes for the -100% profit level - how far back did it retrace before hitting the -161.8% profit level(if at all)? Well, some complex excel formulas later and here's what the results appear to be. Emphasis on appears because I honestly don't believe it. I must have done something wrong here, but I've gone over it a hundred times and I can't find anything out of place.
Moving SL up to 0% when the price hits -61.8%, TP at -100%
Adjusted Proft % (takes spread into account): 5.36%
Taking half position off at -61.8%, moving SL up to 0%, TP remaining half at -100%
Adjusted Proft % (takes spread into account): -1.01% (yes, a net loss)
Now, you might think exactly what I did when looking at these numbers: oof, the spread killed us there right? Because even when you move your SL to 0%, you still end up paying the spread, so it's not truly "breakeven". And because we are trading on a lower timeframe, the spread can be pretty hefty right? Well even when I manually modified the data so that the spread wasn't subtracted(i.e. "Breakeven" was truly +/- 0), things don't look a whole lot better, and still way worse than the passive trade management method of leaving your stops in place and letting it run. And that isn't even a realistic scenario because to adjust out the spread you'd have to move your stoploss inside the candle edge by at least the spread amount, meaning it would almost certainly be triggered more often than in the data I collected(which was purely based on the fib levels and mark price). Regardless, here are the numbers for that scenario:
Moving SL up to 0% when the price hits -61.8%, TP at -100%
Winrate(breakeven doesn't count as a win): 46.4%
Adjusted Proft % (takes spread into account): 17.97%
Taking half position off at -61.8%, moving SL up to 0%, TP remaining half at -100%
Winrate(breakeven doesn't count as a win): 65.97%
Adjusted Proft % (takes spread into account): 11.60%
From a literal standpoint, what I see behind this behavior is that 44 of the 69 breakeven trades(65%!) ended up being profitable to -100% after retracing deeply(but not to the original SL level), which greatly helped offset the purely losing trades better than the partial profit taken at -61.8%. And 36 went all the way back to -161.8% after a deep retracement without hitting the original SL. Anyone have any insight into this? Is this a problem with just not enough data? It seems like enough trades that a pattern should emerge, but again I'm no expert. I also briefly looked at moving stops to other lower levels (78.6%, 61.8%, 50%, 38.2%, 23.6%), but that didn't improve things any. No hard data to share as I only took a quick look - and I still might have done something wrong overall. The data is there to infer other strategies if anyone would like to dig in deep(more explanation on the spreadsheet below). I didn't do other combinations because the formulas got pretty complicated and I had already answered all the questions I was looking to answer.
2-Candle vs Confirmation Candle Stops
Another interesting point is that the original system has the SL level(for stop entries) just at the outer edge of the 2-candle pattern that makes up the system. Out of pure laziness, I set up my stops just based on the confirmation candle. And as it turns out, that is much a much better way to go about it. Of the 60 purely losing trades, only 9 of them(15%) would go on to be winners with stops on the 2-candle formation. Certainly not enough to justify the extra loss and/or reduced profits you are exposing yourself to in every single other trade by setting a wider SL. Oddly, in every single scenario where the wider stop did save the trade, it ended up going all the way to the -161.8% profit level. Still, not nearly worth it.
As I've said many times now, I'm really not qualified to be doing an analysis like this. This section in particular. Looking at shared currency among the pairs traded, 74 of the trades are correlated. Quite a large group, but it makes sense considering the sort of moves we're looking for with this system. This means you are opening yourself up to more risk if you were to trade on every signal since you are technically trading with the same underlying sentiment on each different pair. For example, GBP/USD and AUD/USD moving together almost certainly means it's due to USD moving both pairs, rather than GBP and AUD both moving the same size and direction coincidentally at the same time. So if you were to trade both signals, you would very likely win or lose both trades - meaning you are actually risking double what you'd normally risk(unless you halve both positions which can be a good option, and is discussed in ParallaxFX's posts and in various other places that go over pair correlation. I won't go into detail about those strategies here). Interestingly though, 17 of those apparently correlated trades ended up with different wins/losses. Also, looking only at trades that were correlated, winrate is 83%/70%/55% (for the three TP levels). Does this give some indication that the same signal on multiple pairs means the signal is stronger? That there's some strong underlying sentiment driving it? Or is it just a matter of too small a sample size? The winrate isn't really much higher than the overall winrates, so that makes me doubt it is statistically significant. One more funny tidbit: EUCAD netted the lowest overall winrate: 30% to even the -61.8% TP level on 10 trades. Seems like that is just a coincidence and not enough data, but dang that's a sucky losing streak. EDIT: WOW I spent some time removing correlated trades manually and it changed the results quite a bit. Some thoughts on this below the results. These numbers also include the other "What I will trade" filters. I added a new worksheet to my data to show what I ended up picking.
Total Trades: 75
TP at -61.8%: 84.00%
TP at -100%: 73.33%
TP at -161.8%: 60.00%
Moving SL up to 0% when the price hits -61.8%, TP at -100%: 53.33%
Taking half position off at -61.8%, moving SL up to 0%, TP remaining half at -100%: 53.33% (yes, oddly the exact same winrate. but different trades/profits)
Adjusted Proft % (takes spread into account):
TP at -61.8%: 18.13%
TP at -100%: 26.20%
TP at -161.8%: 34.01%
Moving SL up to 0% when the price hits -61.8%, TP at -100%: 19.20%
Taking half position off at -61.8%, moving SL up to 0%, TP remaining half at -100%: 17.29%
To do this, I removed correlated trades - typically by choosing those whose spread had a lower % of the trade width since that's objective and something I can see ahead of time. Obviously I'd like to only keep the winning trades, but I won't know that during the trade. This did reduce the overall sample size down to a level that I wouldn't otherwise consider to be big enough, but since the results are generally consistent with the overall dataset, I'm not going to worry about it too much. I may also use more discretionary methods(support/resistance, quality of indecision/confirmation candles, news/sentiment for the pairs involved, etc) to filter out correlated trades in the future. But as I've said before I'm going for a pretty mechanical system. This brought the 3 TP levels and even the breakeven strategies much closer together in overall profit. It muted the profit from the high R:R strategies and boosted the profit from the low R:R strategies. This tells me pair correlation was skewing my data quite a bit, so I'm glad I dug in a little deeper. Fortunately my original conclusion to use the -161.8 TP level with static stops is still the winner by a good bit, so it doesn't end up changing my actions. There were a few times where MANY (6-8) correlated pairs all came up at the same time, so it'd be a crapshoot to an extent. And the data showed this - often then won/lost together, but sometimes they did not. As an arbitrary rule, the more correlations, the more trades I did end up taking(and thus risking). For example if there were 3-5 correlations, I might take the 2 "best" trades given my criteria above. 5+ setups and I might take the best 3 trades, even if the pairs are somewhat correlated. I have no true data to back this up, but to illustrate using one example: if AUD/JPY, AUD/USD, CAD/JPY, USD/CAD all set up at the same time (as they did, along with a few other pairs on 6/19/20 9:00 AM), can you really say that those are all the same underlying movement? There are correlations between the different correlations, and trying to filter for that seems rough. Although maybe this is a known thing, I'm still pretty green to Forex - someone please enlighten me if so! I might have to look into this more statistically, but it would be pretty complex to analyze quantitatively, so for now I'm going with my gut and just taking a few of the "best" trades out of the handful. Overall, I'm really glad I went further on this. The boosting of the B/E strategies makes me trust my calculations on those more since they aren't so far from the passive management like they were with the raw data, and that really had me wondering what I did wrong.
What I will trade
Putting all this together, I am going to attempt to trade the following(demo for a bit to make sure I have the hang of it, then for keeps):
"System Details" I described above.
TP at -161.8%
Static SL at opposite side of confirmation candle - I won't move stops up to breakeven.
Trade only 7am-11am and 4pm-11pm signals.
Nothing where spread is more than 25% of trade width.
Looking at the data for these rules, test results are:
Adjusted Proft % (takes spread into account): 47.43%
I'll be sure to let everyone know how it goes!
Other Technical Details
ATR is only slightly elevated in this date range from historical levels, so this should fairly closely represent reality even after the COVID volatility leaves the scalpers sad and alone.
The sample size is much too small for anything really meaningful when you slice by hour or pair. I wasn't particularly looking to test a specific pair here - just the system overall as if you were going to trade it on all pairs with a reasonable spread.
Here's the spreadsheet for anyone that'd like it. (EDIT: Updated some of the setups from the last few days that have fully played out now. I also noticed a few typos, but nothing major that would change the overall outcomes. Regardless, I am currently reviewing every trade to ensure they are accurate.UPDATE: Finally all done. Very few corrections, no change to results.) I have some explanatory notes below to help everyone else understand the spiraled labyrinth of a mind that put the spreadsheet together.
I'm on the East Coast in the US, so the timestamps are Eastern time.
Time stamp is from the confirmation candle, not the indecision candle. So 7am would mean the indecision candle was 6:00-6:59 and the confirmation candle is 7:00-7:59 and you'd put in your order at 8:00.
I found a couple AM/PM typos as I was reviewing the data, so let me know if a trade doesn't make sense and I'll correct it.
Insanely detailed spreadsheet notes
For you real nerds out there. Here's an explanation of what each column means:
Pair - duh
Date/Time - Eastern time, confirmation candle as stated above
Win to -61.8%? - whether the trade made it to the -61.8% TP level before it hit the original SL.
Win to -100%? - whether the trade made it to the -100% TP level before it hit the original SL.
Win to -161.8%? - whether the trade made it to the -161.8% TP level before it hit the original SL.
Retracement level between -61.8% and -100% - how deep the price retraced after hitting -61.8%, but before hitting -100%. Be careful to look for the negative signs, it's easy to mix them up. Using the fib% levels defined in ParallaxFX's original thread. A plain hyphen "-" means it did not retrace, but rather went straight through -61.8% to -100%. Positive 100 means it hit the original SL.
Retracement level between -100% and -161.8% - how deep the price retraced after hitting -100%, but before hitting -161.8%. Be careful to look for the negative signs, it's easy to mix them up. Using the fib% levels defined in ParallaxFX's original thread. A plain hyphen "-" means it did not retrace, but rather went straight through -100% to -161.8%. Positive 100 means it hit the original SL.
Trade Width(Pips) - the size of the confirmation candle, and thus the "width" of your trade on which to determine position size, draw fib levels, etc.
Loser saved by 2 candle stop? - for all losing trades, whether or not the 2-candle stop loss would have saved the trade and how far it ended up getting if so. "No" means it didn't save it, N/A means it wasn't a losing trade so it's not relevant.
Spread(ThinkorSwim) - these are typical spreads for these pairs on ToS.
Spread % of Width - How big is the spread compared to the trade width? Not used in any calculations, but interesting nonetheless.
True Risk(Trade Width + Spread) - I set my SL at the opposite side of the confirmation candle knowing that I'm actually exposing myself to slightly more risk because of the spread(stop order = market order when submitted, so you pay the spread). So this tells you how many pips you are actually risking despite the Trade Width. I prefer this over setting the stop inside from the edge of the candle because some pairs have a wide spread that would mess with the system overall. But also many, many of these trades retraced very nearly to the edge of the confirmation candle, before ending up nicely profitable. If you keep your risk per trade at 1%, you're talking a true risk of, at most, 1.25% (in worst-case scenarios with the spread being 25% of the trade width as I am going with above).
Win or Loss in %(1% risk) including spread TP -61.8% - not going to go into huge detail, see the spreadsheet for calculations if you want. But, in a nutshell, if the trade was a win to 61.8%, it returns a positive # based on 61.8% of the trade width, minus the spread. Otherwise, it returns the True Risk as a negative. Both normalized to the 1% risk you started with.
Win or Loss in %(1% risk) including spread TP -100% - same as the last, but 100% of Trade Width.
Win or Loss in %(1% risk) including spread TP -161.8% - same as the last, but 161.8% of Trade Width.
Win or Loss in %(1% risk) including spread TP -100%, and move SL to breakeven at 61.8% - uses the retracement level columns to calculate profit/loss the same as the last few columns, but assuming you moved SL to 0% fib level after price hit -61.8%. Then full TP at 100%.
Win or Loss in %(1% risk) including spread take off half of position at -61.8%, move SL to breakeven, TP 100% - uses the retracement level columns to calculate profit/loss the same as the last few columns, but assuming you took of half the position and moved SL to 0% fib level after price hit -61.8%. Then TP the remaining half at 100%.
Overall Growth(-161.8% TP, 1% Risk) - pretty straightforward. Assuming you risked 1% on each trade, what the overall growth level would be chronologically(spreadsheet is sorted by date).
Based on the reasonable rules I discovered in this backtest:
Date range: 6/11-7/3
Adjusted Proft % (takes spread into account): 47.43%
Demo Trading Results
Since this post, I started demo trading this system assuming a 5k capital base and risking ~1% per trade. I've added the details to my spreadsheet for anyone interested. The results are pretty similar to the backtest when you consider real-life conditions/timing are a bit different. I missed some trades due to life(work, out of the house, etc), so that brought my total # of trades and thus overall profit down, but the winrate is nearly identical. I also closed a few trades early due to various reasons(not liking the price action, seeing support/resistance emerge, etc). A quick note is that TD's paper trade system fills at the mid price for both stop and limit orders, so I had to subtract the spread from the raw trade values to get the true profit/loss amount for each trade. I'm heading out of town next week, then after that it'll be time to take this sucker live!
Date range: 7/9-7/30
Adjusted Proft % (takes spread into account): 20.73%
Starting Balance: $5,000
Ending Balance: $6,036.51
Live Trading Results
I started live-trading this system on 8/10, and almost immediately had a string of losses much longer than either my backtest or demo period. Murphy's law huh? Anyways, that has me spooked so I'm doing a longer backtest before I start risking more real money. It's going to take me a little while due to the volume of trades, but I'll likely make a new post once I feel comfortable with that and start live trading again.
10 Secrets The Trading Industry Doesn’t Want You To Know About
Today’s lesson goes to be somewhat controversial and should ruffle some feathers. I shall blow wide open and debunk tons of the knowledge you've got presumably been exposed to the present far in your trading journey. The average trader is out there walking through a confusing and conflicting maze of data from a spread of sources including; blogs, forums, broker websites, books, e-books, courses and YouTube videos. With of these learning resources available there's naturally getting to be some excellent and a few very bad information, but actually , there just isn’t how for many aspiring traders to understand what to concentrate to, who to concentrate to, or what information is useful and what information is non-beneficial. I’m not getting to pretend that there's how for an aspiring trader to filter this giant sea of data composed by of these resources and mentors out there, because there simply isn’t. knowledgeable trader with 10,000 hours of experience might stand an opportunity of deciding the great from the bad and therefore the valid from the invalid. However, you, the beginner or intermediate trader simply won’t possess that filtering ability yet. Becoming ‘Non-Average’ As traders, we concede to our instinctive feelings of social trustworthiness supported what we see and listen to , often to our extreme detriment. we frequently tend to require a leap of religion with our mentors and have a habit of taking things said to us at face value. we would like to hold close information that resonates with us and is sensible to us, especially if it’s delivered by a well-known source that we've come to understand and trust. The ‘average trader’s brain’ is usually trying to find a shortcut due to the overwhelming desire to form money and be free. The brain wants to urge a winning result immediately with the smallest amount amount of effort possible. If you would like to ever make it as a professional trader or investor, I suggest you are doing everything you'll to avoid thinking with the ‘average trader’s brain‘ and begin being ‘non-average’. meaning becoming far more aware, thinking outside the box more and questioning and filtering the knowledge you read and watch. most significantly , slowing everything all down! This now begs the apparent question…how does one even know what I’m close to write during this lesson is actually valid and factual? How are you able to really be sure? the reality is unless you've got followed me and my posts on this blog for an extended time and know me and know my work, then you can’t really make certain , and that i don’t expect you to easily believe it at face value. If you would like to return back and re-read this lesson during a few weeks, or a couple of months, or a couple of years, after you work out that i'm somebody worth taking note of about trading OR that i'm somebody not worth taking note of about trading, then so be it. So with a degree of healthy skepticism, I ask you to think about the below list of eye-opening secrets that professional traders and therefore the trading industry, don’t want you to understand about or understand. I hope it helps… Visit : توصيات الذهب اليوم FOREX isn’t the sole market the Professionals trade The FX market is large , with billions of dollars per day changing hands. It can cause you to great money if you recognize what you’re doing OR it can send you broke if you don’t. It’s a really popular market to trade globally, BUT it’s not the sole market the professional’s trade and it’s not always the simplest market to trade either. A note on leverage: The brokers and platform providers want you to trade FX on high leverage because the profit margins are very high for them. However, if you trade FX on lower leverage, the profit margins shrink dramatically for them. once you trade FX, start brooding about what can fail rather than just brooding about what can go right. I suggest avoiding stupidly high leverage like 400 to 1, as this will be very dangerous for you if the market moves quickly or experiences a price gap and your stop-loss orders aren’t executed at the worth you set. A more sensible leverage level would be 100 to 1 or 200 to 1, but any higher seems crazy. (Using an excessive amount of leverage is what wiped tons of traders out during Swiss Bank Crisis in 2015, The Brexit choose 2016 and therefore the Currency flash crash in early 2019). Broaden your view: Going forward, it'll serve you well in your trading career to start out watching a spread of worldwide markets including FX, Stock Indicies and Commodities. additionally to FX, I personally trade GOLD (XAUUSD), S&P500 Index USA, the SPI200 Index Australia, and therefore the Hang Seng Index Hong Kong , and sometimes individual stocks on various global exchanges. In short, there's more to the trading world than simply FX. I discuss the foremost popular markets I trade this lesson here. Day trading isn’t what Pro trading really is The internet is crammed with marketing trying to convince folks that the definition of a trader may be a one that spends all day actively trading in and out of the market on a brief term basis, all whilst living the life-style of a Wall St millionaire. there's a significant agenda within the industry to push this story to the masses, it's been relentless for many years . I am yet to satisfy one successful day trader who is consistent over the future and that i have almost 25,000 students and 250,000 readers on this blog. i'm not saying there isn’t a couple of out there, but 99.9% of the people that do this sort of trading or attempt to live up to the standard day trader stereotype are getting to fail and perhaps even harm themselves financially or mentally. Watching a screen all day and searching for trades constantly is that the like a compulsive gambler playing roulette during a casino. The successful traders i do know of (myself included) are watching higher time frames and longer time horizons (minimum 4-hour chart timeframes and predominantly daily chart time frames). they need no restriction on how long they're looking to carry a trade for and that they tend to let the trades find them. The professionals i do know , don't day trade, they are doing not watch screens all day, they are doing not search for trades constantly. they're going to typically fall under the category of a swing trader, trend trader or position trader. The obvious paradox and conflicting reality within the ‘day trader story’ is blatantly obvious. How does a trader who is consistently watching a screen and constantly trading have time to enjoy his life and live the lifestyle? They chose to trade as a profession to possess a life, they didn’t choose it to observe a screen 24/5. Here are some points to think about that employment against the so-called ‘ day trader’: The shorter the time-frame the more noise and random price movement there's , thus increasing your chance of simply being stopped out of the trade. Your ‘trading edge’ features a higher chance of yielding a result for you if you’re not trading within the intraday noise. The same trading edge doesn't work or produce an equivalent results on a 5 min chart compared to a Daily chart. Commissions and spreads churn your account, therefore the more you trade the more you lose in broker platform costs. (I will mention this below) Risk-Reward ratios aren't relative on shorter and longer time frames. Statistical average volatility across different time periods also as natural market dynamics play an enormous role during this . there's much more weight behind higher time frames than lower timeframes. Great trades take time because the market moves slower than most of the people ever anticipate. Trading from the upper timeframes and holding trades for extended time periods will provide you with greater opportunities to ascertain trades mature into big winners. However, shorter timeframes don’t provide you with this same opportunity fairly often .
Forex Signals Reddit: top providers review (part 1)
Forex Signals - TOP Best Services. Checked!
To invest in the financial markets, we must acquire good tools that help us carry out our operations in the best possible way. In this sense, we always talk about the importance of brokers, however, signal systems must also be taken into account. The platforms that offer signals to invest in forex provide us with alerts that will help us in a significant way to be able to carry out successful operations. For this reason, we are going to tell you about the importance of these alerts in relation to the trading we carry out, because, without a doubt, this type of system will provide us with very good information to invest at the right time and in the best assets in the different markets. financial Within this context, we will focus on Forex signals, since it is the most important market in the world, since in it, multiple transactions are carried out on a daily basis, hence the importance of having an alert system that offers us all the necessary data to invest in currencies. Also, as we all already know, cryptocurrencies have become a very popular alternative to investing in traditional currencies. Therefore, some trading services/tools have emerged that help us to carry out successful operations in this particular market. In the following points, we will detail everything you need to know to start operating in the financial markets using trading signals: what are signals, how do they work, because they are a very powerful help, etc. Let's go there!
What are Forex Trading Signals?
https://preview.redd.it/vjdnt1qrpny51.jpg?width=640&format=pjpg&auto=webp&s=bc541fc996701e5b4dd940abed610b59456a5625 Before explaining the importance of Forex signals, let's start by making a small note so that we know what exactly these alerts are. Thus, we will know that the signals on the currency market are received by traders to know all the information that concerns Forex, both for assets and for the market itself. These alerts allow us to know the movements that occur in the Forex market and the changes that occur in the different currency pairs. But the great advantage that this type of system gives us is that they provide us with the necessary information, to know when is the right time to carry out our investments.
In other words, through these signals, we will know the opportunities that are presented in the market and we will be able to carry out operations that can become quite profitable.
Profitability is precisely another of the fundamental aspects that must be taken into account when we talk about Forex signals since the vast majority of these alerts offer fairly reliable data on assets. Similarly, these signals can also provide us with recommendations or advice to make our operations more successful.
»Purpose: predict movements to carry out Profitable Operations
In short, Forex signal systems aim to predict the behavior that the different assets that are in the market will present and this is achieved thanks to new technologies, the creation of specialized software, and of course, the work of financial experts. In addition, it must also be borne in mind that the reliability of these alerts largely lies in the fact that they are prepared by financial professionals. So they turn out to be a perfect tool so that our investments can bring us a greater number of benefits.
The best signal services today
We are going to tell you about the 3 main alert system services that we currently have on the market. There are many more, but I can assure these are not scams and are reliable. Of course, not 100% of trades will be a winner, so please make sure you apply proper money management and risk management system.
1. 1000pipbuilder (top choice)
Fast track your success and follow the high-performance Forex signals from 1000pip Builder. These Forex signals are rated 5 stars on Investing.com, so you can follow every signal with confidence. All signals are sent by a professional trader with over 10 years investment experience. This is a unique opportunity to see with your own eyes how a professional Forex trader trades the markets. The 1000pip Builder Membership is ordinarily a signal service for Forex trading. You will get all the facts you need to successfully comply with the trading signals, set your stop loss and take earnings as well as additional techniques and techniques! You will get easy to use trading indicators for Forex Trades, including your entry, stop loss and take profit. Overall, the earnings target per months is 350 Pips, depending on your funding this can be a high profit per month! (In fact, there is by no means a guarantee, but the past months had been all between 600 – 1000 Pips). >>>Know more about 1000pipbuilder Your 1000pip builder membership gives you all in hand you want to start trading Forex with success. Read the directions and wait for the first signals. You can trade them inside your demo account first, so you can take a look at the performance before you make investments real money! Features:
Forex signals sent by email and SMS
Entry price, take profit and stop loss provided
Suitable for all time zones (signals sent over 24 hours)
Digital Derivatives Markets (DDMarkets) have been providing trade alert offerings since May 2014 - fully documenting their change ideas in an open and transparent manner. September 2020 performance report for DD Markets. Their manner is simple: carry out extensive research, share their evaluation and then deliver a trading sign when triggered. Once issued, daily updates on the trade are despatched to members via email. It's essential to note that DDMarkets do not tolerate floating in an open drawdown in an effort to earnings at any cost - a common method used by less professional providers to 'fudge' performance statistics. Verified Statistics: Not independently verified. Price: plans from $74.40 per month. Year Founded: 2014 Suitable for Beginners: Yes, (includes handy to follow trade analysis) VISIT -------
If you are looking or a forex signal service with a reliable (and profitable) music record you can't go previous Joel Kruger and the team at JKonFX. Trading performance file for JKonFX. Joel has delivered a reputable +59.18% journal performance for 2016, imparting real-time technical and fundamental insights, in an extremely obvious manner, to their 30,000+ subscriber base. Considered a low-frequency trader, alerts are only a small phase of the overall JKonFX subscription. If you're searching for hundreds of signals, you may want to consider other options. Verified Statistics: Not independently verified. Price: plans from $30 per month. Year Founded: 2014 Suitable for Beginners: Yes, (includes convenient to follow videos updates). VISIT
The importance of signals to invest in Forex
Once we have known what Forex signals are, we must comment on the importance of these alerts in relation to our operations. As we have already told you in the previous paragraph, having a system of signals to be able to invest is quite advantageous, since, through these alerts, we will obtain quality information so that our operations end up being a true success.
»Use of signals for beginners and experts
In this sense, we have to say that one of the main advantages of Forex signals is that they can be used by both beginners and trading professionals. As many as others can benefit from using a trading signal system because the more information and resources we have in our hands. The greater probability of success we will have. Let's see how beginners and experts can take advantage of alerts:
Beginners: for inexperienced these alerts become even more important since they will thus have an additional tool that will guide them to carry out all operations in the Forex market.
Professionals: In the same way, professionals are also recommended to make use of these alerts, so they have adequate information to continue bringing their investments to fruition.
Now that we know that both beginners and experts can use forex signals to invest, let's see what other advantages they have.
When we dedicate ourselves to working in the financial world, none of us can spend 24 hours in front of the computer waiting to perform the perfect operation, it is impossible. That is why Forex signals are important, because, in order to carry out our investments, all we will have to do is wait for those signals to arrive, be attentive to all the alerts we receive, and thus, operate at the right time according to the opportunities that have arisen. It is fantastic to have a tool like this one that makes our work easier in this regard.
»Carry out profitable Forex operations
These signals are also important, because the vast majority of them are usually quite profitable, for this reason, we must get an alert system that provides us with accurate information so that our operations can bring us great benefits. But in addition, these Forex signals have an added value and that is that they are very easy to understand, therefore, we will have a very useful tool at hand that will not be complicated and will end up being a very beneficial weapon for us.
»Decision support analysis
A system of currency market signals is also very important because it will help us to make our subsequent decisions. We cannot forget that, to carry out any type of operation in this market, previously, we must meditate well and know the exact moment when we will know that our investments are going to bring us profits . Therefore, all the information provided by these alerts will be a fantastic basis for future operations that we are going to carry out.
»Trading Signals made by professionals
Finally, we have to recall the idea that these signals are made by the best professionals. Financial experts who know perfectly how to analyze the movements that occur in the market and changes in prices. Hence the importance of alerts, since they are very reliable and are presented as a necessary tool to operate in Forex and that our operations are as profitable as possible.
What should a signal provider be like?
https://preview.redd.it/j0ne51jypny51.png?width=640&format=png&auto=webp&s=5578ff4c42bd63d5b6950fc6401a5be94b97aa7f As you have seen, Forex signal systems are really important for our operations to bring us many benefits. For this reason, at present, there are multiple platforms that offer us these financial services so that investing in currencies is very simple and fast. Before telling you about the main services that we currently have available in the market, it is recommended that you know what are the main characteristics that a good signal provider should have, so that, at the time of your choice, you are clear that you have selected one of the best systems.
»Must send us information on the main currency pairs
In this sense, one of the first things we have to comment on is that a good signal provider, at a minimum, must send us alerts that offer us information about the 6 main currencies, in this case, we refer to the euro, dollar, The pound, the yen, the Swiss franc, and the Canadian dollar. Of course, the data you provide us will be related to the pairs that make up all these currencies. Although we can also find systems that offer us information about other minorities, but as we have said, at a minimum, we must know these 6.
»Trading tools to operate better
Likewise, signal providers must also provide us with a large number of tools so that we can learn more about the Forex market.
We refer, for example, to technical analysis above all, which will help us to develop our own strategies to be able to operate in this market.
These analyzes are always prepared by professionals and study, mainly, the assets that we have available to invest.
»Different Forex signals reception channels
They must also make available to us different ways through which they will send us the Forex signals, the usual thing is that we can acquire them through the platform's website, or by a text message and even through our email. In addition, it is recommended that the signal system we choose sends us a large number of alerts throughout the day, in order to have a wide range of possibilities.
»Free account and customer service
Other aspects that we must take into account to choose a good signal provider is whether we have the option of receiving, for a limited time, alerts for free or the profitability of the signals they emit to us. Similarly, a final aspect that we must emphasize is that a good signal system must also have excellent customer service, which is available to us 24 hours a day and that we can contact them at through an email, a phone number, or a live chat, for greater immediacy. Well, having said all this, in our last section we are going to tell you which are the best services currently on the market. That is, the most suitable Forex signal platforms to be able to work with them and carry out good operations. In this case, we will talk about ForexPro Signals, 365 Signals and Binary Signals.
Forex Signals Reddit: conclusion
To be able to invest properly in the Forex market, it is convenient that we get a signal system that provides us with all the necessary information about this market. It must be remembered that Forex is a very volatile market and therefore, many movements tend to occur quickly. Asset prices can change in a matter of seconds, hence the importance of having a system that helps us analyze the market and thus know, what is the right time for us to start operating. Therefore, although there are currently many signal systems that can offer us good services, the three that we have mentioned above are the ones that are best valued by users, which is why they are the best signal providers that we can choose to carry out. our investments. Most of these alerts are quite profitable and in addition, these systems usually emit a large number of signals per day with full guarantees. For all this, SignalsForexPro, Signals365, or SignalsBinary are presented as fundamental tools so that we can obtain a greater number of benefits when we carry out our operations in the currency market.
Excel Price Feed is an Add-in that includes 100+ new Excel formulas for live, historical, and fundamental market data.
Markets include stocks, stock indices, stock options, mutual funds, ETFs, forex, commodities, and cryptocurrencies.
Learn More and download the plugin on Excel Price Feed page. Please note that you should have both subscriptions to use this plugin with our data: from EOD Historical Data and from Excel Price Feed. Our subscriptions do not include add-in licensing and it should be ordered separately.
Creating a blog couldn’t be easier and yet more complicated in 2020. There are so many different things to think about, and yet so many different platforms you can use to streamline the process. Understandably you’ll already have an idea of what you want to write about, I, unfortunately, can’t help you with that, but what I can do is show you how you can set up a killer blog that will drive readers to your website. We’ll take you through what you’ll need to get started, our five steps to setting your blog up, the best blogging platforms to use, how to get your blog discovered, and the do’s and don’ts of blogging. But first, we need to establish what type of blog you want to set up.
What type of blog?
Firstly you’ll want to have a goal in mind. What are you aiming to achieve through your blog? Do you want to pull in more users to your sales pages by writing about your brand, to increase its publicity? Do you want to build a blog that promotes brands and products from other companies? Or do you just want to set up a blog documenting your travels around the world? In order to pick the right software for you, you’ll want to have a grasp before you start of how big this blog is going to be, whether you’re going to monetize it, and what type of blog it’s going to become. For example, if you’re planning on building an affiliate blogging programme, where you promote other brand’s products and call readers to action to but the products, you’ll be writing a lot of content and will benefit from having a more comprehensive blogging system with lots of plugins to promote sales. But if you’re looking to just set up a personal, or a personal brand blog talking about yourself and your brand, you may not perhaps need as many comprehensive features as you would if you were building an affiliate blog. You may also want to build an online portfolio of your work, which could require an entirely different piece of blogging kit, as opposed to the traditional blog that hosts articles and journals.
What you’ll need to get started.
There are 3 key things you’ll need to get up and running.
A blogging platform.
After you’ve identified the type of blog you want to set up, plus whether you’re going to make money from it, you’ll then need to pick a blogging platform tailored to your needs. Many people chose to operate on WordPress as it is one of the most comprehensive blogging systems going, but they forget platforms like Wix and Squarespace that are great for both helping you save and make money and are great options for those who are less tech-savvy and are new to the blogging game. Plus if you’re blogging for business, you might want to think about using LinkedIn for your business blog. We’ll go into more detail on what blogging platforms are best for your needs shortly, but make sure to keep in mind your objectives and technical experience when choosing the right platform for you.
A hosting platform.
Every website needs a web host to store their website’s information on the internet. A web host is an online service provider that will store your website’s information on one of its online servers. This will put your blog out there to the world. The best web hosts will perform a variety of functions for you, for example, Wix is an all-in-one package that will host your website for you, allow you to register a domain name, and has easy to use website design tools to help you start your blog. Web hosting can be expensive though so make sure you pick the best value for money host that can cater to the amount of traffic you have running through your website. Check out our post on the 11 best hosting providers. [Insert blog link here]
A domain name.
I’m sure by now you already know what sort of blog you want to set up, whether that’s a travel, blog, a blog accompanying your online store, or perhaps an affiliate marketing product review blog. You’ll have a niche and an idea and now all you need is a name. Every website online has what’s called a domain name. It’s included in the website address at the top of your search bar, for example, our domain name is www.digitalsupermarket.com. You’ll need to register a domain name after you purchase a hosting plan, to enable customers to find your site quickly and easily. One good tip is to find a hosting platform like Bluehost or GoDaddy that will provide you with a free domain name when you register for one of their web hosting plans as domain registration can be fairly pricey. Pick a great domain name that is easy for customers to read and type into Google so they can find it easier online. TOP TIP: To increase your blog’s search engine ranking, and to help more people find you on Google, try to pick a domain name that has either a .com or .co.uk ending. These domains often rank a lot higher in Google searches than .org’s, .net’s, and .info’s, and for that reason can be slightly more expensive, yet can help boost your site’s reach and credibility.
The Best Blogging Platforms For You.
There are a wealth of platforms out there catering to all your blogging or online portfolio needs. We have listed some of the main ones below shedding some light on what needs they service and why they might be a great option for you.
WordPress - The best software to give you full customisation.
WordPress is perhaps one of the most renowned blogging platforms in the world, running approximately 35% of the internet. It’s favoured highly by professional bloggers because it gives you total freedom to do whatever you want with your blog. WordPress can help you build your blog using one if its search engine optimised themes, you can customise using its drag and drop website builder tool to create a stunning blog. What’s more, is you’ll be able to use its professional blogging service to post your content online and take advantage of the hundreds of third party app plugins, you can integrate into your blog, to improve automation, add new features, and drive traffic to your site. The only downside of WordPress is that it can be quite technical and can take some time getting used to, but once you’ve got the hang of things, you’ll have great control over everything on your webpage. Pros: Cons:
Domain name registration
Tons of third-party plugins and apps
Technical and can take some getting used to
Not the best if you’re not tech-savvy or are just starting out.
Wix - Best for monetizing your site.
Wix is probably the most streamlined and easiest blog providers. It’s so simple and easy to use, it’s therefore great for anyone just starting out in the blogging world. You can customise one of its stunning templates with Wix’s drag and drop editor, and then upload blog posts to your site by slotting in pictures, gifs, social media buttons, sidebars, and other widgets that will help your blog stand out. One of the coolest features about Wix is its marketplace integration, where you can install a whole variety of third-party applications to your blog to provide your users with greater features and usability. Wix is the perfect all-in-one blogging solution to help you easily build a platform to amplify your business to the world, helping you to make more money, but it can also save you a lot of money as it’s cost-efficient plans roll up, web hosting, blog posting, and domain registration all into one product! Check out our Wix review and our comparison of Wix and Squarespace for a deep dive into Wix’s main blogging features. [Insert link here] Pros: Cons:
Streamlined and easy to use blogging software
Includes as a package, web building tools, domain registration, and web hosting
Tons of third-party plugins and apps on the Wix marketplace
Great platform to help make money and save money on its reasonably priced subscription plans
Don’t get the same full control as you see with WordPress
Locked into using Wix’s templates.
Squarespace - Best for creating visually stunning blogs.
Squarespace is very similar to Wix, in that it is an all-in-one web building and blogging platform that can help you build a blog you can monetize efficiently. It sets itself aside though through its better design and customisation features, making it one of the best platforms on the marketing if you’re looking to design a visually aesthetic blog. I’d recommend using this platform if you are a business operating in some sort of design, arts, or culinary industry. Although it offers minimal template options, Squarespace’s templates are works of art and offer you great customization when building your blog. Plus Squarespace offers a great blogging tool that lets you schedule posts and customize your blog to suit more mobile audiences. Pros: Cons:
Streamlined and easy to use blogging software
Can build a visually stunning blog on Squarespace with its streamlined tools
Excellent blogging features
All-in-one web host, domain registrar, and web builder
Can’t add third-party applications on Squarespace
LinkedIn - Best for blogging businesses.
Aside from setting up a blog on your own site, corporate entities can use LinkedIn to enhance and amplify their presence online. LinkedIn has more than 575 million users, most of whom are professionals and members of corporate conglomerates, and you can use this social platform to target some of the most influential people in the world. If you’re blogging about business this is the perfect platform to use a pre-existing community of people to enhance your social standing. You’ll then be able to build connections and followers on your profile who can easily share your blog on their platform through a couple of simple clicks. Pros: Cons:
Utilise LinkedIn’s pre-existing community of business people to amplify your brand
Target corporate directors and influential people directly through LinkedIn
Check out what people are looking at on LinkedIn and tailor your content to that market
Again you are confined within what LinkedIn’s platform will let you do, it’s not your site and you don’t have full customisation
Instagram - Best for the Artists.
Instagram is one of the biggest blogging sites in the world and without realising it, we are all technically bloggers in some way with our Instagram accounts, right? Ultimately for professional use, it is great for building a portfolio that has some form of visual or graphic eye-catching media around it. Instagram lets you post videos, photos, boomerangs, even write a blog in the photo’s caption if you wanted to! Best of all, Instagram is free, and you can use its business software to link up your online store, to drag users away from your profile, using its product tagging features, and land them in your online checkouts. Our top tip for using Instagram is to post regularly and keep on the theme of your blog. Don’t go off-piste as you’re followers will catch on quickly and unfollow you. And with 1 billion people using the platform each day, it is a great way to gain people’s attention and build your brand’s presence online. Pros: Cons:
Best for the creatives.
Totally free and easy to use interface.
Access to a pre-existing community of people.
Online selling capabilities.
Again you are confined within what Instagram’s platform will let you do, it’s not your site and you don’t have full customisation
The Do’s And Don’ts Of Blogging
Here are a couple of top tips to bear in mind when building your blog to help you create an awesome, lead driven platform.
Don’t use complicated language too soon.
With that in mind, do include language that your target audience will understand. But remember they are still here to learn, so don’t drop people in at the deep end right away by using complex jargon off the bat. Define terms and spell it out in layman’s terms for people at the outset, and as the post goes on, then introduce more complex writing. Introducing technical jargon at the start of your posts is an instant turn off for most readers.
Don’t waffle - Keep it succinct.
People want to get to the punchline now. 43% of people admit to skimming through blogs to get to the information they need, meaning to get your blogging site converting leads, you need to engage the reader early on and offer information succinctly throughout your post. Plus don’t make your blog too long. Depending on what you’re writing, a lot of people will see large volumes of text and will switch off immediately. There is no set limit for what a good and bad amount of text is, that’s something you’ll have to figure out per your industry, but from my experience, the shorter, the better.
Don’t make headlines too long.
Also ensure that your headline is not more than 60 characters long. If it gets too long it won’t rank well in search engines and people just won’t want to read it. Check out this headline analysis tool which will analyse the effectiveness of your proposed headlines.
Don’t plagiarise or use credited images.
Copying other people’s work is lazy and can land you in a lot of hot water in extreme cases if you breach a copyright regulation. But it’s also just unfair on the person who has worked hard or been creative to write that work. The same goes for images, people need to make a living from the content and photos they’re taking so don’t steal that off them.
Do write killer headlines.
People are like goldfish. You only have about 3 seconds to get their attention. That’s why it is important to write catchy, funny, and enticing headlines to draw your reader in. One good way to do it is to use the “How To” and “10 Best” strategies. These sorts of titles telling people ‘How to set up a blog’ or ‘the ten best web hosting platforms’ are search engine optimised, lead winning titles that rank highly in Google searches. Try them out and see!
Do post regularly.
The key to creating a great blog that builds leads is posting regularly. Although it is not the best idea to post regularly. Ideally, you want to post 3-4 times a week to get the best influx of traffic to your site. You’ll also want to check out when’s best to post for your target audience, for example, if you’re in the FOREX market, you’ll want to post your blogs perhaps at 8 AM, before the markets open when city workers are on their staring at their phones on their morning commuter trains to the city.
Do share on social media.
Share your content far and wide on your social platforms. Everyone is on social media these days and its outreach is simply phenomenal. That’s why you should always share your posts to your social channels to get greater traffic on your website, and include share buttons all-around your blog to invite your readers to share your articles too!
Do use SEO keywords to drive more traffic.
In a nutshell, SEO keywords are the phrases people put into search engines when they are looking for information on a certain subject. They are how you get found on your website. Depending on what you are writing about, there is always a set of keywords relating to that topic that you can implement, to help you show up higher in people’s google searches. For example, people might regularly search in google, ‘what is the best compost for growing sunflowers?’ When you come to writing about growing sunflowers in your blog, you might want to use these words or incorporate this question into your blog somewhere, to help you rank higher on Google.
Do use call’s to action to take your readers to the next step.
If you don’t challenge your reader at the end of your blog to follow you on Instagram, or check out your sales pages, you’ll never get the leads or sales you are looking for. With that in mind, build compelling calls to action at the end of each of your posts, to pull readers into taking the next step. Check out our post on landing pages to see a couple of cool ways on how to implement calls to action on your site [insert link here].
Do identify a target audience.
People will often tell you to write as though you were in the shoes of the person you’re looking to bring to your website, but it’s true! Identify what type of people you’re writing to, for instance, if you’re writing a business blog about FOREX trading, you’ll write with potential traders in mind who have one eye on the stock market and the other on your blog. Or if you’re a wedding florist, you’ll set your portfolio up to target those people looking to get married in the next year.
Leads, Sales, Results.
Blogging is one of the most influential marketing strategies in the world and the best bloggers can reap some awesome rewards for producing some truly awesome content. It is fairly straightforward to get started and we advise if you’re a small business, or someone with minimal blogging experience, to try out Wix or Squarespace first before you jump into using more technical platforms like WordPress. Once you’re up and running remember our top tips on what to do and what to avoid when writing your blog. Plus don’t forget to think about optimising and adding useful applications to your site to help you build and grow your content. Check out these 39 awesome blogging tools you can use to drive greater traffic to your site! Found this article useful? Make sure you share it with your friends on Facebook and Twitter and let us know in the comments if you have any other useful blogging tips.
So here it is, three more days and October begins, which marks one year of trading for me. I figured I would contribute to the forum and share some of my experience, a little about me, and what I've learned so far. Whoever wants to listen, that's great. This might get long so buckle up.. Three years ago, I was visiting Toronto. I don't get out much, but my roommate at the time travels there occasionally. He asked everyone at our place if we wanted to come along for a weekend. My roommate has an uncle that lives there and we didn't have to worry about a hotel because his uncle owns a small house that's unlived in which we could stay at. I was the only one to go with. Anyways, we walk around the city, seeing the sights and whatnot. My friend says to me "where next?" "I don't know, you're the tour guide" "We can go check out Bay Street" "what's 'Bay Street?'" "It's like the Canadian Wall street! If you haven't seen it you gotta see it!" Walking along Bay, I admire all the nice buildings and architecture, everything seems larger than life to me. I love things like that. The huge granite facades with intricate designs and towering pillars to make you think, How the fuck did they make that? My attention pivots to a man walking on the sidewalk opposite us. His gait stood out among everyone, he walked with such a purpose.. He laughed into the cell phone to his ear. In the elbow-shoving city environment, he moved with a stride that exuded a power which not only commanded respect, but assumed it. I bet HE can get a text back, hell he's probably got girls waiting on him. This dude was dressed to kill, a navy suit that you could just tell from across the street was way out of my budget, it was a nice fucking suit. I want that. His life, across the street, seemed a world a way from my own. I've worn a suit maybe twice in my life. For my first communion, it was too big for me, I was eleven or whatever so who gives a shit, right? I'm positive I looked ridiculous. The other time? I can't remember. I want that. I want the suit. I want the wealth, the independence.I want the respect and power, and I don't give a shit what anyone thinks about it. Cue self doubt. Well, He's probably some rich banker's son. That's a world you're born into. I don't know shit about it. \sigh* keep walking..* A year later, I'm visiting my parents at their house, they live an hour away from my place. My dad is back from Tennessee, his engineering job was laying people off and he got canned... Or he saw the end was near and just left... I don't know, hard to pay attention to the guy honestly because he kind of just drones on and on. ("Wait, so your mom lives in Michigan, but your dad moved to Tennessee... for a job?" Yea man, I don't fucking know, not going to touch on that one.) The whole project was a shit show that was doomed to never get done, the way he tells it. And he's obviously jaded from multiple similar experiences at other life-sucking engineer jobs. My mom is a retired nurse practitioner who no longer works because of her illness. I ask him what he's doing for work now and he tells me he trades stocks from home. I didn't even know you could do that. I didn't know "trading" was a thing. I thought you just invest and hope for the best. "Oh that's cool, how much money do you need to do that?" "Ehh, most say you need at least $25,000 as a minimum" "Oh... guess I can't do that..." Six months later, I get a call and it's my dad. We talk a little about whatever. Off topic, he starts asking if I'm happy doing what I'm doing (I was a painter, commercial and residential) I tell him yes but it's kind of a pain in the ass and I don't see it as a long term thing. Then he gets around to asking if I'd like to come work with him. He basically pitches it to me. I'm not one to be sold on something, I'm always skeptical. So I ask all the questions that any rational person would ask and he just swats them away with reassuring phrases. He was real confident about it. But basically he says for this to work, I have to quit my job and move back home so he can teach me how to trade and be by my side so I don't do anything stupid. "My Name, you can make so much money." I say that I can't raise the $25,000 because I'm not far above just living paycheck to paycheck. "I can help you out with that." Wow, okay, well... let me think about it. My "maybe" very soon turned into a "definitely." So over the next six months, I continue to work my day job painting, and I try to save up what I could for the transition (it wasn't a whole lot, I sucked at saving. I was great at spending though!). My dad gives me a book on day trading (which I will mention later) and I teach myself what I can about the stock market using Investopedia. Also in the meantime, my dad sends me encouraging emails. He tells me to think of an annual income I would like to make as a trader, and used "more than $100,000 but less than a million" as a guideline. He tells me about stocks that he traded that day or just ones that moved and describes the basic price action and the prices to buy and sell at. Basically saying "if you bought X amount of shares here and sold it at X price here, you could make a quick 500 bucks!" I then use a trading sim to trade those symbols and try to emulate what he says. Piece of cake. ;) Wow, that's way more than what I make in a day. He tells me not to tell anyone about my trading because most people just think it's gambling. "Don't tell your Mom either." He says most people who try this fail because they don't know how to stop out and take a loss. He talks about how every day he was in a popular chatroom, some noob would say something like, "Hey guys, I bought at X price (high of day or thereabout), my account is down 80% .. uhh I'm waiting for it to come back to my entry price.. what do I do??" Well shit, I'm not that fucking dumb. If that's all it takes to make it is to buy low, sell high, and always respect a stop then I'll be fantastic. By the end of September, I was very determined. I had been looking forward everyday to quitting my painting job because while it used to be something I loved, it was just sucking the life out of me at this point. Especially working commercial, you just get worked like a dog. I wasn't living up to my potential with that job and I felt awful for it every minute of every day. I knew that I needed a job where I could use my brain instead of slaving my body to fulfill someone else's dream. "Someone's gotta put gas in the boss's boat" That's a line my buddy once said that he probably doesn't know sticks with me to this day. It ain't me. So now it was October 2018, and I'm back living with Mom n' Pops. I was so determined that on my last day of work I gave away all of my painting tools to my buddy like, "here, I don't need this shit." Moving out of my rental was easy because I don't own much, 'can't take it with ya.' Excited for the future I now spend my days bundled up in winter wear in the cold air of our hoarder-like basement with a space heater at my feet. My laptop connected to a TV monitor, I'm looking at stocks next to my dad and his screens in his cluttered corner. Our Trading Dungeon. I don't trade any money, (I wasn't aware of any real-time sim programs) I just watch and learn from my dad. Now you've got to keep in mind, and look at a chart of the S&P, this is right at the beginning of Oct '18, I came in right at the market top. Right at the start of the shit-show. For the next three or four weeks, I watch my dad pretty much scratch on every trade, taking small loss after small loss, and cursing under his breath at the screen. Click. "dammit." Click. "shit." Click. Click. "you fuck." Click. This gets really fucking annoying as time goes on, for weeks, and I get this attitude like ugh, just let me do it. I'll make us some fucking money. So I convince him to let me start trading live. I didn't know anything about brokers so I set up an account using his broker, which was Fidelity. It was a pain and I had to jump through a lot of hoops to be able to day trade with this broker. I actually had to make a joint account with my dad as I couldn't get approved for margin because my credit score is shit (never owned a credit card) and my net worth, not much. Anyways, they straight up discourage day trading and I get all kinds of warning messages with big red letters that made me shit myself like oooaaahhh what the fuck did I do now. Did I forget to close a position?? Did I fat finger an order? Am I now in debt for thousands of dollars to Fidelity?? They're going to come after me like they came after Madoff. Even after you are approved for PDT you still get these warning messages in your account. Some would say if I didn't comply with "whatever rule" they'd even suspend my account for 60 days. It was ridiculous, hard to describe because it doesn't make sense, and it took the support guy on the phone a good 20 minutes to explain it to me. Basically I got the answer "yea it's all good, you did nothing wrong. As long as you have the cash in your account to cover whatever the trade balance was" So I just kept getting these warnings that I had to ignore everyday. I hate Fidelity. My fist day trading, I made a few so-so trades and then I got impatient. I saw YECO breaking out and I chased, soon realized I chased, so I got out. -$500. Shit, I have to make that back, I don't want my dad to see this. Got back in. Shit. -$400. So my first day trading, I lost $900. My dumbass was using market orders so that sure didn't help. I reeled the risk back and traded more proper position size for a while, but the commissions for a round trip are $10, so taking six trades per day, I'm losing $60 at a minimum on top of my losing trades. Quickly I realized I didn't know what the hell I was doing. What about my dad? Does HE know? One day, in the trading dungeon, I was frustrated with the experience I'd been having and just feeling lost overall. I asked him. "So, are you consistently profitable?" "mmm... I do alright." "Yea but like, are you consistently profitable over time?" ......................... "I do alright." Silence. "Do you know any consistently profitable traders?" "Well the one who wrote that book I gave you, Tina Turner.. umm and there's Ross Cameron" ...................... "So you don't know any consistently profitable traders, personally.. People who are not trying to sell you something?" "no." ................... Holy fucking shit, what did this idiot get me into. He can't even say it to my face and admit it. This entire life decision, quitting my job, leaving my rental, moving from my city to back home, giving shit away, it all relied on that. I was supposed to be an apprentice to a consistently profitable day trader who trades for a living. It was so assumed, that I never even thought to ask! Why would you tell your son to quit his job for something that you yourself cannot do? Is this all a scam? Did my dad get sold a DREAM? Did I buy into some kind of ponzi scheme? How many of those winning trades he showed me did he actually take?Are there ANY consistently profitable DAY TRADERS who TRADE FOR A LIVING?Why do 90% fail? Is it because the other 10% are scamming the rest in some way? Completely lost, I just had no clue what was what. If I was going to succeed at this, if it was even possible to succeed at this, it was entirely up to me. I had to figure it out. I still remember the feeling like an overwhelming, crushing weight on me as it all sunk in. This is going to be a big deal.. I'm not the type to give up though. In that moment, I said to myself, I'm going to fucking win at this. I don't know if this is possible, but I'm going to find out. I cannot say with certainty that I will succeed, but no matter what, I will not give up. I'm going to give all of myself to this. I will find the truth. It was a deep moment for me. I don't like getting on my soapbox, but when I said those things, I meant it. I really, really meant it. I still do, and I still will. Now it might seem like I'm being hard on my dad. He has done a lot for me and I am very grateful for that. We're sarcastic as hell to each other, I love the bastard. Hell, I wouldn't have the opportunity to trade at all if not for him. But maybe you can also understand how overwhelmed I felt at that time. Not on purpose, of course he means well. But I am not a trusting person at all and I was willing to put trust into him after all the convincing and was very disappointed when I witnessed the reality of the situation. I would have structured this transition to trading differently, you don't just quit your job and start trading. Nobody was there to tell me that! I was told quite the opposite. I'm glad it happened anyway, so fuck it. I heard Kevin O'Leary once say, "If I knew in the beginning how difficult starting a business was, I don't know that I ever would've started." This applies very much to my experience. So what did I do? Well like everyone I read and read and Googled and Youtube'd my ass off. I sure as hell didn't pay for a course because I didn't have the money and I'm like 99% sure I would be disappointed by whatever they were teaching as pretty much everything can be found online or in books for cheap or free. Also I discovered Thinkorswim and I used that to sim trade in real-time for three months. This is way the hell different than going on a sim at 5x speed and just clicking a few buy and sell buttons. Lol, useless. When you sim trade in real-time you're forced to have a routine, and you're forced to experience missing trades with no chance to rewind or skip the boring parts. That's a step up because you're "in it". I also traded real money too, made some, lost more than I made. went back to sim. Traded live again, made some but lost more, fell back to PDT. Dad fronted me more cash. This has happened a few times. He's dug me out of some holes because he believes in me. I'm fortunate. Oh yeah, about that book my dad gave me. It's called A Beginner's Guide to Day Trading Online by Toni Turner. This book... is shit. This was supposed to be my framework for how to trade and I swear it's like literally nothing in this book fucking works lol. I could tell this pretty early on, intuitively, just by looking at charts. It's basically a buy-the-breakout type strategy, if you want to call it a strategy. No real methodology to anything just vague crap and showing you cherry-picked charts with entries that are way too late. With experience in the markets you will eventually come to find that MOST BREAKOUTS FAIL. It talks about support/resistance lines and describes them as, "picture throwing a ball down at the floor, it bounces up and then it bounces down off the ceiling, then back up." So many asinine assumptions. These ideas are a text book way of how to trade like dumb money. Don't get me wrong, these trades can work but you need to be able to identify the setups which are more probable and identify reasons not to take others. So I basically had to un-learn all that shit. Present day, I have a routine in place. I'm out of the dungeon and trade by myself in my room. I trade with a discount broker that is catered to day traders and doesn't rape me on commissions. My mornings have a framework for analyzing the news and economic events of the particular day, I journal so that I can recognize what I'm doing right and where I need to improve. I record my screens for later review to improve my tape reading skills. I am actually tracking my trades now and doing backtesting in equities as well as forex. I'm not a fast reader but I do read a lot, as much as I can. So far I have read about 17-18 books on trading and psychology. I've definitely got a lot more skilled at trading. As of yet I am not net profitable. Writing that sounds like selling myself short though, honestly. Because a lot of my trades are very good and are executed well. I have talent. However, lesser quality trades and trades which are inappropriately sized/ attempted too many times bring down that P/L. I'm not the type of trader to ignore a stop, I'm more the trader that just widdles their account down with small losses. I trade live because at this point, sim has lost its value, live trading is the ultimate teacher. So I do trade live but I just don't go big like I did before, I keep it small. I could show you trades that I did great on and make people think I'm killing it but I really just don't need the validation. I don't care, I'm real about it. I just want to get better. I don't need people to think I'm a genius, I'm just trying to make some money. Psychologically, to be honest with you, I currently feel beaten down and exhausted. I put a lot of energy into this, and sometimes I work myself physically sick, it's happened multiple times. About once a week, usually Saturday, I get a headache that lasts all day. My body's stress rebound mechanism you might call it. Getting over one of those sick periods now, which is why I barely even traded this week. I know I missed a lot of volatility this week and some A+ setups but I really just don't give a shit lol. I just currently don't have the mental capital, I think anyone who's been day trading every day for a year or more can understand what I mean by that. I'm still being productive though. Again, I'm not here to present an image of some badass trader, just keeping it real. To give something 100% day after day while receiving so much resistance, it takes a toll on you. So a break is necessary to avoid making bad trading decisions. That being said, I'm progressing more and more and eliminating those lesser quality trades and identifying my bad habits. I take steps to control those habits and strengthen my good habits such as having a solid routine, doing review and market research, taking profits at the right times, etc. So maybe I can give some advice to some that are new to day trading, those who are feeling lost, or just in general thinking "...What the fuck..." I thought that every night for the first 6 months lol. First of all, manage expectations. If you read my story of how I came to be a trader, you can see I had a false impression of trading in many aspects. Give yourself a realistic time horizon to how progress should be made. Do not set a monetary goal for yourself, or any time-based goal that is measured in your P/L. If you tell yourself, "I want to make X per day, X per week, or X per year" you're setting yourself up to feel like shit every single day when it's clear as the blue sky that you won't reach that goal anytime soon. As a matter of fact, it will appear you are moving further AWAY from that goal if you just focus on your P/L, which brings me to my next point. You will lose money. In the beginning, most likely, you will lose money. I did it, you'll do it, the greatest Paul Tudor Jones did it. Trading is a skill that needs to be developed, and it is a process. Just look at it as paying your tuition to the market. Sim is fine but don't assume you have acquired this skill until you are adept at trading real money. So when you do make that leap, just trade small. Just survive. Trade small. get the experience. Protect your capital. To reach break even on your bottom line is a huge accomplishment. In many ways, experience and screen time are the secret sauce. Have a routine. This is very important. I actually will probably make a more in-depth post in the future about this if people want it. When I first started, I was overwhelmed with the feeling "What the fuck am I supposed to DO?" I felt lost. There's no boss to tell you how to be productive or how to find the right stocks, which is mostly a blessing, but a curse for new traders. All that shit you see, don't believe all that bullshit. You know what I'm talking about. The bragposting, the clickbait Youtube videos, the ads preying on you. "I made X amount of money in a day and I'm fucking 19 lolz look at my Lamborghini" It's all a gimmick to sell you the dream. It's designed to poke right at your insecurities, that's marketing at it's finest. As for the bragposting on forums honestly, who cares. And I'm not pointing fingers on this forum, just any trading forum in general. They are never adding anything of value to the community in their posts. They never say this is how I did it. No, they just want you to think they're a genius. I can show you my $900 day trading the shit out of TSLA, but that doesn't tell the whole story. Gamblers never show you when they lose, you might never hear from those guys again because behind the scenes, they over-leveraged themselves and blew up. Some may actually be consistently profitable and the trades are 100% legit. That's fantastic. But again, I don't care, and you shouldn't either. You shouldn't compare yourself to others. "Everyone's a genius in a bull market" Here's the thing.. Markets change. Edges disappear. Trading strategies were made by traders who traded during times when everything they did worked. Buy all the breakouts? Sure! It's the fucking tech bubble! Everything works! I'm sure all those typical setups used to work fantastically at some point in time. But the more people realize them, the less effective they are. SOMEONE has to be losing money on the opposite side of a winning trade, and who's willing to do that when the trade is so obvious? That being said, some things are obvious AND still work. Technical analysis works... sometimes. The caveat to that is, filters. You need to, in some way, filter out certain setups from others. For example, you could say, "I won't take a wedge pattern setup on an intraday chart unless it is in a higher time frame uptrend, without nearby resistance, and trading above average volume with news on that day." Have a plan. If you can't describe your plan, you don't have one. Think in probabilities. You should think entirely in "if, then" scenarios. If X has happens, then Y will probably happen. "If BABA breaks this premarket support level on the open I will look for a pop up to short into." Backtest. Most traders lose mainly because they think they have an edge but they don't. You read these books and all this stuff online telling you "this is a high probability setup" but do you know that for a fact? There's different ways to backtest, but I think the best way for a beginner is manual backtesting with a chart and an excel sheet. This builds up that screen time and pattern recognition faster. This video shows how to do that. Once I saw someone do it, it didn't seem so boring and awful as I thought it was. Intelligence is not enough. You're smarter than most people, that's great, but that alone is not enough to make you money in trading necessarily. Brilliant people try and fail at this all the time, lawyers, doctors, surgeons, engineers.. Why do they fail if they're so smart? It's all a fucking scam. No, a number of reasons, but the biggest is discipline and emotional intelligence. Journal every day.K no thanks, bro. That's fucking gay. That's how I felt when I heard this advice but really that is pride and laziness talking. This is the process you need to do to learn what works for you and what doesn't. Review the trades you took, what your plan was, what actually happened, how you executed. Identify what you did well and what you can work on. This is how you develop discipline and emotional intelligence, by monitoring yourself. How you feel physically and mentally, and how these states affect your decision-making. Always be learning. Read as much as you can. Good quality books. Here's the best I've read so far; Market Wizards -Jack Schwager One Good Trade -Mike Bellafiore The Daily Trading Coach -Bret Steenbarger Psycho-cybernetics -Maxwell Maltz Why You Win or Lose -Fred Kelly The Art and Science of Technical Analysis -Adam Grimes Dark Pools -Scott Patterson Be nimble. Everyday I do my research on the symbols I'm trading and the fundamental news that's driving them. I might be trading a large cap that's gapping up with a beat on EPS and revenue and positive guidance. But if I see that stock pop up and fail miserably on the open amidst huge selling pressure, and I look and see the broader market tanking, guess what, I'm getting short, and that's just day trading. The movement of the market, on an intraday timeframe, doesn't have to make logical sense. Adapt. In March I used to be able to buy a breakout on a symbol and swing it for the majority of the day. In the summer I was basically scalping on the open and being done for the day. Volatility changes, and so do my profit targets. Be accountable. Be humble. Be honest. I take 100% responsibility for every dime I've lost or made in the market. It's not the market makers fault, it wasn't the HFTs, I pressed the button. I know my bad habits and I know my good habits.. my strengths/ my weaknesses. Protect yourself from toxicity. Stay away from traders and people on forums who just have that negative mindset. That "can't be done" mentality. Day trading is a scam!! It can certainly be done. Prove it, you bastard. I'm posting to this particular forum because I don't see much of that here and apparently the mods to a good job of not tolerating it. As the mod wrote in the rules, they're most likely raging from a loss. Also, the Stocktwits mentality of "AAPL is going to TANK on the open! $180, here we come. $$$" , or the grandiose stories, "I just knew AMZN was going to go up on earnings. I could feel it. I went ALL IN. Options money, baby! ka-ching!$" Lol, that is so toxic to a new trader. Get away from that. How will you be able to remain nimble when this is your thought process? Be good to yourself. Stop beating yourself up. You're an entrepreneur. You're boldly going where no man has gone before. You've got balls. Acknowledge your mistakes, don't identify with them. You are not your mistakes and you are not your bad habits. These are only things that you do, and you can take action necessary to do them less. It doesn't matter what people think. Maybe they think you're a fool, a gambler. You don't need their approval. You don't need to talk to your co-workers and friends about it to satisfy some subconscious plea for guidance; is this a good idea? You don't need anyone's permission to become the person you want to be. They don't believe in you? Fuck 'em. I believe in you.
View live forex rates and prices for commodities, indices and cryptos. Live streaming allows you to quickly spot any changes to a range of market assets. 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!). Live market data in your Excel spreadsheet. Excel Price Feed is an Add-in which includes 100+ new Excel formulas for live, historical and fundamental market data. Markets include stocks, stock indices, stock options, mutual funds, ETFs, forex, commodities and cryptocurrencies. I have a spreadsheet with a long list of prices in GBP that need to be converted to USD, HKD and RMB, they need to be marked up for retail pricing, pull live currency exchange rates and then rounded. I have done this manually but need an embedded solution pulling live exchange rates that can be used ongoing. Getting Started. Download - Click here to download the cmdtyView Excel Add-in and get started with the world’s most powerful Excel solution for commodity markets today!; Quick Start Guide - From installation through to getting your first quote live in Excel, our quick start guide will have you building amazing workbooks in no-time. Drop at line at [email protected] if you have any ... Getting easily live stock prices in Excel. Getting easily live forex rates in Excel. Getting historical data in Excel. Update as of January 2020: Deriscope has now a new dedicated ribbon that greatly simplifies the live feeds user interface. For details, visit the Introduction to Deriscope Live Feeds. Currently the following 43 currency pairs are supported: Deriscope Initialization . Deriscope ... Excel is undoubtedly the best platform for performing custom tasks on your stock portfolio, such as generating performance charts with respect to non-standard quantities. Generally you would rather base your trading decisions not only on past and current share prices, but also on mathematical quantities calculated out of those prices, broadly known as Technical Indicators. Real-Time Excel – get live stock, fund and bond prices, currency rates and more includes working spreadsheets for this tip and many other examples of getting live information into Excel. Buy and get it today (just a few minutes from now) Tip: If you have Excel 365 there’s a much easier way see Exchange Rate support in Excel 365. There are many places on the web which supply exchange rate ... How to import live forex prices into Microsoft Excel. The ability to see live price changes in a spreadsheet is incredibly powerful. The end result and the Use Cases for efficient and profitable trading I will go into later, but how do you go about it? Before we begin, you will you need two things: Metatrader Terminal (demo or live) Microsoft Excel from 97 upwards. In Metatrader we need to ... 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.
http://www.NeuroXL.com This demo shows an example of forecasting stock prices using NeuroXL Predictor excel add-in. http://www.myforexdashboard.com Powerful software tool to analyze your Forex trading results, learn from them, improve your trading and increase your Profit ... 🔴 Live Forex Signals Forecast EURUSD & USD JPY & GBPUSD H1 & M5 Forex Signals 28 watching Live now Predicting Stock Prices - Learn Python for Data Science #4 - Duration: 7:39. Excel interface lectura de datos de PLC micrologix 1000, 1100, 1200, 1500, SLC 500, PLC 5 - Duration: 2:55. Carlos Velez Recommended for you Accessing live feeds in Excel from Yahoo Finance in 2018 - Duration: 5 ... How to Build A Forex Trading Journal Using Excel Spreadsheet - Duration: 24:21. Federico Sellitti 16,048 views. 24:21 ... Using the calculation capacity of Microsoft Excel with real-time data, historical prices, technical indicators and proprietary functions, the user can effectively bypass the need for MQL ... To open a FREE trading and Demat account with FYERS click the link below http://partners.fyers.in/AP0151 http://upstox.com/open-account/?f=R0DP (OPEN ACCOUNT... How to call the free Yahoo! Finance API to get Stock Data (Microsoft Excel & VBA) - Duration: 1:38. Rovevo.com 17,974 views The 4 forex strategies that every trader should know ! 🚨🚨Trading Performance 🚨🚨 Improve Your Trading Performance at our Fundamental Trading Academy https://w... FOREX Trading Excel Workbook... Shows main currency pairs, calculates trade values, allows input of support and resistance levels, gives colour coded warning when price approaches levels ...