MP on excel

[gomes]

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.

[TinGull]

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

[gomes]

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

[TinGull]

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

[bobajob]

OK I have a number of Market Profile tools for excel having studied it for about 3 years. If you're still interested I will elaborate.

[bobajob]

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

[bobajob]

Here's the link:

MEGAUPLOAD - The leading online storage and file delivery service

[gomes]

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

[Soultrader]

Thank you very much Nick. This is amazing.

[bobajob]

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