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.


Free Market Profile Charting Tool

Recommended Posts



I'm new to the Market Profile.

After 6 months studying forex in my free time I finally found a method that I understand and which doesn't make me enter a position for some strange reason when a line (that i don't exactly know why has been placed there) is touched from the price.


I read here and there few books of Wiley Steidlmayer and I appreciate the theory behind the TPOs analysi. It gave me a more complete knowledge than many other books around which to a beginner like me looks like without rhyme or reason.

I instead less understood the part about the Market Profile with Volumes, maybe I'm not ready for that, even if I think would be really usefull.


So my analysis with MP are only about price movement and Bell Curve fullfilment, NO Volumes... also because finding the right, free datas about volumes would be impossible.


I'm a beginner so I don't wnat to spend money for something that will probably make me loose more money.


After have looked for a free software with TPOs I gave up and choose to make my own.


I finally developed an Excell worksheet (actually is made with OpenOffice Calc) with which is possible to visualize Market Profile charts after have inserted Highs and Lows from a simple copy/paste from the MT4 History Center.


Thanks to macros I've written is possible then to calculate automatically Value Area, Point of Control, Initial Balance, TPOs Count.


The file generates the profiles for an whole week.

In one sheet every day is splitted in asian and western session. In the other there are the whole days which are then joined toghether for shape the weekly market profile.


I use it with the forex spot, but I don't know if it is a good idea... I use the forex spot only because is the most accessible (I use alpari) to a beginner.


The truth is that I'm sharing this tool I made because I want to know if it is the correct way to interpret the MP with the Forex.

For instance I didn't know what to use as Initial Balance in a market opened 24h. So I choosed to consider the asian session as IB for the whole day, but I'm not sure this is the correct thing to do.


Maybe market profile should be used only with futures? but how can I trade futures in an easy way as the forex can offer?

do you have any market to suggest me which would be better to trade with the MP?


These are two images from my worksheet... you can also appreciate a perfect Bell curve for the weekly profile








I hope that my work can be of any itnerest for some other beginner and to receive some usefull help or suggestion on how to better use this tool.


If want the worksheet, just send me a private message on this forum or leave your email.

Share this post

Link to post
Share on other sites

There is a website by M. Jardine, who wrote a book on the Subject and posts futures trades, in advance, once a day or so when he is not traveling. He will not post a trade he dislikes (naturally) but the point is more about set-ups in advance that he think will work. enthios.com

Share this post

Link to post
Share on other sites
My email : premal24@yahoo.com . Please forward me the worksheet. I am using Market Profile for sometime now and would be able to guide if there is any change needed in the work you have done.


Hi I sent you the file.


I've a first question for you..


in my worksheet there's the possibility to chose the price scale step. With that I mean that each row of letters covers a range of price that I usually set at 10 pips. So if the High of a TPO is at 1.3449 and the low at 1.3441 it will place only a letter at the value 1.3440.


So changing this value (you can change it from the last sheet) you can obtain different view of the profile with different POC VA etc.. so what should it be the standard setup? 1 pip?



thanks for the site

Share this post

Link to post
Share on other sites

Today a strong move after the american Initial Balance brought the price to develope the POC exactly in the same level where was built the POC for last week.

Intersting, I don't know what does it mean, but interesting :haha:


I would say that america thinks the value is there at 1.3115, if price goes up again is probably going to go down at 1.3115 again..?

For sure during the american session last week has always been bearish.



Share this post

Link to post
Share on other sites

Hi gram;

I don't use or have MP software, I just need the daily VAL, POC, VAH for reference; so the question is if you know of a site from where I could download this info daily.

Many thanks in advance.


Share this post

Link to post
Share on other sites

Hi Sergio83,

I'll repost this as I see my e-mail did not show up.

I'd appreciate having a look at your software tool. I am also interested in using MP for forex and perhaps for commodities.




Many thanks,



Share this post

Link to post
Share on other sites


....These are two images from my worksheet... you can also appreciate a perfect Bell curve for the weekly profile








I hope that my work can be of any itnerest for some other beginner and to receive some usefull help or suggestion on how to better use this tool.


If want the worksheet, just send me a private message on this forum or leave your email.

Your tool seems excellent. If you don't mind yet another request, please send the spreadsheet to me at




In advance, many thanks.



Share this post

Link to post
Share on other sites



Going forward, there is no issue with you contacting each other but just posting your email address openly is not good practise. If I could suggest that anyone who wishes to request this file, private messages sergio83.





Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Topics

  • Posts

    • Actions for the 22nd.  I seem to be on a bad run, I'm really struggling with the opening minutes of the trades I'm taking and then get sucked into a little over trading.
    •   Date : 23rd January 2019.

      MACRO EVENTS & NEWS OF 23rd January 2019.

      FX News Today 10-year Treasury yields are down from overnight highs, but still up 0.7 bp at 2.746%, and 10-year JGB yields climbed 0.8 bp to -0.004%. Stock markets remained cautious during the Asian session. The Bank of Japan held policy steady, as expected, while further reducing its outlook for inflation. The resulting weakness in the Yen didn’t help stock markets and Topix and Nikkei dropped -0.60% and -0.14% respectively. The Hang Seng is also down -0.04%, despite mainland China markets initially moving higher as China’s central bank pumped liquidity into the banking system once again. Still, the measures are also a sign that officials are nervous about the slowdown in the economy and CSI 300 and Shanghai Comp are down -0.24% and -0.13%. The bank offered around 258 bln Yuan (USD 38 bln) to banks through its medium term lending tool. Markets continue to question the progress in the US-Sino trade talks, even though White House adviser Lawrence Kudlow said that the trade talks are still on and the story about cancelled preparatory meetings was “not true, there was never any meeting. We are moving toward negotiations.” The negotiations next week will be “very, very important” and “determinative”. Meanwhile, there are the first signs of a possible way out of the US government shutdown. Markets remain easily spooked, but appear to have already priced in a lot of risk last year and US stock futures are moving higher after yesterday’s sell off. Oil prices are trading at USD 53.27 per barrel. Charts of the Day

      Main Macro Events Today Canadian Retail Sales – After Wholesale Sales plummeted yesterday, Canadian Retail Sales are expected to have also declined by 0.4% m/m, with core Retail Sales (ex autos) expected to have declined by 0.6%. World Economic Forum at Davos –The second day of the WEF annual meetings held in Davos and attended by officials from over 90 countries. Comments from central bankers and other influential officials can create significant market volatility. Richmond Manufacturing Index – Expectations – The index is expected to have remained at a sub-zero level, standing at -2 after the -8 in the December release. Support and Resistance Levels

      Always trade with strict risk management. Your capital is the single most important aspect of your trading business.

      Please note that times displayed based on local time zone and are from time of writing this report.

      Click HERE to access the full HotForex Economic calendar.

      Want to learn to trade and analyse the markets? Join our webinars and get analysis and trading ideas combined with better understanding on how markets work. Click HERE to register for FREE!

      Click HERE to READ more Market news.

      Dr Nektarios Michail
      Market Analyst

      Disclaimer: This material is provided as a general marketing communication for information purposes only and does not constitute an independent investment research. Nothing in this communication contains, or should be considered as containing, an investment advice or an investment recommendation or a solicitation for the purpose of buying or selling of any financial instrument. All information provided is gathered from reputable sources and any information containing an indication of past performance is not a guarantee or reliable indicator of future performance. Users acknowledge that any investment in FX and CFDs products is characterized by a certain degree of uncertainty and that any investment of this nature involves a high level of risk for which the users are solely responsible and liable. We assume no liability for any loss arising from any investment made based on the information provided in this communication. This communication must not be reproduced or further distributed without our prior written permission.
    • USDJPY Eyes The 109.88 Resistance Zone And Beyond USDJPY eyes the 109.88 resistance zone beyond as it looks to resume its upside pressure. On the upside, resistance comes in at 110.00 level. A turn above here will turn attention to the 110.50 level. Further out, we expect a possible move towards the 111.00 level if the earlier resistance is invalidated out. The next resistance resides at the 111.50. Its daily RSI is bullish and pointing higher suggesting further strength. On the downside, support comes in at the 109.50 level where a break will target the 109.00 level. Below that level will turn focus to the 108.50 level and then lower the 108.00 level. On the whole, USDJPY faces further upside pressure on corrective recovery.  
    • $AVGR (AVGR) Avinger stock strong day w/ bottom breakout watch above 0.38,

      analysis https://stockconsultant.com/?AVGR
    • AUDUSD Weakens On Further Pullback Threats.  AUDUSD weakens on further pullback threats as it saw price extension during early trading on Tuesday. On the upside, resistance stands at the 1.7200 level. A cut through here will turn attention to the 0.7250 level and then the 0.7300 level. A violation will set the stage for a retarget of the 0.7350 level. Support resides at the 0.7100 level where a breach will aim at the 0.7050 level. Below here will set the stage for a run at the 0.7000 level with a cut through here targeting further downside pressure towards the 0.6950 level. On the whole, AUDUSD faces further downside threats.

Important Information

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