Jump to content

Welcome to the new Traders Laboratory! Please bear with us as we finish the migration over the next few days. If you find any issues, want to leave feedback, get in touch with us, or offer suggestions please post to the Support forum here.

  • Welcome Guests

    Welcome. You are currently viewing the forum as a guest which does not give you access to all the great features at Traders Laboratory such as interacting with members, access to all forums, downloading attachments, and eligibility to win free giveaways. Registration is fast, simple and absolutely free. Create a FREE Traders Laboratory account here.

gomes

MP on excel

Recommended Posts

Hi, everybody.

First of all I want to thank you people who started this forum and all the participants that contribute.

I have a question about MP software. I want to be able to have MP on the excel spreadsheet. If anyone knows where I can find the MP code for excel I appreciate if you would share it. I have a MP software. I am looking for this learning and testing purposes. Thanks in advance.

Share this post


Link to post
Share on other sites

Hi Gomes,

 

I've known only one other person who's had Market Profile in an excel spreadsheet, and that was inputted by hand. Out of curiosity....what learning and testing are you looking to do? There may be things that either I or others can run for you.

 

Chris

Share this post


Link to post
Share on other sites

Hi, Chris

thank for your fast reply.

What I am looking to do with excel spreadsheet is front running the numbers and before it happens I want to see how the MP will look like. It is kind of a projections. things that I don't see on the software. exp If I have the excel spreadsheet I can run the market price higher or lower and can see the changes in the profile before the bracket ends. Things like that would be very beneficial for my understanding of MP. Looking for your responds

Humberto

Share this post


Link to post
Share on other sites

Very interesting idea...I've never heard of anyone wanting to do that sort of thing. So...if I'm understanding correctly, you want to be able to input prices that haven't yet traded, just to see what the profile would end up looking like if the prices do trade there? What insights would be gained from this sort of thing? I'm intrigued :)

Share this post


Link to post
Share on other sites

OK Here is my MP excel file. It has a number of features:

 

Sheet one is for data - only for reference in this version - mine has a dynamic link to quote.com so it will plot market profile in real time.

 

Sheet 2 is the 30 minute analysis. Cut and paste the high and low prices from your data and then paste special transpose. The profile will be created lower down.

 

Sheet 3 is very interesting. Here I have a 5 minute analyser. This plots half hour profiles with 5 min data. It also has a composite that shows how the profile is building up with each new half hour.

 

I am currently doing a kind of simulation with this to learn how to trade properly. It is going really well.

 

I am trying to put this into another language for a stand alone program.

 

The file is quite big - I have got MP for the whole of 2003 in the last sheet.

 

Regards,Nick

Share this post


Link to post
Share on other sites

Hi Nick,

I don't know how to thank you. I can't tell you that when I saw your reply that you are sharing your 3 years work (easy to say) and this is so much for me. I think this is something that I don't forget. You are very nice person. I will download it right away. Thanks a million.

Best Regards

Humberto

Share this post


Link to post
Share on other sites

small point lads - there is a slight error in the code - you will have to download it again I'm afraid. the small problem is that the bottom tick of the 5 minute profile did not show. I have corrected this.

 

MEGAUPLOAD - The leading online storage and file delivery service

 

Obviously if you want help on how to use this tool just give me a shout. I'm glad it's helpful.

 

Regards

Share this post


Link to post
Share on other sites

Out of interest for all of you to be converted from pivot points to Market Profile I have attached a file showing the high and the low only of each day. The red lines on the left side show the pivot levels. The market on the left are the same days as on the right, but on the right they are market profile. You can clearly see the support and resistance at work instead of the arbitrary pivot numbers.

 

Regards

 

MEGAUPLOAD - The leading online storage and file delivery service

Share this post


Link to post
Share on other sites

Hi, Nick

I downloaded your excel file. On first sheet (ES data) I didn't see MP, I think this is because I don't have a real time data feed into excel thats why I wasn't able to see MP. Correct me if I am wrong. And I have a question whenever you have a time to answer. On second sheet (daily analyze) I was able to create a MP with yesterdays data and I was amazed. But I couldn't see the Value Area numbers. I think I looked at everywhere on the sheet. If you please point me where and how I can see Value Areas I will appreciate. Thanks again for your hard work and sharing.

Best Regards Humberto

Share this post


Link to post
Share on other sites

I'm working on MP with Excel and have developped a spreadsheet to be able to see MP in it. I'm using Bloomberg as a datafeed so if some other people have BB and are interested in it, I could give you a version of the spreadsheet.

 

If others are interested, let me know maybe I could do some quick changes in the spreadsheet to allow you to work with it from a csv file.

 

I'm interested in sharing it cause the spreadsheet is still in development and I would like to have some feedback concerning calculations and also for improvements.

 

I joined a screenshot of EURUSD market profile.

 

Ryker

MPExcel.png.448424cde7b9224af3a87384bbc29792.png

Share this post


Link to post
Share on other sites

this is one of the things i dislike about MP - is that people get so dogmatic about it.

 

i use MP. i also use floor traders pivots.

 

they BOTH work.

 

but so many times, I see adherents of MP theory saying that various NON MP levels are "arbitrary" or some such

 

floor trader pivots were invented, and have been used by floor traders for decades.

 

 

i could sit and cherry pick charts that would (falsely) "prove" that MP levels don't work either.

 

fwiw, despite many claims, MP also has "arbitrary" aspects to it. why should 70% be the value area? why not 75% 65% 50% etc.?

 

it's just as arbitrary.

it works, that's the point

Share this post


Link to post
Share on other sites

Ok dalby - first to your point - you're right maybe I should keep my trap shut with regard to pivots - but I must add that I give no credence to the 70% value area either. Go with what you know. That is why - gomes - you will not find any value area on my chart. Plus they are a nightmare do mechanically. Also gomes the first sheet is just data, that's it there should be nothing else. In my sheet that will update from quote.com - I have to add that ryker's sheet looks far better than mine in plotting MP. My sheet is for MP training offline and can be used to determine how the trading day is developing. I have used it for pattern recognition of MP instead of bar charts.

Share this post


Link to post
Share on other sites

70% is because it's the closest round number to 1 standard deviation of a bell curve, which is what a perfectly balanced profile is. 70% is by no means an arbitrary number. It represents a statistical figure.

Share this post


Link to post
Share on other sites

thegull i am aware of that - but it makes all kinds of assumptions about price variation in a "normal" curve vs. gaussian distributions

 

like i said. i USE market profile

 

i LIKE market profile

 

i also use floor trader pivots, and they both work

 

MP adherents ime are among the most dogmatic (just go to cisco-futures for examples) of traders, because I just see this constant "market profile is scientific and stuff and other methodologies are arbitrary" repeated time and time again.

 

there is no holy grail, there is no one best way.

Share this post


Link to post
Share on other sites

Ok, I joined the spreadsheet.

 

Please note:

  • You can plot many days as long as you have data (not too much because of restrictions in excel).
  • This is note the last version but as I'm still working on it and have made a lot of changes in it, I can't share it for now. Probably in the near future :).

 

Waiting for your feedbacks,

Thanks

MP - 0.024.xls

Share this post


Link to post
Share on other sites

I completely agree with you. You had just mentioned in a previous post that 70% was arbitrary. There is no one way, thats what is awesome about the markets. MP gives a great way to look at the markets, and I do use MP levels for my trading. I also use floor trader pivots and the basic hi and lo of the current and previous day. I don't use fibs or anything else, though. That stuff starts to get a little esoteric for my palette, but lots of people have success with it.

 

:) Didn't mean any offense, so hope none was taken.

Share this post


Link to post
Share on other sites

no offense taken. the issue with arbitrary is that it is a loaded word, and one that "sets me off" cause i see it so much from MP adherents.

 

floor trader pivots are established using a formula

 

the value area is established using a formula.

 

whether or not either formula is "arbitrary" is frankly, a matter of opinion.

 

also, the 1 standard deviation thing is solidly dependanty on the assumption that equity markets distribute price in a normal curve. there is a fair bit of evidence that this is not the case in many respects.

 

this is similar to how some people say the bollinger bands correctly establish a X standard deviation, when i think it is relatively clear that markets do not distribute prices normally.

 

if they did, market events like 1987 would have less than a one in a million chance of occurring (approximately) as is the case with several other market events that occur much more frequently

 

the markets are a chaotic feedback system, and there ARE many ways to succeed - i agree.

 

MP does not have the stranglehold on market understanding or methodology, and that was my point.

Share this post


Link to post
Share on other sites

lol

 

boba, you sound conflicted.

 

first you retract the statement, then you reassert it.

 

"I voted for it before I voted against it"

 

or something

 

...

 

:D

Share this post


Link to post
Share on other sites

i'm just having a laugh with ya dalby - problem with forums is you can't get over subtle points. No really no offence just kidding. Pivots work because people watch them - I understand that.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Topics

  • Posts

    • A custom Better Daily Range indicator for MT5 is now available on the Metaquotes website and directly in the MT5 platform. https://www.mql5.com/en/market/product/103800 The Better Daily Range indicator shows the previous trading day's price range on the current day's chart. Many traders mark out the previous day's high, low, and the current day's open before trading. This is not an average true range indicator (ATR). This is not an average daily range indicator (ADR). This is a daily range indicator (DR). This indicator shows horizontal maximum and minimum range lines. If your broker-dealer's MT5 platform shows Sunday bars, Sunday bars are not included as previous days. In other words, Monday uses Friday's price data (skips Sunday). This indicator also shows two 25% (of range) breakout lines: one that is 25% higher than the maximum range line, and one that is 25% lower than minimum range line. A middle range line is also shown. Immediately after the daily close of your broker-dealer, all five range lines update to the new daily values.   Many traders only trade during times of high volume/liquidity. The Better Daily Range indicator also shows five adjustable time separator lines: A local market open time line (a vertical line), A local market middle time A line (a vertical line), A local market middle time B (a vertical line), A local market middle time C (a vertical line), A local market close time (a vertical line), and A local market open price (a horizontal line). The location of the local market open price depends on your input local market open time. In other words, you input your desired market open time according to your local machine/device time and the indicator automatically shows all five session lines. When your incoming price bars reach your input local market open time line, the indicator automatically shows the price to appear at your input local market open time. If your broker-dealer's MT5 platform shows Sunday bars, the time separator lines do not show on a Sunday. Immediately after midnight local machine/device time, the five session time lines (vertical lines) are projected forward into the current day (into the future hours) and the local open price line is erased. The local open price line reappears when the price bars on the chart reach your input local open time (your local machine/device time).   The indicator has the following inputs (settings):   Chart symbol of source chart [defaults to: EURUSD] - Allows you to show data from another chart symbol other than the current chart symbol. Handy for showing standard timeframe data on an MT5 Custom Chart. Local trading session start hour [defaults to: 09] - Set your desired start hour for trading according to the time displayed on your local machine/device operating system (all times below are your local machine/device operating system times). The default setting, 09, means 9:00am. Local trading session start minute [defaults to: 30] - Set your desired start minute. The default setting, 30, means 30 minutes. Both the default hour and the default minute together mean 9:30am. Local trading session hour A [defaults to: 11] - Set your desired middle hour A for stopping trading when volume tends to decrease during the first half of lunch time. The default setting, 11, means 11:00am. Local trading session minute A [defaults to: 00] - Set your desired middle minute A. Both the default hour and the default minute together mean 11:00am. Local trading session hour B [defaults to: 12] - Set your desired middle hour B for the second half of lunch time. The default setting, 12, means 12:00pm (noon). Local trading session minute B [defaults to: 30] - Set your desired middle minute B. Both the default hour and the default minute together mean 12:30pm. Local trading session hour C [defaults to: 14] - Set your desired middle hour C for resuming trading when volume tends to increase. The default, 14, means 2:00pm. Local trading session minute C [defaults to: 00] - Set your desired middle minute C. Both the default hour and the default minute together mean 2:00pm. Local trading session end hour [defaults to: 16] - Set your desired end hour for stopping trading. The default setting, 16, means 4:00pm. Local trading session end minute [defaults to: 00] - Set your desired end minute for stopping trading. Both the default hour and the default minute together mean 4:00pm. High plus 25% line color [defaults to: Red]. High plus 25% line style [defaults to: Soid]. High plus 25% line width [defaults to 4]. High line color [defaults to: IndianRed]. High line style [defaults to: Solid]. High line width [defaults to: 4]. Middle line color [defaults to: Magenta]. Middle line style [defaults to: Dashed]. Middle line width [defaults to: 1]. Low line color [defaults to: MediumSeaGreen]. Low line style [defaults to: Solid]. Low lien width [defaults to: 4]. Low minus 25% line color [defaults to: Lime]. Low minus 25% line style [defaults to: Solid]. Low minus 25% line width [defaults to: 4]. Local market open line color [defaults to: DodgerBlue]. Local market open line style [defaults to: Dashed]. Local market open line width [defaults to: 1]. Local market middle lines color [defaults to: DarkOrchid]. Local market middles lines style [defaults to: Dashed]. Local market middles lines width [defaults to: 1]. Local market close line color [default: Red]. Local market close line style [Dashed]. Local market close line width [1]. Local market open price color [White]. Local market open price style [Dot dashed with double dots]. Local market open price width [1].
    • A custom Logarithmic Moving Average indicator for MT5 is now available for MT5 on the Metaquotes website and directly in the MT5 platform. https://www.mql5.com/en/market/product/99439 The Logarithmic Moving Average indicator is a moving average that inverts the formula of an exponential moving average. Many traders are known to use logarithmic charts to analyze the lengths of price swings. The indicator in this post can be used to analyze the logarithmic value of price on a standard time scaled chart. The trader can set the following input parameters: MAPeriod [defaults to: 9] - Set to a higher number for more smoothing of price, or a lower number for faster reversal of the logarithmic moving average line study. MAShift [defaults to: 3] - Set to a higher number to reduce the amount of price crossovers, or a lower for more frequent price crossovers. Indicator line (indicator buffer) can be called with iCustom in Expert Advisors created by Expert Advisor builder software or custom coded Expert Advisors: No empty values; and No repainting.
    • A custom Semi-Log Scale Oscillator indicator is now available for MT5 on Metaquotes website and directly in the MT5 platform. https://www.mql5.com/en/market/product/114705 This indicator is an anchored semi-logarithmic scale oscillator. A logarithmic scale is widely used by professional data scientists to more accurately map information collected throughout a timeframe, in the same way that MT5 maps out price data. In fact, the underlying logic of this indicator was freely obtained from an overseas biotech scientist. A log-log chart displays logarithmic values on both the x (horizontal) and y (vertical) axes, which generally produces a straight line that points up, down, or remains flat. A straight line is not very useful for trading markets because such a straight line is so smoothed that actual price values that appear over time are very far away from the line study. In contrast, a semi-log chart is only logged on one axis--generally, the y axis. Such a semi-log chart is well suited for trading markets because the time (x) axis is preserved in its original form while at the same time, providing a graduated y scale where the distance between price increments progressively increases as price rises higher (and decreases as price falls lower). This allows us to establish a zero level for a low price, clearly view trends on straighter angles, and clearly observe amplified price spikes at high prices. Accordingly, this indicator employs a semi-log scale on the y axis only. This indicator is anchored because it allows you to specify a start time for calculation of price bars. The settings are as follows: Year.Month.Day Hour:Minute - defaults to 1970.01.01 00:01 - if left on default setting, the indicator automatically detects the earliest price bar in chart history--even where the year 1970 is not in history. Notes appear in the indicator settings window. Size of first pip step to log - defaults to 135 - this default is suitable for higher timeframes such a MN1 (monthly), while 5 is suitable for lower timeframes such as M1 (minute). Ultimately, optimal settings will depend on the timeframe that you attach the indicator to, the level of price volatility within that timeframe, and start time that you choose. Remember... The semi-log formula calculates from low to high, so your start time must always be a major swing low. Again, notes appear in the indicator settings window. The standard (built-in) MT5 indicators that can be applied to the "Previous indicator's data" can be applied to this indicator. Indicator lines (indicator buffers) can be called with iCustom in Expert Advisors created by Expert Advisor builder software or custom coded Expert Advisors. The log scale Open, High, Low, and Close prices are buffers: No empty values; and No repainting.
    • A custom Gann Candles indicator is now available for MT5 on the Metaquotes website and directly in the MT5 platform. https://www.mql5.com/en/market/product/126398 This Gann Candles indicator incorporates a series of W.D. Gann's strategies into a single trading indicator. Gann was a legendary trader who lived from 1878 to 1955. He started out as a cotton farmer and started trading at age 24 in 1902. His strategies included geometry, astronomy, astrology, times cycles, and ancient math. Although Gann wrote several books, none of them contain all of his strategies so it takes years of studying to learn them. He was also a devout scholar of the Bible and the ancient Greek and Egyptian cultures, and he was a 33rd degree Freemason of the Scottish Rite. In an effort to simplify what I believe are the best of Gann's strategies, I reduced them into one indicator that simply colors your preexisting price bars when those strategies are in-sync versus out-of-sync. This greatly reduces potential chart clutter. Also, I reduced the number of input settings down to only two: FastFilter, and SlowFilter Both FastFilter and SlowFilter must be set to 5 or more, as noted in the Inputs tab upon attaching the indicator to your chart. Gann Candles works on regular time-based charts (M5, M15, M20, etc.) and custom charts (Renko, range bars, etc.). The indicator does not repaint. When using the default settings, blue candles form bullish price patterns, gray candles form flat (sideways) price patterns, and white candles form bearish price patterns. The simplest way to trade Gann Candles is to buy at the close of a blue candle and exit at the close of a gray candle, and then sell at the close of a white candle and exit at the close of a gray candle.
    • A custom Anchored VWAP with Standard Deviation Bands indicator for MT5 is now available on the Metaquotes website and directly through the MT5 platform. https://www.mql5.com/en/market/product/99389 The volume weighted average price indicator is a line study indicator that shows in the main chart window of MT5. The indicator monitors the typical price and then trading volume used to automatically push the indicator line toward heavily traded prices. These prices are where the most contracts (or lots) have been traded. Then those weighted prices are averaged over a look back period, and the indicator shows the line study at those pushed prices. The indicator in this post allows the trader to set the daily start time of that look back period. This indicator automatically shows 5 daily look back periods: the currently forming period, and the 4 previous days based on that same start time. For this reason, this indicator is intended for intraday trading only. The indicator automatically shows vertical daily start time separator lines for those days as well. Both typical prices and volumes are accumulated throughout the day, and processed throughout the day. Important update: v102 of this indicator allows you to anchor the start of the VWAP and bands to the most recent major high or low, even when that high or low appears in your chart several days ago. This is how institutional traders and liquidity providers often trade markets with the VWAP. This indicator also shows 6 standard deviation bands, similarly to the way that a Bollinger Bands indicator shows such bands. The trader is able to set 3 individual standard deviation multiplier values above the volume weighted average price line study, and 3 individual standard deviation multiplier values below the volume weighted average price line study. Higher multiplier values will generate rapidly expanding standard deviation bands because again, the indicator is cumulative. The following indicator parameters can be changed by the trader in the indicator Inputs tab: Volume Type [defaults to: Real volume] - Set to Tick volume for over-the-counter markets such as most forex markets. Real volume is an additional setting for centralized markets such as the United States Chicago Mercantile Exchange. VWAP Start Hour [defaults to: 07] - Set according to broker's or broker-dealer's MT5 server time in 24 hour format. For example, in the New York, United States time zone, 07 is approximately the London, United Kingdom business open hour. VWAP Start Minute [defaults to: 00] - Set according to broker's or broker-dealer's MT5 server time in 24 hour format. For example, 00 is on the hour with no delay of minutes within that hour. StdDev Multiplier 1 [defaults to: 1.618] - Set desired standard deviation distance between the volume weighted average price line study and its nearest upper and lower bands. For example, 1.618 is a basic Fibonacci ratio. Some traders prefer 1.000 or 1.250 here. StdDev Multiplier 2 [defaults to: 3.236] - Set desired standard deviation distance between the volume weighted average price line study and its middle upper and lower bands. For example, 3.236 is 1.618 (above) + 1.618. Some traders prefer 2.000 or 1.500 here. StdDev Multiplier 3 [defaults to: 4.854] - Set desired standard deviation distance between the volume weighted average price line study and its furthest upper and lower bands. For example, 4.854 is 1.618 (above) + 3.236 (above). Some traders prefer 3.000 or 2.000 here. VWAP Color [defaults to: Aqua] - Set desired VWAP line study color. This color automatically sets the color of the start time separators as well. SD1 Color [defaults to: White] - Set desired color of nearest upper and lower standard deviation lines. SD2 Color [defaults to: White] - Set desired color of middle upper and lower standard deviation lines. SD3 Color [defaults to: White] - Set desired color of furthest upper and lower standard deviation lines. Just to clarify, popular standard deviation bands settings are: 1.618, 3.236, and 4.854; or 1.000, 2.000, and 3.000; or 1.250, 1.500, and 2.000. Examples of usage *: In a ranging (sideways) market, enter a trade at the extremes of the standard deviation bands (SD3) and exit when price returns to the VWAP line study. Trade between SD1Pos and SD1 Neg, alternately buying and selling from one standard deviation line to the other. In a trending (rising or falling) market, enter a buy when a price bar opens above the VWAP line study, and exit at the nearest standard deviation band above (SD1Pos). Optionally, repeat the same trade but substitute SD1Pos for the VWAP, and SD2Pos for SD1. Reverse for sell; or Trade all lines (VWAP, SD1Pos, SD2Pos, and SD3Pos) in the same way. Again, reverse for sell. Indicator lines (indicator buffers) can be called with iCustom in Expert Advisors created by Expert Advisor builder software or custom coded Expert Advisors: No empty values; and No repainting.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.