{"id":2540,"date":"2017-06-20T12:38:32","date_gmt":"2017-06-20T11:38:32","guid":{"rendered":"http:\/\/www.tradersnest.com\/?p=2540"},"modified":"2017-06-20T12:53:41","modified_gmt":"2017-06-20T11:53:41","slug":"proof-spreadsheet-millions-method-fails","status":"publish","type":"post","link":"https:\/\/www.tradersnest.com\/articles\/proof-spreadsheet-millions-method-fails\/","title":{"rendered":"Proof that ‘Spreadsheet Millions’ method fails"},"content":{"rendered":"

\"\"<\/p>\n

Once upon a time I made a ‘million-pound’ spreadsheet.<\/p>\n

It was a beauty to behold. I even made a fancy graph too. It predicted how quickly my trading money was going to grow – all by making *just* one winning trade per day – and I virtually worshipped the thing.<\/p>\n

I could probably dig it up on an old hard drive somewhere. And you know what, for my very first 8 weeks of trading I actually kept ahead of the curve.<\/p>\n

I was making more money on a weekly basis than I needed to, all from a standing start!<\/p>\n

\u201cOh, this is going to be so easy\u201d I told myself.<\/p>\n

And of course, that\u2019s exactly when everything suddenly took a turn for the worse.<\/p>\n

Was a 50,000% return really so unreasonable?<\/b><\/strong><\/h3>\n

I often think back to those days and try to relive what was going through my mind. I mean, my calculations were utter madness in the first place: I was anticipating annual returns of insane proportions…<\/p>\n

It didn\u2019t seem to sink into my thick skull that that my forecast returns of 50,000% in year 1 was anything out of the ordinary!<\/p>\n

But I can put all that down to youthful exuberance.<\/p>\n

No, it\u2019s the naive yet effective trading approach that intrigues me most.<\/p>\n

Looking back at my early trades now, I can see how I was operating from a completely clear and un-expectant state of mind.<\/p>\n

It was easy to do because I didn\u2019t know any different. I\u2019d put together a system of sorts and was simply pulling the trigger on the trades.<\/p>\n

I didn\u2019t have much money to risk so there were no real emotions involved. I could pretty much shrug off any losses.<\/p>\n

And I had no previous frame of reference to make me doubt the signals my rag-tag system was throwing out.<\/p>\n

Trading with Beginner’s Luck<\/b><\/strong><\/h3>\n

I do think \u2018beginner\u2019s luck\u2019 is probably quite a common experience with brand new traders. You simply do as you\u2019re told because at this stage you don\u2019t know enough to do things any other way.<\/p>\n

And surprisingly, you get some half-decent results \u2013 exactly what the strategy would have you expect in the first place!<\/p>\n

It\u2019s how I remember things anyway. And it was only when I got a bit of experience behind me that my inner \u2018know-it-all\u2019 suddenly began to make its unwanted presence felt\u2026<\/p>\n

I suppose you store away memories of painful early experiences: your first big losing trade, the first time you completely miss a good opportunity, that time you put on a trade the wrong way around, buying instead of selling!<\/p>\n

And it\u2019s only natural your body\u2019s defense mechanism kicks in to try and stop you recreating bad feelings next time a similar situation rolls around.<\/p>\n

All well and good when you\u2019re a toddler learning it\u2019s best not to touch a hot central heating pipe again with your bare hand, not so good when those same instincts are fighting to stop you \u2018hurting yourself\u2019 by entering another trade because the previous one lost money and made you feel sad.<\/p>\n

To illustrate, let\u2019s jump back to week five of my fledgling trading campaign when things were still going swimmingly\u2026<\/p>\n

I\u2019d dropped lucky by starting to trade during a strong spell in the markets and had made good money for the first four weeks. And this set a dangerous precedent. It\u2019s what I came to expect EVERY week.<\/p>\n

So when profits for week five were looking a bit thin on the ground, come Wednesday night I hatched a devious scheme (you\u2019ll laugh when you hear this)\u2026<\/p>\n

Gambling for fun and profit!<\/b><\/strong><\/h3>\n

I simply had to hit my target for the week \u2013 after all, I couldn’t let my million-pound spreadsheet fall into disarray \u2013 so I figured I\u2019d stick a trade on right before an economic number.<\/p>\n

It wasn\u2019t a huge report; it was the US Producer Price Index or something like that. But the plan was to use my \u2018skill and judgment\u2019 to figure out in advance which way the market was going to move and top my profits up for the week all in one focused raid on the market.<\/p>\n

And sure enough, that\u2019s exactly what happened! I made more than enough for the week off that one trade.<\/p>\n

It happened again the following week. In fact, it pretty much became my new standard strategy. I was now gambling my way through the weeks!<\/p>\n

And of course, you know what\u2019s coming\u2026 all the money (and more) that I\u2019d made in weeks one to eight went sailing out the window in week nine! My bad habit finally caught up with me and the honeymoon spell was over.<\/p>\n

It really knocked my confidence at the time. I overcompensated by starting to trade ultra cautiously. I was moving stop losses to breakeven far too early and snatching away at tiny profits. It meant I was leaving far too much money on the table so the losing period continued. And I\u2019m sure you know the story \u2013 \u2018scared money never wins\u2019.<\/p>\n

And that\u2019s the way it stayed until I stumbled upon one page in a trading book that changed my outlook forever\u2026<\/p>\n

Learning to Trade an Edge like a Casino<\/b><\/strong><\/h3>\n

This technique comes straight off the pages of Mark Douglas\u2019s Trading in the Zone <\/i><\/em>(it\u2019s on p189 of my edition, actually).<\/p>\n

I\u2019m giving Mark Douglas absolute full credit here. I\u2019ll paraphrase the mind-changing concept he presents but if you haven\u2019t got Trading in the Zone<\/i><\/em>\u00a0on your trading bookshelf you really do owe it to yourself to get a copy. You won\u2019t be the same after reading it (in a good way), I assure you.<\/p>\n

So here\u2019s the idea\u2026<\/p>\n

You need to convince yourself that trading is a simple game of probability. On a trade-by-trade basis the profit\/loss outcome can be completely random but string together a larger sample size of trades and a profitable edge will start to show itself.<\/p>\n

Think of a casino and how they run their gaming tables\u2026<\/p>\n

They don\u2019t worry about whether the next spin of a roulette wheel means they\u2019ll have to pay-out the gamblers. And it\u2019s not a concern the next turn of a card means a particular high-roller helps himself to a wedge of their money.<\/p>\n

They know the game is won over the long-term. They just need to keep spinning the wheel and flopping the cards long enough to see their mathematical profitable edge begin to materialise. And it always does without fail!<\/p>\n

So put it into trading terms and imagine yourself to be a casino \u2018spinning the wheel\u2019 every time you place a trade using your proven system\u2026<\/p>\n

Can you see how this subtle change in outlook can completely remove the urge for you to be \u2018right\u2019 on every trade?<\/p>\n

It also shows there\u2019s no need to strive for set weekly or monthly profit targets like I was doing. You just need to settle into your groove, keep spinning the wheel, and let your profitable edge do the business for you in its own time.<\/p>\n

Oh, if I\u2019d only read that book back in week 5! I\u2019d have saved myself a whole load of bother, about eighteen months of wasted time, and who knows\u2026 that spreadsheet I made in my early days just might have held water. Maybe I would have made a million in the blink of an eye after all.<\/p>\n

I know it all sounds simple but have a think about how this mindset might help you overcome some of your own obstacles. Try it on for size – the best way is by following the 20-trade ‘Trade like a casino’ exercise laid out in the book.<\/p>\n

So go and pull Trading in the Zone<\/i><\/em>\u00a0off your shelf now and make a start. If you haven\u2019t got a copy, jump onto Amazon and get it on order \u2013 here\u2019s the link<\/u><\/a>. It\u2019s probably the best investment you could make toward your trading success today.<\/p>\n

Be Prepared: Market Moving Data Coming This Week (London Time):<\/b><\/strong><\/h3>\n

Wednesday 21st June:
\n15:00 \u00a0 \u00a0 USD \u00a0 \u00a0 \u00a0Existing Home Sales
\n15:30 \u00a0 \u00a0 USD \u00a0 \u00a0 \u00a0Crude Oil Inventories<\/p>\n

Thursday 22nd June:
\n– no big reports<\/p>\n

Friday 23rd June:
\n08:30 \u00a0 \u00a0 EUR\u00a0 \u00a0 \u00a0 German Manufacturing PMI
\n15:00 \u00a0 \u00a0 USD\u00a0 \u00a0 \u00a0 New Home Sales<\/p>\n

Monday 26th June:
\n13:30 \u00a0 \u00a0 USD \u00a0 \u00a0 \u00a0Core Durable Goods<\/p>\n

Tuesday 27th June:
\n15:00 \u00a0 \u00a0USD \u00a0 \u00a0 \u00a0CB Consumer Confidence<\/p>\n

It’s a pretty quiet week ahead on the scheduled reports front but don’t be complacent. Keep a careful eye on any resting orders you have working in the markets and protect your downside risk at all times.<\/p>\n

Until next time…<\/p>\n

Happy trading,
\nRich<\/p>\n","protected":false},"excerpt":{"rendered":"

Once upon a time I made a ‘million-pound’ spreadsheet. It was a beauty to behold. I even made a fancy graph too. It predicted how quickly my trading money was going to grow – all by making *just* one winning trade per day – and I virtually worshipped the thing. I could probably dig it […]<\/p>\n","protected":false},"author":436,"featured_media":2541,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[3],"tags":[],"yoast_head":"\nProof that 'Spreadsheet Millions' method fails - Trader's Nest<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.tradersnest.com\/articles\/proof-spreadsheet-millions-method-fails\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Proof that 'Spreadsheet Millions' method fails - Trader's Nest\" \/>\n<meta property=\"og:description\" content=\"Once upon a time I made a ‘million-pound’ spreadsheet. It was a beauty to behold. I even made a fancy graph too. It predicted how quickly my trading money was going to grow – all by making *just* one winning trade per day – and I virtually worshipped the thing. I could probably dig it […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.tradersnest.com\/articles\/proof-spreadsheet-millions-method-fails\/\" \/>\n<meta property=\"og:site_name\" content=\"Trader's Nest\" \/>\n<meta property=\"article:published_time\" content=\"2017-06-20T11:38:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-06-20T11:53:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.tradersnest.com\/wp-content\/uploads\/2017\/06\/ThinkstockPhotos-200372813-001_opt.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"1193\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Rich Fitton\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rich Fitton\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.tradersnest.com\/articles\/proof-spreadsheet-millions-method-fails\/\",\"url\":\"https:\/\/www.tradersnest.com\/articles\/proof-spreadsheet-millions-method-fails\/\",\"name\":\"Proof that 'Spreadsheet Millions' method fails - Trader's Nest\",\"isPartOf\":{\"@id\":\"https:\/\/www.tradersnest.com\/#website\"},\"datePublished\":\"2017-06-20T11:38:32+00:00\",\"dateModified\":\"2017-06-20T11:53:41+00:00\",\"author\":{\"@id\":\"https:\/\/www.tradersnest.com\/#\/schema\/person\/8f28be7be9145e22549caf5123ff7245\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.tradersnest.com\/articles\/proof-spreadsheet-millions-method-fails\/#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.tradersnest.com\/articles\/proof-spreadsheet-millions-method-fails\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.tradersnest.com\/articles\/proof-spreadsheet-millions-method-fails\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.tradersnest.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Proof that ‘Spreadsheet Millions’ method fails\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.tradersnest.com\/#website\",\"url\":\"https:\/\/www.tradersnest.com\/\",\"name\":\"Trader's Nest\",\"description\":\"Be the best trader you can be\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.tradersnest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.tradersnest.com\/#\/schema\/person\/8f28be7be9145e22549caf5123ff7245\",\"name\":\"Rich Fitton\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/www.tradersnest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/311780fdcb7a94f5361a587e61d9c37c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/311780fdcb7a94f5361a587e61d9c37c?s=96&d=mm&r=g\",\"caption\":\"Rich Fitton\"},\"url\":\"https:\/\/www.tradersnest.com\/author\/rich-fitton\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Proof that 'Spreadsheet Millions' method fails - Trader's Nest","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.tradersnest.com\/articles\/proof-spreadsheet-millions-method-fails\/","og_locale":"en_US","og_type":"article","og_title":"Proof that 'Spreadsheet Millions' method fails - Trader's Nest","og_description":"Once upon a time I made a ‘million-pound’ spreadsheet. It was a beauty to behold. I even made a fancy graph too. It predicted how quickly my trading money was going to grow – all by making *just* one winning trade per day – and I virtually worshipped the thing. I could probably dig it […]","og_url":"https:\/\/www.tradersnest.com\/articles\/proof-spreadsheet-millions-method-fails\/","og_site_name":"Trader's Nest","article_published_time":"2017-06-20T11:38:32+00:00","article_modified_time":"2017-06-20T11:53:41+00:00","og_image":[{"width":900,"height":1193,"url":"https:\/\/www.tradersnest.com\/wp-content\/uploads\/2017\/06\/ThinkstockPhotos-200372813-001_opt.jpg","type":"image\/jpeg"}],"author":"Rich Fitton","twitter_misc":{"Written by":"Rich Fitton","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.tradersnest.com\/articles\/proof-spreadsheet-millions-method-fails\/","url":"https:\/\/www.tradersnest.com\/articles\/proof-spreadsheet-millions-method-fails\/","name":"Proof that 'Spreadsheet Millions' method fails - Trader's Nest","isPartOf":{"@id":"https:\/\/www.tradersnest.com\/#website"},"datePublished":"2017-06-20T11:38:32+00:00","dateModified":"2017-06-20T11:53:41+00:00","author":{"@id":"https:\/\/www.tradersnest.com\/#\/schema\/person\/8f28be7be9145e22549caf5123ff7245"},"breadcrumb":{"@id":"https:\/\/www.tradersnest.com\/articles\/proof-spreadsheet-millions-method-fails\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.tradersnest.com\/articles\/proof-spreadsheet-millions-method-fails\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.tradersnest.com\/articles\/proof-spreadsheet-millions-method-fails\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.tradersnest.com\/"},{"@type":"ListItem","position":2,"name":"Proof that ‘Spreadsheet Millions’ method fails"}]},{"@type":"WebSite","@id":"https:\/\/www.tradersnest.com\/#website","url":"https:\/\/www.tradersnest.com\/","name":"Trader's Nest","description":"Be the best trader you can be","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.tradersnest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en"},{"@type":"Person","@id":"https:\/\/www.tradersnest.com\/#\/schema\/person\/8f28be7be9145e22549caf5123ff7245","name":"Rich Fitton","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/www.tradersnest.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/311780fdcb7a94f5361a587e61d9c37c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/311780fdcb7a94f5361a587e61d9c37c?s=96&d=mm&r=g","caption":"Rich Fitton"},"url":"https:\/\/www.tradersnest.com\/author\/rich-fitton\/"}]}},"_links":{"self":[{"href":"https:\/\/www.tradersnest.com\/wp-json\/wp\/v2\/posts\/2540"}],"collection":[{"href":"https:\/\/www.tradersnest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tradersnest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tradersnest.com\/wp-json\/wp\/v2\/users\/436"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tradersnest.com\/wp-json\/wp\/v2\/comments?post=2540"}],"version-history":[{"count":0,"href":"https:\/\/www.tradersnest.com\/wp-json\/wp\/v2\/posts\/2540\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.tradersnest.com\/wp-json\/wp\/v2\/media\/2541"}],"wp:attachment":[{"href":"https:\/\/www.tradersnest.com\/wp-json\/wp\/v2\/media?parent=2540"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tradersnest.com\/wp-json\/wp\/v2\/categories?post=2540"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tradersnest.com\/wp-json\/wp\/v2\/tags?post=2540"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}