Auction Market Value Theory & Analytics | Page 17 | Forex Factory

Options

Go to
Permalinks
Print Thread

Similar Threads

Auction Market Theory and Market Profile 26,026 replies

MarketProfile/Volume Profile/Auction Market Theory indi? 17 replies

ECN && STP && Scalping && Hedging - Broker Review - Oct 2009 24 replies

Auction Market Value Analytics Charts & Data 14 replies

Analytics, recommendations - S&P 500, Euro and other 11 replies

Attachments: Auction Market Value Theory & Analytics
Exit Attachments

Auction Market Value Theory & Analytics

  • #321
  • Sep 17, 2015 10:17am Sep 17, 2015 10:17am
Quote
Ouoting Mzvega
Quote
: I previously showed you some examples of how I currently manage the data using a database. I suggested using a database first because it will greatly simplify the process. But you did ask how I handled the data when I did use excel. It took me awhile to find my old files.
I would first use excel to build my profiles buy cutting & pasting 30m data into a excel sheet.




I have downloaded some MySQL and Liber Office pdf study materials. In the interim, I'll also have to learn how to work with macros and utilise your method of working with excel - pending when I'll learn MySQL and Liber Office. Meanwhile, my trading results have vastly improved since I started using AMVAT. It easily cures the ills of impatience, overtrading and greed. It's the best tool I've used so far.

Thanks for sharing your excel methods.
  • #322
  • Edited 2:03pm Sep 17, 2015 1:49pm | Edited 2:03pm
Quoting ocdavids
{quote} I have downloaded some MySQL and Liber Office pdf study materials. In the interim, I'll also have to learn how to work with macros and utilise your method of working with excel - pending when I'll learn MySQL and Liber Office. Meanwhile, my trading results have vastly improved since I started using AMVAT. It easily cures the ills of impatience, overtrading and greed. It's the best tool I've used so far. Thanks for sharing your excel methods.
It's great to see you're not intimidated by a little work. It definitely takes some effort. I still work with excel but I use "python" to accomplish my tasks in excel as macros can be slow and cumbersome.

Here is a screen recording of my End of Day analysis. It's still alittle crude as I am still a novice when it comes to "programming". I truly believe in this time and age most traders should have the ability to create and build their own tools for analysis. It shows you the speed in which python can read, write, & update excel files for all currency pairs. It takes about 2 minutes a day to do EOD analysis.
Updated:
Inserted Video


Here is a link to some libreoffice base videos I found to be very helpful to me
http://www.thefrugalcomputerguy.com/...base/Base1.php
Markets are not efficient, rather they are effective - Jones
  • #323
  • Oct 23, 2015 3:58am Oct 23, 2015 3:58am
Hi mzvega and Evak,

first, thank you for your posts. Iam studying the method too. I like your idea to include the 1 day profile into the composite profiles by bandung.
I have read works by Jones, Steidlmayer, Dalton, Mesch, Alexander and Hawkins. Iam familiar with market profile and meta profile.

I have some questions. I think the theory is very simple but I still try to understand some practical things.

1. How do you deal with elongated daily profiles? Do you trade the pause/node breaks? Or do you wait until the market comes into balance/bracket?

2. How do you think about responsive buying/selling? Or do you only trade breakouts from daily/3day brackets?

3. What about the sundays? I try to keep them out, because there is a wohle day missing in the statistics. I adjust my composite profiles daily. For example on mondays I use 4 last days (wednesday, thursday, friday, sunday) for 3 day overlays, to get 3 whole days.

4. What do you think about breakouts through daily Value Zones? Jones showed an example trade on his homepage. http://www.cisco-futures.com/tdgmodeldev.html

thank you
Attached Image (click to enlarge)
Click to Enlarge Name: 20daybrackets.png Size: 115 KB
Attached Image (click to enlarge)
Click to Enlarge Name: valuebreak.png Size: 97 KB
Attached Image (click to enlarge)
Click to Enlarge Name: pausebreak.png Size: 116 KB

greetings
Chris
  • #324
  • Oct 23, 2015 11:39am Oct 23, 2015 11:39am
Quoting dljonesFan
1. How do you deal with elongated daily profiles? Do you trade the pause/node breaks? Or do you wait until the market comes into balance/bracket?
I don't trade daily profiles. As per Jones the intraday TF (Daily Profile) is not a long enough sample of data to determine the longer condition of the market. The 3day profile is the minimum used to determine "Balance". I use the daily profile "data" for the analytics, I do not trade the daily "profile"

Quoting dljonesFan
2. How do you think about responsive buying/selling? Or do you only trade breakouts from daily/3day brackets?
If I am being conservative usually use the 5day. However I will use the 3day if I am feeling more aggressive, or if the data supports it.

Quoting dljonesFan
3. What about the sundays? I try to keep them out, because there is a wohle day missing in the statistics. I adjust my composite profiles daily. For example on mondays I use 4 last days (wednesday, thursday, friday, sunday) for 3 day overlays, to get 3 whole days.
It is not an issue for me. Since friday is a incomplete day, I dont do my analysis until sunday EOD. My indicator doesnt plot a "sunday" profile. It somehow works itself out when you are viewing a 3day or higher. I use 00:00 gmt.

Quoting dljonesFan
4. What do you think about breakouts through daily Value Zones? Jones showed an example trade on his homepage. http://www.cisco-futures.com/tdgmodeldev.html
The link is not working, so I cant tell the context. I dont trade daily profiles. That methodology belongs to ""Market Profile". MP has a 70% value area, AMVT uses 3 tpo's to determine the edges of value. Daily "value area" using MP is not the same as a 1day composite. As per Jones, 1 days data is not enough information to determine the longer condition of the market.

Give me a while to respond to your photos. only one of them is labeled. It will take a second to figure out what pairs you are refering to.
Markets are not efficient, rather they are effective - Jones
  • #325
  • Edited 1:16pm Oct 23, 2015 12:58pm | Edited 1:16pm
Quoting dljonesFan
{image}
Since I trade AMVT, I would not have thought to short. Again 1 day of data is not a large enough sample to determine longer term changes in the market. But those who trade MP concepts would think to do so.

AMVT methodology asks what has been the condition of the market as of late? The data says we have been trending. And daily volatility is steady. There is nothing in the data that suggests a change in the current condition of the trending market.

The daily net flow(reference points) are all net positive. The probabilities of the market continuing with the current trend are very high. And the flow is net positive, suggesting higher prices. In this example I would be looking to trade a break of the 10day profile. All other profiles are trending. The 10day bracket seems to be a pause in the longer TF trend.

Where you would think to short at yesterdays value area is the best place to enter to resume the current direction of the trending market.
The data needs to support the profile.
Attached Image(s) (click to enlarge)
Click to Enlarge Name: valuebreak.jpg Size: 384 KB
Click to Enlarge Name: Capture.JPG Size: 463 KB
Click to Enlarge Name: Capture1.JPG Size: 287 KB
Markets are not efficient, rather they are effective - Jones
  • #326
  • Oct 23, 2015 2:07pm Oct 23, 2015 2:07pm
Quoting dljonesFan
Hi mzvega and Evak, first, thank you for your posts. Iam studying the method too. I like your idea to include the 1 day profile into the composite profiles by bandung. I have read works by Jones, Steidlmayer, Dalton, Mesch, Alexander and Hawkins. Iam familiar with market profile and meta profile. I have some questions. I think the theory is very simple but I still try to understand some practical things. 1. How do you deal with elongated daily profiles? Do you trade the pause/node breaks? Or do you wait until the market comes into balance/bracket?...
In AMVT one would have already been short, since the trend is several days old. One would either look to exit the existing downward trend, Take some profits, or just hold. However the data is suggesting the trend is slowing, coming to an end, or pause. The daily flow data is neutral. Not indicating a continuation of the current trend. Its suggesting a trend end or pause. I use the daily profile data for analysis; I dont trade the daily profile itself. I personally would pass on trading this chart.
Attached Image(s) (click to enlarge)
Click to Enlarge Name: Capture.JPG Size: 445 KB
Click to Enlarge Name: Capture1.JPG Size: 338 KB
Attached Image
Markets are not efficient, rather they are effective - Jones
  • #327
  • Oct 23, 2015 3:06pm Oct 23, 2015 3:06pm
Quoting dljonesFan
Hi mzvega and Evak, first, thank you for your posts. Iam studying the method too. I like your idea to include the 1 day profile into the composite profiles by bandung. I have read works by Jones, Steidlmayer, Dalton, Mesch, Alexander and Hawkins. Iam familiar with market profile and meta profile. I have some questions. I think the theory is very simple but I still try to understand some practical things. 1. How do you deal with elongated daily profiles? Do you trade the pause/node breaks? Or do you wait until the market comes into balance/bracket?...
Your remaining chart is gbpjpy. I don’t track the data for that pair in my database. Sorry. I really can’t give an opinion without seeing the analytical data that accompanies the pair. I’d trade a break of the 3 or 5day. We broke the 20day yesterday.(my chart slightly different) I have an imbalance of buyers over sellers on the 20day. With the limited data that I can see, the 3day also has an imbalance of buyers over sellers, and intraday there is an imbalance of buyers over sellers. Since the imbalance favors “buyers” I’d get long on a break of the 3 or the 5. But my settings are slightly different from yours. My settings see the 20 day break as happening yesterday. My question today is will it continue or not. The limited data imo says a break of the 5 would confirm yesterdays 20day break. But however, the analytical data may suggest something else.
Maybe Evak could give you a few answers. He is more aggressive in his trades than I. He trades lower tf's more frequent than I.
Attached Image (click to enlarge)
Click to Enlarge Name: Capture.JPG Size: 269 KB
Attached Image
Markets are not efficient, rather they are effective - Jones
  • #328
  • Oct 23, 2015 3:50pm Oct 23, 2015 3:50pm
Quoting dljonesFan
4. What do you think about breakouts through daily Value Zones? Jones showed an example trade on his homepage. http://www.cisco-futures.com/tdgmodeldev.html thank you{image}{image}{image} greetings Chris
The prerequisite for those examples is always the same one. A 5day balance is a prerequisite for all of those examples. If you read it in its entirety it also explains why you wouldn’t trade a break out of the daily profile while the 5day is in balance. Depending where the daily profile lies within the 5day balance. The example shows that to do so, could be initiating a long term position within a balanced region.
If you do trade a daily profile it should always be done in the context of a 5day balance.
Markets are not efficient, rather they are effective - Jones
  • #329
  • Edited 12:29pm Oct 25, 2015 9:14am | Edited 12:29pm
Hello mzvega,

thank you for your answer. Very impressive. I like how you deal with daily flow data.

"It is not an issue for me. Since friday is a incomplete day, I dont do my analysis until sunday EOD. My indicator doesnt plot a "sunday" profile. It somehow works itself out when you are viewing a 3day or higher. I use 00:00 gmt."

I have noticed that your composite profile indicator is different from mine. I use the MP-Multi Composite Profiles.ex4 from

http://www.fxindi.net/2015/05/market...composite.html

I thougth we are using the same.

1.Which composite indicator are you using?

2.Can you show me how to deal with daily flow data? Is this the Market Flow analysis discribed by Jones?

http://www.cisco-futures.com/daytrad..._example1.html

have a nice sunday
Chris
  • #330
  • Edited 2:03pm Oct 25, 2015 1:25pm | Edited 2:03pm
Quoting dljonesFan
Hello mzvega, thank you for your answer. Very impressive. I like how you deal with daily flow data. "It is not an issue for me. Since friday is a incomplete day, I dont do my analysis until sunday EOD. My indicator doesnt plot a "sunday" profile. It somehow works itself out when you are viewing a 3day or higher. I use 00:00 gmt." I have noticed that your composite profile indicator is different from mine. I use the MP-Multi Composite Profiles.ex4 from http://www.fxindi.net/2015/05/market...composite.html I thougth we are...
The indicators are virtually identical. The only difference is the settings.

In my settings you see that Sunday is in orange. However, you cant see the orange in any of my profiles.

A 24h cycle begins at 00:00gmt and ends at 23:59 gmt. Friday is incomplete cycle, so is Sunday. Together they complete a cycle. But it really depends on the settings. Some people use their Brokers open time as a place to start the daily profiles or certain trading session. Only people who use candlesticks care about when & what time a candle opens. This causes everyone to have a very subjective opinion when a profile begins and ends. Then you throw in daylight savings.

In the past when I use to think it relevant to use my brokers time, or euro open time, Id lose about a month of trading adjusting changing fixing indicator settings.

Keeping it universal eliminates the headache of all those GMT shifts & times. I live -8gmt Calif, "today" for me is usually always "yesterday" that's confusing enough then brokers time is still 3h ahead of me. Then I have to figure that out. It's a nightmare...... I keep it simple.....00:00 gmt will always be 00:00 gmt

00:00 GMT will always be 00:00 GMT, no matter what time of the year it is or where you live in the world. It might make a difference to someone who trades market profile concepts where you are comparing one days profile from the previous days profile.

In AMVT we are not comparing todays profile with yesterdays profile at all. That is a concept that belongs to legacy market profile charts.
Ive included my indicator settings. I am currently using an old indicator that Bandung gave me to use for beta testing as we made sure it was consistent with Ciscos Long Home study course material. However the one you are using is the most recent version. But the indicator is identical, our settings are just different.
Attached Image(s) (click to enlarge)
Click to Enlarge Name: 1.JPG Size: 143 KB
Click to Enlarge Name: 2.JPG Size: 254 KB
Markets are not efficient, rather they are effective - Jones
  • #331
  • Edited 2:18pm Oct 25, 2015 1:48pm | Edited 2:18pm
Quoting dljonesFan
2.Can you show me how to deal with daily flow data? Is this the Market Flow analysis discribed by Jones? http://www.cisco-futures.com/daytrad..._example1.html have a nice sunday Chris
It absolutely is........
You have to first get the data.......click the export feature on your indicator
Then open the Data Folder in mt4.............
Then open the Files folder.......
the data for the exported data should be in there
The data is done in horizontally and vertically. It also contains .dat files.
Once you have the data you need, apply it as described by Jones
Attached Image (click to enlarge)
Click to Enlarge Name: export 2 (1).JPG Size: 566 KB
Attached Images
Markets are not efficient, rather they are effective - Jones
  • #332
  • Oct 25, 2015 2:43pm Oct 25, 2015 2:43pm
Quoting dljonesFan
Hello mzvega, thank you for your answer. Very impressive. I like how you deal with daily flow data. "It is not an issue for me. Since friday is a incomplete day, I dont do my analysis until sunday EOD. My indicator doesnt plot a "sunday" profile. It somehow works itself out when you are viewing a 3day or higher. I use 00:00 gmt." I have noticed that your composite profile indicator is different from mine. I use the MP-Multi Composite Profiles.ex4 from http://www.fxindi.net/2015/05/market...composite.html I thougth we are...
Here are a few links that are relevant to Market Flow analysis.
http://www.cisco-futures.com/daytrad...tickstudy.html
http://www.cisco-futures.com/daytrad..._example1.html
http://www.cisco-futures.com/daytrad..._example2.html
http://www.cisco-futures.com/market_flow.html
Markets are not efficient, rather they are effective - Jones
  • #333
  • Oct 25, 2015 3:15pm Oct 25, 2015 3:15pm
Mzvega,

thank you for the links, I will have a look tomorrow.

I love Cali, I was visiting L.A. 3 weeks ago.

greetings
Chris
  • #334
  • Oct 26, 2015 2:29pm Oct 26, 2015 2:29pm
dljonesFan,

Librebase opens excel files. Go to “File”, Select “Open”, go to stored file and “Click”
Excel example
Attached Image(s) (click to enlarge)
Click to Enlarge Name: exanple2.JPG Size: 157 KB
Click to Enlarge Name: example.jpg Size: 163 KB
Markets are not efficient, rather they are effective - Jones
  • #335
  • Edited 6:57am Oct 27, 2015 6:25am | Edited 6:57am
Thank you for your help. Without you, I would be lost with this excel coding.
I proudly present my netflow-macro. First I started with day to day macro then, I coded 3 day net flow relations. Iam happy, thank you. Now comes the analysing part...
Attached Image (click to enlarge)
Click to Enlarge Name: netflow.PNG Size: 60 KB
  • #336
  • Oct 27, 2015 11:35am Oct 27, 2015 11:35am
Quoting dljonesFan
Thank you for your help. Without you, I would be lost with this excel coding. I proudly present my netflow-macro. First I started with day to day macro then, I coded 3 day net flow relations. Iam happy, thank you. Now comes the analysing part... {image}
I am extremely impressed!

Here is a spreadsheet that contains a macro that will import the file directly to the spreadsheet, eliminating cut & paste

Place a folder on your in your C: drive, Name it "Pairs" (this is to avoid having to open & edit the file location in the macro to match you computer)

Get any of the files and rename it "AUDJPY" (for this example) and place it in the "Pairs" folder.

When you open the excel spreadsheet, on the data sheet press the import button.

This will go to the Pairs folder, import the file to the import sheet, and sort it.

This will automatically update the first three rows of the data sheet (Blue area).

When theres a new day rename the new file "AUDJPY" file and place it in the Pairs folder.

Open the spread sheet and press import, it will import & update the spreadsheet with new data.

All you have to do is put your calculations in the data sheet along with your macro. You can also create a new macro that calls both macros. Keeping with a one button solution

You can get the excel file here http://www.4shared.com/file/4t2Z8omxce/Import.html#
FF wont allow me to upload a "macro-enabled" file here.

Again, very impressive!
Attached Image(s) (click to enlarge)
Click to Enlarge Name: 2.JPG Size: 221 KB
Click to Enlarge Name: 1.JPG Size: 69 KB
Markets are not efficient, rather they are effective - Jones
  • #337
  • Edited 2:30pm Oct 27, 2015 2:10pm | Edited 2:30pm
Hi Claudia

I thought I see my name being mentioned so better make a courtesy call here

In response to dljones questions in short & in no particular order;

1: I don't take responsive trade due to my trading schedule but in any case i have try to avoid it totally.
2: 5 days balance is my minimum right now. 3days only if it is very balance but do bear in mind most of the trades will be taken off from5 & 10 days overlay, 20days is seldom
3: Continuation trade (add) after a breakout successful break will only be taken if price have broken both 5 & 10 days as a minimum & trade is holding. In most cases the next day overlay for 5 & 10 days will likely be a double or more distribution overlay. You will have to remain cautious ( if you still holding on to a trade) if it is still bracketing as it may indicate a weak breakout after a long pause. Mzvega's method of run-pause & VTY analysis may provide additional info.
4: I avoid placing any trade on monday. So is a no trade day unless there is some chaos in the market that may increase Mondays volatility. VTY in most cases will be way above average.
5: Stop loss should not be less then 2 or 2.5xVTY ( if you use a 20day value). If in anycase the UO value is less the that. Then either use the 2 or 2.5xVTY as stop loss or the UQ value.

Just to add; for NON AUD NZD JPY pairs, I will not place any trade during Asia session. I will only place those pairs withe.g GPD CHF USD, just prior to UK opening.

Hope i answer some of your questions.
  • #338
  • Oct 27, 2015 3:37pm Oct 27, 2015 3:37pm
Quoting Evak
Hi Claudia I thought I see my name being mentioned so better make a courtesy call here In response to dljones questions in short & in no particular order; 1: I don't take responsive trade due to my trading schedule but in any case i have try to avoid it totally. 2: 5 days balance is my minimum right now. 3days only if it is very balance but do bear in mind most of the trades will be taken off from5 & 10 days overlay, 20days is seldom 3: Continuation trade (add) after a breakout successful break will only be taken if price have broken both 5 &...
Well Hello Stranger!!!!

It’s always a great privilege when you drop in.
What a great set of answers! I couldn’t agree more, your answers are imo the soundest set of guidelines worth following. I don’t think there could be any better of a guideline to follow..........
Markets are not efficient, rather they are effective - Jones
  • #339
  • Oct 28, 2015 3:51am Oct 28, 2015 3:51am
Hi mtvega and evak

thank you Evak for your answers. Very helpfull.
Mzvega, thank you for showing me the trick with the macro (importing the data without copy/paste). Today I will try to implement this.

Are you using the FOM or the advice engine discribed by Jones? The hompage is currently down. source: www.cisco-futures.com/aesearch_dj_sp.html
Attached Image (click to enlarge)
Click to Enlarge Name: fom.PNG Size: 51 KB
  • #340
  • Oct 28, 2015 4:54am Oct 28, 2015 4:54am
Quoting dljonesFan
Hi mtvega and evak thank you Evak for your answers. Very helpfull. Mzvega, thank you for showing me the trick with the macro (importing the data without copy/paste). Today I will try to implement this. Are you using the FOM or the advice engine discribed by Jones? The hompage is currently down. source: www.cisco-futures.com/aesearch_dj_sp.html {image}
I don’t have much need to use Cisco’s Advice Engine. With the export data I accomplish the same thing by importing all data files into my database.

The Cisco advice engine is Cisco’s database and it provides you with analysis Market Flow, Daily Bracket Screen, etc., For the Futures Market.

However you can do the analysis on your own. Instead of accessing their database for a daily list of all Bracketing pairs for potential trades. In the export files there is a “Dist” column. If it equals ”1” there is only 1 distribution that means “Bracketing” any other number means multiple distributions means “trending”.

In excel, if you take the first row from every file and put them on a spreadsheet. Sort the sheet by the “Dist” column and all the rows at the top of the list will be all bracketing pairs you might for opportunity to trade.

I put all the files into my database, and just tell it to search the database and give me a daily list of all bracketing pairs I will use to look for trading opportunities. You can accomplish the same analysis yourself. You can pay someone to provide the data analysis for you, but the export data contains all the data need to do the analysis yourself.
Attached Image (click to enlarge)
Click to Enlarge Name: Capture.JPG Size: 438 KB
Markets are not efficient, rather they are effective - Jones
2 traders viewing now