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: 3rd April 2025.   Gold Prices Pull Back After Record High as Traders Eye Trump’s Tariffs.   Key Takeaways:   Gold prices retreated after hitting a record high of $3,167.57 per ounce due to profit-taking. President Trump announced a 10% baseline tariff on all US imports, escalating trade tensions. Gold remains exempt from reciprocal tariffs, reinforcing its safe-haven appeal. Investors await US non-farm payroll data for further market direction. Fed rate cut bets and weaker US Treasury yields underpin gold’s bullish outlook. Gold Prices Retreat from Record Highs Amid Profit-Taking Gold prices saw a pullback on Thursday as traders opted to take profits following a historic surge. Spot gold declined 0.4% to $3,122.10 per ounce as of 0710 GMT, retreating from its fresh all-time high of $3,167.57. Meanwhile, US gold futures slipped 0.7% to $3,145.00 per ounce, reflecting broader market uncertainty over economic and geopolitical developments.   The recent rally was largely fueled by concerns over escalating trade tensions after President Donald Trump unveiled sweeping new import tariffs. The 10% baseline tariff on all goods entering the US further deepened the global trade conflict, intensifying investor demand for safe-haven assets like gold. However, as traders locked in gains from the surge, prices saw a modest retracement.   Trump’s Tariffs and Their Market Implications On Wednesday, Trump introduced a sweeping tariff policy imposing a 10% baseline duty on all imports, with significantly higher tariffs on select nations. While this move was aimed at bolstering domestic manufacturing, it sent shockwaves across global markets, fueling inflation concerns and heightening trade war fears.   Gold’s Role Amid Trade War Escalations Despite the widespread tariff measures, the White House clarified that reciprocal tariffs do not apply to gold, energy, and ‘certain minerals that are not available in the US’. This exemption suggests that central banks and institutional investors may continue favouring gold as a hedge against economic instability. One of the key factors supporting gold is the slowdown that these tariffs could cause in the US economy, which raises the likelihood of future Federal Reserve rate cuts. Gold is currently in a pure momentum trade. Market participants are on the sidelines and until we see a significant shakeout, this momentum could persist.   Impact on the US Dollar and Bond Yields Gold prices typically move inversely to the US dollar, and the latest developments have pushed the dollar to its weakest level since October 2024. Market participants are increasingly pricing in the possibility of a Fed rate cut, as the tariffs could weigh on economic growth.   Additionally, US Treasury yields have plummeted, reflecting growing recession fears. Lower bond yields reduce the opportunity cost of holding non-yielding assets like gold, making it a more attractive investment.         Technical Analysis: Key Levels to Watch Gold’s recent rally has pushed it into overbought territory, with the Relative Strength Index (RSI) above 70. This indicates a potential short-term pullback before the uptrend resumes. The immediate support level lies at $3,115, aligning with the Asian session low. A further decline could bring gold towards the $3,100 psychological level, which has previously acted as a strong support zone. Below this, the $3,076–$3,057 region represents a critical weekly support range where buyers may re-enter the market. In the event of a more significant correction, $3,000 stands as a major psychological floor.   On the upside, gold faces immediate resistance at $3,149. A break above this level could signal renewed bullish momentum, potentially leading to a retest of the record high at $3,167. If bullish momentum persists, the next target is the $3,200 psychological barrier, which could pave the way for further gains. Despite the recent pullback, the broader trend remains bullish, with dips likely to be viewed as buying opportunities.   Looking Ahead: Non-Farm Payrolls and Fed Policy Traders are closely monitoring Friday’s US non-farm payrolls (NFP) report, which could provide critical insights into the Federal Reserve’s next policy moves. A weaker-than-expected jobs report may strengthen expectations for an interest rate cut, further boosting gold prices.   Other key economic data releases, such as jobless claims and the ISM Services PMI, may also impact market sentiment in the short term. However, with rising geopolitical uncertainties, trade tensions, and a weakening US dollar, gold’s safe-haven appeal remains strong.   Conclusion: While short-term profit-taking may trigger minor corrections, gold’s long-term outlook remains bullish. As global trade tensions mount and the Federal Reserve leans toward a more accommodative stance, gold could see further gains in the months ahead.   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 HFM Economic calendar.   Want to learn to trade and analyse the markets? Join our webinars and get analysis and trading ideas combined with better understanding of how markets work. Click HERE to register for FREE!   Click HERE to READ more Market news.   Andria Pichidi HFMarkets   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 Leveraged 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.
    • AMZN Amazon stock, nice buying at the 187.26 triple+ support area at https://stockconsultant.com/?AMZN
    • DELL Dell Technologies stock, good day moving higher off the 90.99 double support area, from Stocks to Watch at https://stockconsultant.com/?DELL
    • MCK Mckesson stock, nice trend and continuation breakout at https://stockconsultant.com/?MCK
    • lmfx just officially launched their own LMGX token, Im planning to grab a couple of hundred and maybe have the option to stake them. 
×
×
  • Create New...

Important Information

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