P&F charts suck, don't use them...

[PebbleTrader]

Looks like this:

There is a "Data" sheet where you copy and paste the MT4 exported M1 data:



Update the info in the box and click the button called "Plot P&F", then it plots the PnF on a separate sheet called "Chart" in less than a second.

Note: if you change the fill color in the settings, than it uses those colors when creating the boxes on the P&F sheet.

Also you can change how big you want your boxes to be or adjust for "squareness"

[PebbleTrader]

Here is the auto generated chart: (None of this information is filled out, all automatic)

First column with price levels is frozen pane so you can scroll sideways without price disappearing...

[lazygeorge]

Here is the auto generated chart: (None of this information is filled out, all automatic)

First column with price levels is frozen pane so you can scroll sideways without price disappearing...

Just walked in to read the progress being made here.

Excellent work PT,even if an mt4 indi becomes available this excel sheet will still be an invaluable resource provided it plots the same as manually..

Appreciate all you effort.

[MightyOne]

Here is the auto generated chart: (None of this information is filled out, all automatic)

First column with price levels is frozen pane so you can scroll sideways without price disappearing...

You are an Excel god for sure...

[bredin]

Thanks for input Belkin.

I personally want the High / Low, and not closes. But it's just personal preference and one way is not RIGHT OR WRONG.

The spikes were a little tricky to code. Bredin, I'd be glad to let you look through my code if you can't figure it out. You would have to translate it to MT4 though...

what ive done is...

1. if its a bar that spans several boxes then I 'adjust' the bar so the low and high become the open and close (whichever way round is appropiate) and
2. use the previous close as the new open.

this has the effect of being able to treat one bar (from a programtic point of view) as two bars of opposite movement....

G.

[Belkin]

Here is the auto generated chart: (None of this information is filled out, all automatic)

First column with price levels is frozen pane so you can scroll sideways without price disappearing...

Nice chart

[Jalarupa]

Here is the auto generated chart: (None of this information is filled out, all automatic)

First column with price levels is frozen pane so you can scroll sideways without price disappearing...

Nice chart

That's the biggest piece of crap, waste of time, bit of half baked Excel code I've seen in my ENTIRE life...!

Why, I mean honestly..., why would you waste your time even downloading or applying for such a spreadsheit....

I totally see why you not asking money for this thing...

[PebbleTrader]

"provided it plots the same as manually.. "

It plots them the same as manually based on YOUR DATA FEED (It may be a little different from mine).

And for once, the MB Support Staff may have been right, the MT4 data feed is the same as MB Nav Pro.

That is the best we can ask for.

[PebbleTrader]

"what ive done is...

1. if its a bar that spans several boxes then I 'adjust' the bar so the low and high become the open and close (whichever way round is appropiate) and
2. use the previous close as the new open."

Ok, I see, it's different code for MT4 then because of the GUI differences.

[PebbleTrader]

"Excellent work PT,even if an mt4 indi becomes available"

Even if? With a coder like Bredin, the question becomes "WHEN the MT4 indi becomes available"