Thanks for the idea MO,
I can't think at the moment though, I think my brain is fried.
Need to take a break...
P&F charts suck, don't use them...
Moderator: moderators
- PebbleTrader
- rank: 1000+ posts
- Posts: 1633
- Joined: Fri Nov 12, 2010 2:15 am
- Reputation: 15
- Gender:
Please add www.kreslik.com to your ad blocker white list.
Thank you for your support.
Thank you for your support.
- Jalarupa
- rank: 1000+ posts
- Posts: 1300
- Joined: Tue Feb 23, 2010 5:50 pm
- Reputation: 324
- Location: South Africa
- Gender:
PebbleTrader wrote:Here is the good news, it is POSSIBLE!
I successfully wrote a program that will take MT4 M1 history file and will plot the PnF on an Excel sheet. All you have to do is run a macro in Excel and it plots it all out, sizes the columns and rows, and draws only the needed price scale based on the highest high and lowest low in the history file. It matches the manual PnF I had been filling in since the start of the week.
I've been working on the program for about 8 hours straight and just now got it to match the manual ones we are doing. It was more difficult to code than I had expected
I am much more interested in MT4 indi plotting it for us. So I am cheering Bredin on! Go Bredin! Go Bredin!
For now, this macro beats doing it manually LOL
Just run the macro and poof! weeks worth of 1M data plots out before your eyes in less than a second!
HAHAHAHA!
Also I know there is a plugin for MT4 floating around that pulls live tick data to Excel... Can't remember what it'd called though...
http://www.metatrader4.com/forum/235
But kudo's on this achievement the manual process foes keep one away from the charts for too long...
Stoked!
Try this: http://www.metatrader4.com/forum/14254 or
http://forum.mt5.com/showthread.php?319 ... andle-wise
Or if I recall there was discussion of how to this in the signalbender thread somewhere.
http://forum.mt5.com/showthread.php?319 ... andle-wise
Or if I recall there was discussion of how to this in the signalbender thread somewhere.
Jalarupa wrote:PebbleTrader wrote:Here is the good news, it is POSSIBLE!
I successfully wrote a program that will take MT4 M1 history file and will plot the PnF on an Excel sheet. All you have to do is run a macro in Excel and it plots it all out, sizes the columns and rows, and draws only the needed price scale based on the highest high and lowest low in the history file. It matches the manual PnF I had been filling in since the start of the week.
I've been working on the program for about 8 hours straight and just now got it to match the manual ones we are doing. It was more difficult to code than I had expected
I am much more interested in MT4 indi plotting it for us. So I am cheering Bredin on! Go Bredin! Go Bredin!
For now, this macro beats doing it manually LOL
Just run the macro and poof! weeks worth of 1M data plots out before your eyes in less than a second!
HAHAHAHA!
Also I know there is a plugin for MT4 floating around that pulls live tick data to Excel... Can't remember what it'd called though...
But kudo's on this achievement the manual process foes keep one away from the charts for too long...
Stoked!
- PebbleTrader
- rank: 1000+ posts
- Posts: 1633
- Joined: Fri Nov 12, 2010 2:15 am
- Reputation: 15
- Gender:
- PebbleTrader
- rank: 1000+ posts
- Posts: 1633
- Joined: Fri Nov 12, 2010 2:15 am
- Reputation: 15
- Gender:
I still have a few kinks to work out.
I have confidence in our friend Bredin coming through with MT4 indi.
But depending on what you are doing Excel is still a good option.
I'll be sharing it with my Kreslik friends but...
It will be DONATIONAL BUT WITH A TWIST for anyone that wants it.
I would like for you to DONATE a CREATIVE IDEA to this thread about PnF.
It must not be something I would read in "The Definitive Guide To Point & Figure"
I value your IDEAS more so than your $XX.XX's
When you do so, you might just find it showing up in your inbox.
"But...But...I'm not that creative!"
It's time to start thinking outside the PnF "box"
I have confidence in our friend Bredin coming through with MT4 indi.
But depending on what you are doing Excel is still a good option.
I'll be sharing it with my Kreslik friends but...
It will be DONATIONAL BUT WITH A TWIST for anyone that wants it.
I would like for you to DONATE a CREATIVE IDEA to this thread about PnF.
It must not be something I would read in "The Definitive Guide To Point & Figure"
I value your IDEAS more so than your $XX.XX's
When you do so, you might just find it showing up in your inbox.
"But...But...I'm not that creative!"
It's time to start thinking outside the PnF "box"
Life is just a journey
Please add www.kreslik.com to your ad blocker white list.
Thank you for your support.
Thank you for your support.
"A third type of data, called intra-day
or interval data, is available, composed by summarising the data for a chosen interval
-
1
minute, 5 minute, hourly, or any time-frame - into high, low and close for that interval. So,
1 minute interval data in an 8 hour day, would result in 480, high, low, close (HLC) packets,
which represent the HLC for each minute. A 1 minute Point and Figure chart is then
constructed using either the close at the end of each minute or the high/low each minute,
giving a far more detailed chart than one constructed with end-of-day close or end-of-day
high/low. This opens up a huge range of Point and Figure charts to use, because you could
draw a 5 minute chart, a 1 0 minute, an hourly, or any intra-day time-frame you wish to
nominate."
"There are many Point and Figure purists who insist on using tick data only. Their
commitment is to be applauded. If the data is available for the period you require, then tick
data is the best. However, interval data is far easier to manage and the difference between 1
minute data and tick data is insignificant, especially if you use the high/low construction
method."
From the Definite Guide to P&F
or interval data, is available, composed by summarising the data for a chosen interval
-
1
minute, 5 minute, hourly, or any time-frame - into high, low and close for that interval. So,
1 minute interval data in an 8 hour day, would result in 480, high, low, close (HLC) packets,
which represent the HLC for each minute. A 1 minute Point and Figure chart is then
constructed using either the close at the end of each minute or the high/low each minute,
giving a far more detailed chart than one constructed with end-of-day close or end-of-day
high/low. This opens up a huge range of Point and Figure charts to use, because you could
draw a 5 minute chart, a 1 0 minute, an hourly, or any intra-day time-frame you wish to
nominate."
"There are many Point and Figure purists who insist on using tick data only. Their
commitment is to be applauded. If the data is available for the period you require, then tick
data is the best. However, interval data is far easier to manage and the difference between 1
minute data and tick data is insignificant, especially if you use the high/low construction
method."
From the Definite Guide to P&F
- PebbleTrader
- rank: 1000+ posts
- Posts: 1633
- Joined: Fri Nov 12, 2010 2:15 am
- Reputation: 15
- Gender:
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...
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...
Life is just a journey
- PebbleTrader
- rank: 1000+ posts
- Posts: 1633
- Joined: Fri Nov 12, 2010 2:15 am
- Reputation: 15
- Gender:
MO,
can you post a higher resolution image of another pair besides EU you have been manually updating?
The one you posted earlier was so low resolution I can't read the numbers.
I want to test my code against another pair. I think your feed is MB isn't it? It should be identical to mine I bet.
can you post a higher resolution image of another pair besides EU you have been manually updating?
The one you posted earlier was so low resolution I can't read the numbers.
I want to test my code against another pair. I think your feed is MB isn't it? It should be identical to mine I bet.
Life is just a journey
Please add www.kreslik.com to your ad blocker white list.
Thank you for your support.
Thank you for your support.