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

    • Question: To those that had/have cancer, what were the signs that made you think “something is not right here” to make you go see a doctor? Answer: So, 5/25/2018, I woke up, got ready for work, and as I walked to my car, I started gagging. Like something was stuck in my throat and I needed to clear it. And then it went away.   But 10 minutes after that, I was T-boned at 40mph on the driver side door. But what made me see a doctor was while my muscles felt better and bruises were going away, the gagging still continued, I started having fevers, my neck felt swollen, I was having such a hard time breathing, and I'd have random sharp pains in my chest, but not from where the seat belt saved me.   2 weeks after the accident, I finally see an urgent care doctor, who looks me over, tells me I'm fine, but luckily requests a neck X-ray. And I ask for a chest X-ray, which he rolls his eyes but let me have (most of my pain was in the neck, so I understand).   The very next day, he calls and says “So, that chest X-ray shows there's a 4 inch mass on your heart and lungs, and your lungs have been filling up with fluid, as well as in your pericardial (heart) wall. We need you to come in tomorrow.”   Turns out the big mass, due to the accident, caused my heart and lungs to tear and fill with fluid, the swollen neck and gagging was caused by 2 metastasized tumors, and the fevers and weight loss were symptoms. Stage 4b Hodgkin's Lymphoma.   But thankfully, we went very aggressive with chemo (and had a lot of bad side effects that don't normally happen to patients), and now I'm about 16 months cancer-free. Yay lucky X-rays! Rachel Jurina, Quora Source: https://www.quora.com/To-those-that-had-have-cancer-what-were-the-signs-that-made-you-think-something-is-not-right-here-to-make-you-go-see-a-doctor   Profits from free accurate cryptos signals: https://www.predictmag.com/  
    • As a man, the reality of life is the harshest part. I don’t mind looking older or becoming weaker over time; it’s nature.   Have you ever heard that the only people who will be loved unconditionally are women and children? Men will only be loved as long as they can provide until they are no longer needed. It doesn’t matter if you already did your best to get your kids to the best school or get the best things for them, if you stop before they’re done with it, there will be no thank you. The only thing they will remember is that they have to quit school at 15, ignoring all the previous 15 years of life you provided for them. The only people who will accept you, no matter what, are your parents. But in this situation, you might be that ungrateful child.   EDIT: Wow, I didn’t think this would get so much attention.   For those who disagree, I can only say that everyone has their problem. If you don’t get the chance to face such a thing, be grateful. Remember, sometimes what you throw in the garbage is something that someone wishes ever to have.” – ElZee, Quora   Profits from free accurate cryptos signals: https://www.predictmag.com/    
    • The good thing i had noticed so far is that the traderpot value is also on the rise..
    • yup its a gradual rollout the right way in my opinion, its really good and its exciting for the sto in 2027
    • there is no avoiding loses to be honest, its just how the market is. you win some and hopefully more, but u do lose some. 
×
×
  • Create New...

Important Information

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