{"id":1528,"date":"2024-02-05T16:51:04","date_gmt":"2024-02-05T16:51:04","guid":{"rendered":"https:\/\/pitchforktrader.com\/en\/?page_id=1528"},"modified":"2024-02-05T16:57:02","modified_gmt":"2024-02-05T16:57:02","slug":"excel-spreadsheets","status":"publish","type":"page","link":"https:\/\/pitchforktrader.com\/en\/excel-spreadsheets\/","title":{"rendered":"Excel Spreadsheets"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"1528\" class=\"elementor elementor-1528\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b34de74 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b34de74\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t\t<div class=\"elementor-background-overlay\"><\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3742c13\" data-id=\"3742c13\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-76514fe elementor-widget elementor-widget-heading\" data-id=\"76514fe\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.19.0 - 26-02-2024 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h1 class=\"elementor-heading-title elementor-size-default\">Excel Spreadsheets<\/h1>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-050bf45 elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"050bf45\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-037f29f\" data-id=\"037f29f\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a4573e7 elementor-widget elementor-widget-heading\" data-id=\"a4573e7\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">These Excel Spreadsheets are reserved to our books Readers and can be freely obtained as executable files, from the author: mircdologa@yahoo.com.\n<br>\nIf interested you can see a few of them in our three books Excerpts.\u200b<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-8ee58b1 elementor-section-content-middle elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8ee58b1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-3e23d26\" data-id=\"3e23d26\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f43c5ae elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"f43c5ae\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.19.0 - 26-02-2024 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<div class=\"row blog-item\" style=\"margin-left: -15px; margin-right: -15px; border-bottom: 1px solid #dadedf; margin-bottom: 52px; padding-bottom: 52px; color: #505656; font-family: 'Helvetica Neue', Roboto, Helvetica, Arial, sans-serif; font-size: 16px;\">\n<article>\n<div class=\"col-md-12\" style=\"position: relative; min-height: 1px; padding-left: 15px; padding-right: 15px; float: left; width: 870px;\">\n<header class=\"article-header clearfix\" style=\"padding-right: 40px;\">\n<h2 class=\"article-title\" style=\"font-family: 'Helvetica Neue', Roboto, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.25; margin-bottom: 26px; font-size: 30px; color: #039be5 !important;\"><a href=\"https:\/\/pitchforktrader.com\/en\/volume-i\/\">Volume 1<\/a><\/h2>\n<\/header>\n<div class=\"intro-image col-md-12\" style=\"position: relative; min-height: 1px; padding-left: 15px; padding-right: 15px; float: left; width: 840px; margin-bottom: 26px;\">&nbsp;<\/div>\n<section class=\"article-intro clearfix\" style=\"position: relative;\"><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">1.<\/strong>The 80\/20 Percent Rule<\/section>\n<\/div>\n<\/article>\n<\/div>\n<div class=\"row blog-item\" style=\"margin-left: -15px; margin-right: -15px; border-bottom: 1px solid #dadedf; margin-bottom: 52px; padding-bottom: 52px; color: #505656; font-family: 'Helvetica Neue', Roboto, Helvetica, Arial, sans-serif; font-size: 16px;\">\n<article>\n<div class=\"col-md-12\" style=\"position: relative; min-height: 1px; padding-left: 15px; padding-right: 15px; float: left; width: 870px;\">\n<header class=\"article-header clearfix\" style=\"padding-right: 40px;\">\n<h2 class=\"article-title\" style=\"font-family: 'Helvetica Neue', Roboto, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.25; margin-bottom: 26px; font-size: 30px; color: #039be5 !important;\">&nbsp;<\/h2>\n<h2 class=\"article-title\" style=\"font-family: 'Helvetica Neue', Roboto, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.25; margin-bottom: 26px; font-size: 30px; color: #039be5 !important;\"><a href=\"https:\/\/pitchforktrader.com\/en\/volume2\/\">Volume 2<\/a><\/h2>\n<\/header>\n<div class=\"intro-image col-md-12\" style=\"position: relative; min-height: 1px; padding-left: 15px; padding-right: 15px; float: left; width: 840px; margin-bottom: 26px;\">&nbsp;<\/div>\n<section class=\"article-intro clearfix\" style=\"position: relative;\"><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">1.<\/strong>&nbsp;Price Fibonacci Ratios Rechnique Applied to Elliott Waves<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">2.<\/strong>&nbsp;Reversal New Signals:<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5; margin-left: 10px;\">2a<\/strong>&nbsp;&#8211; Positive Reversals<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5; margin-left: 10px;\">2b<\/strong>&nbsp;&#8211; Negative Reversals<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">3.<\/strong>&nbsp;Key Level Mapping of the Operational Time-Frame Chart<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">4.<\/strong>&nbsp;Pre-Open Main Points<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">5.<\/strong>&nbsp;Dax Pre-Open Trading Study<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">6.<\/strong>&nbsp;Miner&#8217;s &amp; Fisher&#8217;s Calculations of End-of-Wave 3<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">7.<\/strong>&nbsp;Miner&#8217;s &amp; Fisher&#8217;s Calculations of End-of-Wave 5<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">8.<\/strong>&nbsp;Pivotal Bar Count Table<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">9.<\/strong>&nbsp;Types of Bar Count Numbers from 5 to 206<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">10.<\/strong>&nbsp;Bar Count Grid<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">11.<\/strong>&nbsp;Three Pawn Technique<\/section><section class=\"article-intro clearfix\" style=\"position: relative;\"><br><\/section>\n<section class=\"article-intro clearfix\" style=\"position: relative;\"><\/section>\n<\/div>\n<\/article>\n<\/div>\n<div class=\"row blog-item\" style=\"margin-left: -15px; margin-right: -15px; border-bottom: 1px solid #dadedf; margin-bottom: 52px; padding-bottom: 52px; color: #505656; font-family: 'Helvetica Neue', Roboto, Helvetica, Arial, sans-serif; font-size: 16px;\">\n<article>\n<div class=\"col-md-12\" style=\"position: relative; min-height: 1px; padding-left: 15px; padding-right: 15px; float: left; width: 870px;\">\n<header class=\"article-header clearfix\" style=\"padding-right: 40px;\">\n<h2 class=\"article-title\" style=\"font-family: 'Helvetica Neue', Roboto, Helvetica, Arial, sans-serif; font-weight: 500; line-height: 1.25; margin-bottom: 26px; font-size: 30px; color: #039be5 !important;\"><a href=\"https:\/\/pitchforktrader.com\/en\/volume3\/\">Volume 3<\/a><\/h2>\n<\/header>\n<div class=\"intro-image col-md-12\" style=\"position: relative; min-height: 1px; padding-left: 15px; padding-right: 15px; float: left; width: 840px; margin-bottom: 26px;\">&nbsp;<\/div>\n<section class=\"article-intro clearfix\" style=\"position: relative;\"><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">1.<\/strong>&nbsp;Floor Pivot Calculations&nbsp;<em>(11 Formulas)<\/em><br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">2.<\/strong>&nbsp;Excel Spreadsheet for Calculations of Multiple Time Frames Floor Pivots: Daily, Weekly &amp; Monthly<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">3.<\/strong>&nbsp;EFS Formulas of Calculating 11 Daily Floor Pivots&nbsp;<em>(from S5 to R5)<\/em>&nbsp;&#8211; Modified after S2 to R2 EFS eSignal file &#8211;&nbsp;<em>Source<\/em>: Advanced GET Software of&nbsp;<span style=\"text-decoration-line: underline;\"><a style=\"color: #039be5; transition: all 0.2s ease 0s;\" href=\"http:\/\/www.esignal.com\/\">www.eSignal.com<\/a><\/span><br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">4.<\/strong>&nbsp;Mark Fisher &#8211; Pivot Range (PR) &amp; Close<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">5.<\/strong>&nbsp;Fibonacci Time Ratios Applied to Primary &amp; Lesser Degree Elliot Waves<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">6.<\/strong>&nbsp;Glossary of Wyckoff Terms<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">7.<\/strong>&nbsp;Multiple Jenkins True Trend Lines Study &#8211; 8 Down-Cycles of Square of Nine<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">8.<\/strong>&nbsp;Multiple Jenkins True Trend Lines Study &#8211; 4 Up-Cycles of Square of Nine<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">9.<\/strong>&nbsp;Multiple Jenkins True Trend Lines Study &#8211; 16 Up-Cycles of Square of Nine<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">10.<\/strong>&nbsp;CCI Indicator: Price Momentum-Related Mechanism<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">11.<\/strong>&nbsp;Pitchforks&#8217; Down-Targeting through ATR &amp; First Bar Projections<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">12.<\/strong>&nbsp;Pitchforks&#8217; Up-Targeting through ATR &amp; First Bar Projections<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">13.<\/strong>&nbsp;Gann Eights Levels Table<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">14.<\/strong>&nbsp;Up-Sloping Gann Percentages<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">15.<\/strong>&nbsp;Down-Sloping Gann Percentages<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">16.<\/strong>&nbsp;Gann Main Levels<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">17.<\/strong>&nbsp;Multiple Layers Cluster &#8211; Upward Gann Percentage &#8211; Primary &amp; Secondary Levels<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">18.<\/strong>&nbsp;Multiple Layers Cluster &#8211; Downward Gann Percentage &#8211; Primary &amp; Secondary Levels<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">19.<\/strong>&nbsp;Gann Square of Nine &#8211; Down-Trend Study from Highest High<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">20.<\/strong>&nbsp;Gann Square of Nine &#8211; Down-Trend Study from Four Lower Highs<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">21.<\/strong>&nbsp;Gann Square of Nine &#8211; Up-Trend Study from Lowest Low &amp; Three Higher Lows<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">22.<\/strong>&nbsp;Gann Square of Nine &#8211; Cardinal Price Levels<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">23.<\/strong>&nbsp;Gann Square of Nine &#8211; Cardinal Time Levels<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">24.<\/strong>&nbsp;Three-Pawn Technique<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">25.<\/strong>&nbsp;P&amp;L Statement &#8211; Three-Pawn Technique &#8211;&nbsp;<em><span class=\"text-success\" style=\"color: #468847;\">Long Trade<\/span><\/em>&nbsp;&#8211; 1 Target &amp; 2 Trails<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">26.<\/strong>&nbsp;P&amp;L Statement &#8211; Three-Pawn Technique &#8211;&nbsp;<em><span class=\"text-success\" style=\"color: #468847;\">Long Trade<\/span><\/em>&nbsp;&#8211; 1 Trail &amp; 1 Add-On<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">27.<\/strong>&nbsp;P&amp;L Statement &#8211; Three-Pawn Technique &#8211;&nbsp;<em><span class=\"text-success\" style=\"color: #468847;\">Long Trade<\/span><\/em>&nbsp;&#8211; 1 Target &amp; 1 Add-On<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">28.<\/strong>&nbsp;P&amp;L Statement &#8211; Three-Pawn Technique &#8211;&nbsp;<em><span class=\"text-danger\" style=\"color: #b94a48;\">Short Trade<\/span><\/em>&nbsp;&#8211; 3 Targest<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">29.<\/strong>&nbsp;P&amp;L Statement &#8211; Three-Pawn Technique &#8211;&nbsp;<em class=\"text-danger\" style=\"color: #b94a48;\">Short Trade<\/em>&nbsp;&#8211; 1 Trail<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">30.<\/strong>&nbsp;P&amp;L Statement &#8211; Three-Pawn Technique &#8211;&nbsp;<em class=\"text-danger\" style=\"color: #b94a48;\">Short Trade<\/em>&nbsp;&#8211; 1 Target &amp;&nbsp;3 Add-On<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">31.<\/strong>&nbsp;Market Mapping with Supports, Resistances &amp; Floor Pivots<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">32.<\/strong>&nbsp;German Dax Futures Pre-Open Study: a detailed description can be found in Volume II<br><strong class=\"text-primary\" style=\"font-weight: bold; color: #039be5;\">33.<\/strong>&nbsp;Pre-Open Analysis Synopsis of the Traded Instrument<\/section>\n<\/div>\n<\/article>\n<\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Excel Spreadsheets These Excel Spreadsheets are reserved to our books Readers and can be freely obtained as executable files, from the author: mircdologa@yahoo.com. If interested you can see a few [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1528","page","type-page","status-publish","hentry","rishi-post","no-post-thumbnail"],"rishi__cb_customizer_meta":{"page_title_panel":"","page_title_hero_section":"default","breadcrumbs_single_page":"no","single_page_alignment":"left","single_page_margin":{"desktop":50,"tablet":30,"mobile":30},"5801c41b8493e10c5cfd8031899281d2":"","page_structure_type":"default-sidebar","bc4cd639b87b66420809ac448cd735de":"","content_style_source":"inherit","content_style":"box-layout","blog_page_streched_ed":"no","vertical_spacing_source":"custom","content_area_spacing":"none","single_page_content_background":{"background_type":"color","background_pattern":"type-1","background_image":{"attachment_id":null,"x":0,"y":0},"gradient":"linear-gradient(135deg,rgba(6,147,227,1) 0%,rgb(155,81,224) 100%)","background_repeat":"no-repeat","background_size":"auto","background_attachment":"scroll","patternColor":{"default":{"color":"#e5e7ea"}},"overlayColor":{"default":{"color":"CT_CSS_SKIP_RULE"}},"backgroundColor":{"default":{"color":"var(--paletteColor5)"}}},"single_page_content_boxed_shadow":{"inherit":false,"blur":18,"spread":-6,"v_offset":12,"h_offset":0,"inset":false,"enable":false,"color":{"color":"rgba(34, 56, 101, 0.04)"}},"single_page_boxed_content_spacing":{"top":"40px","bottom":"40px","left":"40px","right":"40px","linked":true},"single_page_content_boxed_radius":{"top":"3px","bottom":"3px","left":"3px","right":"3px","linked":true},"1ca0d4b3772d294977ec5b8d23e8a10f":"","disable_featured_image":"no","disable_comments":"no","disable_header":"no","disable_footer":"no"},"_links":{"self":[{"href":"https:\/\/pitchforktrader.com\/en\/wp-json\/wp\/v2\/pages\/1528","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pitchforktrader.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/pitchforktrader.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/pitchforktrader.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pitchforktrader.com\/en\/wp-json\/wp\/v2\/comments?post=1528"}],"version-history":[{"count":4,"href":"https:\/\/pitchforktrader.com\/en\/wp-json\/wp\/v2\/pages\/1528\/revisions"}],"predecessor-version":[{"id":1532,"href":"https:\/\/pitchforktrader.com\/en\/wp-json\/wp\/v2\/pages\/1528\/revisions\/1532"}],"wp:attachment":[{"href":"https:\/\/pitchforktrader.com\/en\/wp-json\/wp\/v2\/media?parent=1528"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}