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.

sergio83

Free Market Profile Charting Tool

Recommended Posts

Hi,

 

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.

 

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.

 

 

Good work Sergio83! Very interesting analysis. Please share with me. jdevron@socal.rr.com

Share this post


Link to post
Share on other sites

Hi,

 

do you know, that there are EAs for MT4 to show MP?

You may choose days of looking back, if too much, MT4 will slow down though.

But nice, using MP with futures, you only have one session / day.

If using with FX, you have 1 day / 24 hrs.

The EA, I'm using, shows 3 sessions overlapping (Asian, London and US).

Mine is an old one (only looking for the pic and POCs), but I just googled, and there are some, which seems to be usable and are free to use too.

 

josch

Share this post


Link to post
Share on other sites

sorry everybody... after a while I forgot about this post..

 

you can download it form here; SergioMP.ods

 

and here an explanation

 

 

for use this worksheet you need OpenOffice Calc. Is like excell but you can download it for free from internet, just google it.

 

I've written two Macros in this worksheet, one deletes all the data inserted in the different day tables for high and lows (called Clean), the other calculate and visualize value area initial balance etc. (called SUBs)

 

if you don't know how to add a macro to an hotkey please follow this video from the minut 1.58:

[ame=http://www.youtube.com/watch?v=ORH6T3ZDh-E]Calc. How to create macro and set hot keys - YouTube[/ame]

 

In the worksheet there are 3 sheets for every day, you insert the open-high-low-close value for each half hour in the first sheet and automatically the prpofile will appear in the sheets with asia-western session and whole day session. For visualize value areas point of control and so on, you have to run the SUBs macro and wait few seconds.

 

i trade with EUR/USD forex spot., but the scale of the prices will change accordingly to the values you insert in the Highs-lows table.

In the "parametri" sheet there are few parameters you can change for adit the scale price step, or open-close time or the range of prices shown in respect to the open price of the week.

 

The macro SUBs will calculate every day that has an open price inserted, if there's also the closing price, the day will be calculated only if in the cell "i50" there's the number "1".

Share this post


Link to post
Share on other sites
sorry everybody... after a while I forgot about this post..

 

you can download it form here; SergioMP.ods

 

and here an explanation

 

 

for use this worksheet you need OpenOffice Calc. Is like excell but you can download it for free from internet, just google it.

 

I've written two Macros in this worksheet, one deletes all the data inserted in the different day tables for high and lows (called Clean), the other calculate and visualize value area initial balance etc. (called SUBs)

 

if you don't know how to add a macro to an hotkey please follow this video from the minut 1.58:

 

In the worksheet there are 3 sheets for every day, you insert the open-high-low-close value for each half hour in the first sheet and automatically the prpofile will appear in the sheets with asia-western session and whole day session. For visualize value areas point of control and so on, you have to run the SUBs macro and wait few seconds.

 

i trade with EUR/USD forex spot., but the scale of the prices will change accordingly to the values you insert in the Highs-lows table.

In the "parametri" sheet there are few parameters you can change for adit the scale price step, or open-close time or the range of prices shown in respect to the open price of the week.

 

The macro SUBs will calculate every day that has an open price inserted, if there's also the closing price, the day will be calculated only if in the cell "i50" there's the number "1".

 

Hai mr.sergio tq for your sharing ..... after i check your giving link it already dead . Hope u can attach new one because i want practice MP to improve my trading or who already have file can post here or can email me : newship_8@yahoo.com

Edited by za_xc03

Share this post


Link to post
Share on other sites

Hi Sergio,

 

I am studying Market profile now and interesting in it. Could you

 

share the excel to me ? I would like to do some experiments with it.

 

Thanks a lot.

 

Moreover, It would be more appreciated if you could share some experiences

 

and precautions. Thanks.

 

My Email : mxjiang.tw@gmail.com

 

 

 

 

 

 

I would be interested in having a copy of your profile tool to experiment with.

Share this post


Link to post
Share on other sites

My email is iratei@yahoo.com. Very interested as I find MP fascinating too. The big question is always How to determine if I should trade extreme prices back to the middle or go with a breakout?

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

Hi Guys I am new to market profile if anybody is having any working excel file especially for NSE stocks, I will highly appreciate your help. Thanks in advance. Please mail to ram.pgr@gmail.com

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

    • Date : 21st October 2021. Market Update – October 21 – Stocks & USD slip on big Earnings Day. USD (USDIndex 93.55) cools a tad and again tests 2-week low (93.47) Yields stronger again, Equities closed up, but FUTS are down (Nikkei -2% on stronger YEN and Yuan). Big day for Earnings – TESLA beat but revenue numbers disappointed some. Oil up on drawdown. Evergrande – Bad News $1.7bn sale of 51% of HK unit to Hopson OFF, $1.7bn sale of HK HQ OFF, $83.5m coupon default triggers tomorrow. Good News $260m bond coupon, extended by 3 mths US Yields (10yr closed higher at 1.63) & – now 1.6533% Equities moved ground higher USA500 +16 (+0.74%) at 4536 (NASDAQ –0.05%) – Big movers – Verizon +2.41% & ABBT +3.3% (PayPal – 4.91%) – USA500.F back to 4500. Asian equities weaker. New VIX contract at +1.49% at 19.60 USOil up on drawdown n strong demand at $82.00 after EIA inventories showed -400K vs build of 2.1m Gold holds at 4-day highs – $1785 FX markets – a recovering USD – EURUSD 1.1646, Cable down from 1.3830+ to 1.3800, & USDJPY – off 4-year highs and pivots at 114.00. European Open The December 10-year Bund future is down -16 ticks, US futures are also in the red. DAX and FTSE 100 futures are both down -0.45 and US futures are also in the red, with the NASDAQ underperforming again, after already closing slightly lower yesterday. Indices remain at high levels, but tapering concerns, the global energy rout and supply chain concerns are capping the outlook for global growth. Markets will continue to watch earnings reports and central bank comments, especially in the UK where officials clearly are laying the ground for an early lift off. Meanwhile the announcement of Weidmann’s departure has raised hopes that the ECB will push even more to circumvent the no-bailout clause permanently – after the end of PEPP, which already helped BTPs to outperform yesterday. Today – US Initial Jobless Claims, Philadelphia Fed Business Index, Existing Home Sales, EZ Consumer Confidence, EU Council Meeting, Fed’s Daly, Waller, RBA’s Lowe, Earnings: AT&T, Intel, American Airlines, Southwest Airlines, ABB, (bottleneck problems) Vivendi, Hermes, (beat) Pernod Ricard,(beat) Barclays, (Revenue big beat) Unilever (Sales miss). Biggest FX Mover @ (06:30 GMT) AUDJPY (-0.50%) Rejection of 86.25 this morning as Yen lifts after a very weak October. Faster MAs aligned lower, MACD signal line dips and & histogram slips significantly lower, RSI 40.00 off OS level, H1 ATR 0.189, Daily ATR 0.817. 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. Stuart Cowell Head Market Analyst HotForex 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.
    • Meet a maverick on Blockster   Blockster is a cryptocurrency social platform.   Blockster connects everyone within the blockchain industry into one place—all the cryptocurrencies, the teams behind the projects, as well as, the traders and investors. Communicate and network with the very core of the blockchain industry, and stay ahead of the market trends via Blockster.   Get insightful posts, reviews, breaking news, interesting comments, and latest updates from the world of cryptos, from Azeez Mustapha: https://blockster.com/AzeezMustapha46102 
    • Nice article send in here, do sharing other such articles and also share your experience of Forex Trading.
    • Never tried Forex Trading with software,  I am still learning. But someday, I would like to give it a shot. 
    • Date : 20th October 2021. Market Update – October 20 – USD bounces from 2-week low, Stocks & Yields higher. USD (USDIndex 93.70) recovers from test of 2-week low (93.47) Yields stronger, Equities closed strongly on good Earnings, Netflix beat big time (Subs 4.38m vs 3.86m. – globally now 213.6m) Squid Game watched in 142 million households in 94 countries. Biden expects a deal on infra budget, Chinese housing prices slow, and NK fired more missiles (non-ballistic today) into S. China Sea. US Yields (10yr closed higher at 1.6350) & touched 1.662 earlier – now 1.6495% Equities moved higher gaining momentum USA500 +33 (+0.74%) at 4519 (NASDAQ +0.71%) – Big movers – J&J +2.34% & APPL 1.18% – USA500.F higher into 4503. Asian equities higher (Nikkei +0.76%) VIX closed down again at 15.57 (a new 8-week low – VXN – (which measures Nasdaq volatility) – at lowest since February 2020) USOil down from 7-yr high, at $83.00 after private inventories – trades at $81.00 Gold holds at $1775 now from yesterday’s high of $1785 and low of $1767. FX markets – a recovering USD has – EURUSD 1.1640, Cable down from 1.3800+ after CPI data at 1.3785 & a weaker YEN, USDJPY – 4-year highs – 114.70. Overnight – UK CPI a tick weaker than expected (3.1% vs 3.2%) PPI in line. German PPI much stronger than expected @ 2.3% vs 1.1%. European Open – The December 10-year bund future is down 35 ticks, underperforming versus Treasury futures. Yields moved broadly higher across Europe yesterday and while ECB officials are doing their best to keep rate hike speculation at bay, they are fighting an uphill battle, especially as the BoE is preparing for an early lift off on rates. The surprise misses for UK CPI could dull the expectation. Today – EZ Final CPI, Canadian CPI, ECB’s Elderson, Fed’s Bullard, Earnings – Verizon, Tesla, IBM, Abbot, AMSL, Nestle (already out – a big beat especially for Pet food Division) Biggest FX Mover @ (06:30 GMT) NZDCHF (+0.40%) 5th consecutive day higher today (from 0.6425) breached 0.6600 earlier, and testing 0.6630 now. Faster MAs aligned higher, MACD signal line & histogram trending higher, RSI 65.00 OB but still moving higher, H1 ATR 0.0008, Daily ATR 0.0054. 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. Stuart Cowell Head Market Analyst HotForex 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.
×
×
  • Create New...

Important Information

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