'Vegas Wealth Builder Part II' | Page 23 | Forex Factory

Options

Go to
Permalinks
Print Thread

Similar Threads

Vegas Wealth Builder - Part I 535 replies

Vegas Wealth Builder 1 reply

Vegas Wealth Builder 1 reply

Vegas Weath Builder question 1 reply

Question for VEGAS and others using Vegas system..... 2 replies

Attachments: 'Vegas Wealth Builder Part II'
Exit Attachments

'Vegas Wealth Builder Part II'

  • #441
  • Feb 18, 2006 8:48pm Feb 18, 2006 8:48pm
Hi,
Here is new version of excel file with GBPUSD 518 days data.

Enjoy!

Rex.
Attached File(s)
File Type: zip VWB II-rev2.zip   75 KB | 65,936 downloads
Chinese Forex Trader from China
  • #442
  • Feb 18, 2006 9:12pm Feb 18, 2006 9:12pm
Hi,

I just play around with the Range data from 518 days GBPUSD trading, here is some facts:

In the past 518 days trading, the range :
1, 2 days hit below 55 pips;
2, 48 days hit between 55 to 89 pips;
3, 211 days ...............89 to 144 pips;
4, 193 days ...............144 to 233 pips;
5, 64 days .................233 to 377 pips;

no single one days below 50 pips or above 377 pips. 78% of the time the range hit between 89 to 233 pips. 21% of the time hit blow 89 or above 233 pips.

Is there any magic number we can take to our trading ?

Rex.
Chinese Forex Trader from China
  • #443
  • Feb 18, 2006 11:47pm Feb 18, 2006 11:47pm
Bemac,

Thank you, but I think Rex deserves the credit for this. I only regrouped his data.

I had not thought of using the fib numbers to compare. Amazing how these numbers keep poking their head all over the place. Nice catch on your part.

I wonder if the VT indicator might be translated by somebody to MT4 since this is the platform that I am using.

Regards,
  • #444
  • Feb 18, 2006 11:52pm Feb 18, 2006 11:52pm
lambrechtj,

Thank you for your words of support.

I think the difference could actually be due to Microsoft (of course ).

I am using Excel 2000. Kind of old these days, but it still gets most of my stuff done. I am wondering if you might be using a newer version of it, and the good people at Microsoft might have changed the word transition to translation in the newer version of Excel.

Just a thought.

Regards,
  • #445
  • Edited 1:56am Feb 19, 2006 1:08am | Edited 1:56am
Rex,

I saw your addition of extra days to the data portion of the spreadsheet.

I like it very much since it adds historical reliability to the analysis, and it provides us with more certainty in our conclusions.

I hope you won't mind the changes I did to my spreadsheet since I saw your post of the new files after I had already initiated changes on mine.

I made some additional changes after I started this post:
I added an additional column to the data sheet to count the number of instances less than 30 pips from the open with a few other minor changes.

Regards,
Attached File(s)
File Type: zip zip ii.ZIP   28 KB | 342 downloads
  • #446
  • Feb 19, 2006 2:31am Feb 19, 2006 2:31am
Quoting 5MinuteStudent
Rex,

I saw your addition of extra days to the data portion of the spreadsheet.

I like it very much since it adds historical reliability to the analysis, and it provides us with more certainty in our conclusions.

I hope you won't mind the changes I did to my spreadsheet since I saw your post of the new files after I had already initiated changes on mine.

I made some additional changes after I started this post:
I added an additional column to the data sheet to count the number of instances less than 30 pips from the open with a few other minor changes.

Regards,
Hi, 5MS ( is that your name? xi..xi..)

You have done a great job about Vegas' trading method. As far as I learn from all the Vegas materials, Vegas tend to trading longer time frame, that is why his method change from 1 hour to 4 hours, and finally have VWB method which is daily chart reading. I think your first part has great convinece to implement VWB method.

For 1 hr tunnel method, it's import to read the 2 tunnel MA line (up and down), and break out , we will take trade, pretty simple.

For 4 hrs tunnel method, there are more complex than 1 hr but it will more stable. You have to determin the weekly trend first, then look at 4 hrs chart to spot the "slope" change ,then take trade, so it's more intraday trading, I don't think Excel file will help us a lot on these intraday trading.

so conclusion is : I will be stick with your first part job use it on VWB method (daily chart only) and excel file help us a lot.

Here is your new version with 527 days data, but I deleted the Tunnel caculation which is not suitable for intraday anlysis.

P.S: this excel file I am using "=MT4|ASK!GBPUSD" because I am not using mini account, If anybody has mini account ,you should use 5mintuestudent's file.
Attached File(s)
File Type: zip VWB II-rev3.zip   79 KB | 546 downloads
Chinese Forex Trader from China
  • #447
  • Feb 19, 2006 3:58am Feb 19, 2006 3:58am
G'day folks,

Slightly off topic, but does anyone know if any of the Vegas methods have been coded for AmiBroker? I was looking at giving it a try, but I don't want to re-invent the wheel.

Many thanks,
Andrew.
  • #448
  • Edited 5:26am Feb 19, 2006 4:14am | Edited 5:26am
Rex,

Thank you for your kind words.

The reason that I included the 1-hr tunnel and 4-hr tunnel in the same spreadsheet is related to some earlier posts either on this thread or the earlier thread on VWB. Somebody had spotted a relation between the 1-hr or the 4-hr (I forgot now) and the daily charts. [I believe that some of the stuff I mentioned can be found here (look for accrete's questions and Vegas answers):
http://www.forexfactory.com/forexfor...3&page=3&pp=15]

Vegas, for instance, mentioned the following:
"One loose end I would like to address. I get asked often which method I trade the most and which I like the best; the 1 hour, the 4 hour, or VWB.

The answer depends on volatility. When the implied volatility of a market is high, I trade the 1 hour. For example, if GBP/USD suddenly starts trading with 300 – 500 pip ranges per day, I would switch to the 1 hour. The last time Cable was like this was in the Feb. – April 2004 time period. Most of the time I stick to VWB. I like all the methods equally, and it isn’t a matter of liking something. It’s a matter of which is going to make me the most money."

Moreover, he said that

"From what you just read in Chapter 2, I hope most of you can see how the ‘Vegas Currency Daily’ can help you in implementing the 1 hour and/or the 4 hour tunnel methods.

For the 1-hour tunnel method, I would not trade a breach of the 1-hour tunnel [144 and 169 EMA’s] if the fib levels on the daily chart breached the levels given in Chapter 2, Step 3 on the same side. The probability of success is limited. By the same token, I would be much more inclined to increase my size of trading on a confirmation of the signal given by ‘The Vegas Currency Daily’ on the opposite side. "


He also made the following point:

"With the 4 hour tunnel method, I am inclined to use ‘The Vegas Currency Daily’ black dots as guideposts for determining whether to be long or short from the signals. The difference in the values of the weekly MA’s [moving averages] in determining long or short can often lag the market quite dramatically. If the black dots are above the daily tunnel, initiate short positions when you get the 4-hour signal, and if the black dots are below the daily tunnel, initiate long positions when you get the 4-hour signal.

Use the same criteria when ‘The Vegas Currency Daily’ has more than 2 losses in a row. In this case, the market is in a very strong trend. Stay with it until you reach the last fib number on the daily chart.

By doing this, you will be going back and forth between black dots for your signal to be long or short the market. Based on the 4 hour signal crossover, you will be quicker to react to changes in market trend."

I hope from the above the inclusion of the other two tunnels in the same spreadsheet can be seen as either aiding in the anaysis of the daily charts, or helping those interested in trading the intraday tunnels for valid signals.

As can be seen from the above Vegas comments, he has included rules of what kind of intraday trades will have a higher probability of succeeding, and these are the ones I tried to pinpoint. Hopefully, I accomplished this.

Finally, in the file that I uploaded I placed on the tunnel section to different color highlights. The, first, in light turquoise, shows the current price in relation both to the -144 fib level on the daily chart and to the current 1-hr tunnel with the -34 fib level for good measure.

The, second, in tan color, shows that the 4-hour tunnel and the daily chart tunnel are basically at the same level (the difference being only 3 pips). I probably would have missed this unless I had the spreadsheet to show this.

Regards,



PS. Please notice that in the picture below the information giving instructions regarding the 1-hr and 4-hr is not correct since there is no data from MT4 flowing into Excel.

Since this is the first time I attempt this, I hope that by Sunday evening this will correct by itself, and the 1-hr and 4-hr recommendation will correct by itself.

Currently the current price is shown in Excel as N\A. So the cells depending on MT4 are in error. I have no way of controlling this until prices start flowing again.

The correct display for the 4-hr would read with prices flowing in as "Initiate only buy positions on the 4-hr charts/"

The correct display for the 1-hr would read as "Initiate only buy positions on the 1-hr charts if near or beyond the -233 level on the daily charts" or "Use discretion in your use of the 1-hr tunnel."
Attached Image
  • #449
  • Feb 19, 2006 9:29am Feb 19, 2006 9:29am
Rex and 5minutestudent,

Your excel files are extremly helpful and I thank your for sharing your excel expertise with us! I did make my own excel sheet but it was no where as good as yours! It may take some time getting accustomed to it but I have a few questions:

1) If I want to add more recent dates to the spreadsheet, for example, 2/20, will it do that automaticly if I have the DDE server enabled? What if I want to remove a date, such as a holiday like Monday? How do I do that without messing up the mathmatical programmings within the file itself?

2) Is there anything else I must have enabled besides DDE server? Like something in excel?

3) What parts are automated in the file? Like, for example, is interday analysis an area where we manage it ourselves?

Again, that is some wonder peice of work.
  • #450
  • Feb 19, 2006 9:57am Feb 19, 2006 9:57am
5MinuteStudent. rex - Thank you, for all the hard work, and up to the minute sharing of the development of your "data, and trade sheets" -

I look foward to using them in my daily trading of the VWBII, (4) hr tunnel, and (1) hr tunnel

Thanks, again
  • #451
  • Feb 19, 2006 11:23am Feb 19, 2006 11:23am
Quoting 5MinuteStudent
lambrechtj,

I could not find the translation tab, but I found something called Transition. Is this perhaps the one you meant?

Regards,
My version of Excel is 2002.
If your spread sheet is working and displays the values don't even worry about it.

Looks like Rex discovered something.
If you use a regular account your dde formula should look like this
=MT4|ask!GBPUSD
If you use a Mini account your formula should look like this
=MT4|ask!GBPUSDm the little m stands for mini account, If you use the wrong one your cell will display N/A for not availble.

You will want to start MT4 before opening the spreadsheet, other wise it just gets confused about how to start mt4 and update the values etc.

Interbank is up and online showing prices but they are not moving yet not till 6pm est. You could get a demo of that if you want to play with your spreadsheet on Sunday.

Nice work, there are so many versions of the spreadsheet my head is spinning on which one is the one to use
  • #452
  • Feb 19, 2006 12:15pm Feb 19, 2006 12:15pm
Quoting xspowerx
Rex and 5minutestudent,

Your excel files are extremly helpful and I thank your for sharing your excel expertise with us! I did make my own excel sheet but it was no where as good as yours! It may take some time getting accustomed to it but I have a few questions:

1) If I want to add more recent dates to the spreadsheet, for example, 2/20, will it do that automaticly if I have the DDE server enabled? What if I want to remove a date, such as a holiday like Monday? How do I do that without messing up the mathmatical programmings within the file itself?

2) Is there anything else I must have enabled besides DDE server? Like something in excel?

3) What parts are automated in the file? Like, for example, is interday analysis an area where we manage it ourselves?

Again, that is some wonder peice of work.
xspowerx,

This should be the first week I use it automatic data flowing in so I hope it will work. Thank you for your words of encouragement.

I believe you will have to add the dates by yourself. I hope someday there will be someone with Excel macro knowledge who will make a script to enter the dates by itself. In the meantime we will have to do this on our own.

If you want to delete a date (I can't see why) you can do so by deleting the whole row.

For detailed information of what to switch on or off look back a few posts. There is a very detailed post answering this question.

You should only have to enter at the top on the yellow highlighted cells some information like the daily open, whether you want to buy or sell, whether there was a reversal signal the day before, and whether the price action is near a significant fib level.

If you are interested in the 1-hr and 4-hr trades, or if you would like to get additional information from them, you can try by entering the 169 and 144 tunnel data for the 1-hr and the 4-hr. You can also enter data for the 24 and 28 MA for the daily data. You may find the feedback useful for this section; otherwise, you may disregard it.

There are still some parts of the spreadsheet where I have not completed work such as on speed and the Vegas' tunnels, but perhaps one day with more time, I will do this.

Regards,
  • #453
  • Feb 19, 2006 12:36pm Feb 19, 2006 12:36pm
Quoting lambrechtj
My version of Excel is 2002.
If your spread sheet is working and displays the values don't even worry about it.

Looks like Rex discovered something.
If you use a regular account your dde formula should look like this
=MT4|ask!GBPUSD
If you use a Mini account your formula should look like this
=MT4|ask!GBPUSDm the little m stands for mini account, If you use the wrong one your cell will display N/A for not availble.

You will want to start MT4 before opening the spreadsheet, other wise it just gets confused about how to start mt4 and update the values etc.

Interbank is up and online showing prices but they are not moving yet not till 6pm est. You could get a demo of that if you want to play with your spreadsheet on Sunday.

Nice work, there are so many versions of the spreadsheet my head is spinning on which one is the one to use
lambrechtj,

Thank you for your support and ideas.

I am trying now to use the suggestion by Vegas of using the StrategyBuilder FX4 in order to have access to the S&P.

Would you have an idea of what is the beginning of the code for the Excel cells? Would it be something like
=SBFX4|ask!GBPUSD ?

Regards,
  • #454
  • Feb 19, 2006 12:40pm Feb 19, 2006 12:40pm
Quoting fire580
5MinuteStudent. rex - Thank you, for all the hard work, and up to the minute sharing of the development of your "data, and trade sheets" -

I look foward to using them in my daily trading of the VWBII, (4) hr tunnel, and (1) hr tunnel

Thanks, again
fire580,

You are very welcome. I hope it will be of aid. I should make a warning notice to everyone. This is a new tool. So please use it with the respect it deserves.

I have done my best for it to work right, but still let it run and check its values and conclusions before making any decision based on it.

If after a while everyone agrees that it is working ok, then perhaps we have an additional tool that should make our Vegas analysis a little easier.

Regards,
  • #455
  • Edited 1:17pm Feb 19, 2006 1:12pm | Edited 1:17pm
Quoting 5MinuteStudent
xspowerx,

This should be the first week I use it automatic data flowing in so I hope it will work. Thank you for your words of encouragement.

I believe you will have to add the dates by yourself. I hope someday there will be someone with Excel macro knowledge who will make a script to enter the dates by itself. In the meantime we will have to do this on our own.

If you want to delete a date (I can't see why) you can do so by deleting the whole row.

For detailed information of what to switch on or off look back a few posts. There is a very detailed post answering this question.

You should only have to enter at the top on the yellow highlighted cells some information like the daily open, whether you want to buy or sell, whether there was a reversal signal the day before, and whether the price action is near a significant fib level.

If you are interested in the 1-hr and 4-hr trades, or if you would like to get additional information from them, you can try by entering the 169 and 144 tunnel data for the 1-hr and the 4-hr. You can also enter data for the 24 and 28 MA for the daily data. You may find the feedback useful for this section; otherwise, you may disregard it.

There are still some parts of the spreadsheet where I have not completed work such as on speed and the Vegas' tunnels, but perhaps one day with more time, I will do this.

Regards,
The reason I asked about deleting dates is because if in the event that it was automated dating, we wouldn't want our numbers to be calculated with weekends/holidays, for example tommorow.

So lets say I want to add 2/21 i have to click the line, insert new row, fill it all in and include the scripts, right?

Also, I see several versions so which one is the final one?

Also, post # 427 gives details on how to export data from MT4.
  • #456
  • Edited Mar 5, 2006 1:02am Feb 19, 2006 1:26pm | Edited Mar 5, 2006 1:02am
Quoting xspowerx
The reason I asked about deleting dates is because if in the event that it was automated dating, we wouldn't want our numbers to be calculated with weekends/holidays, for example tommorow.

So lets say I want to add 2/21 i have to click the line, insert new row, fill it all in and include the scripts, right?

Also, I see several versions so which one is the final one?

Also, post # 427 gives details on how to export data from MT4.
xspowerx,

You have a great point there regarding holidays and weekends.

If you go to the sheet titled "Data Sheet," and you go to row 9 cellA, then I believe that Rex (I hope I am right) entered a comment detailing instruction for the insertion of a new row.

The way I would do it is as follows:

Select row 9 and choose insert row by right clicking on the this row.

Copy the top row titeld "Formula." Paste this row in the place where you inserted an empty row.

Then enter the date in the place of the word Formula. Enter the open, high, low. I believe this should be it, but don't hold me to it since I have not done yet.

I have uploaded my latest version.

Regards,
  • #457
  • Feb 19, 2006 2:03pm Feb 19, 2006 2:03pm
Quoting 5MinuteStudent
lambrechtj,

Thank you for your support and ideas.

I am trying now to use the suggestion by Vegas of using the StrategyBuilder FX4 in order to have access to the S&P.

Would you have an idea of what is the beginning of the code for the Excel cells? Would it be something like
=SBFX4|ask!GBPUSD ?

Regards,
Should be exactly the same as before
=mt4|ask!GBPUSD or =mt4|ask!GBPUSDm
The software vendor is still Meta Trader regardless of the broker.

You will want to replace GBPUSD with what ever S&P is called.
I could not find that security, I think someone else was explaining how to get it on Metatrader. Must have been Vegas.

There is a sample excel spread sheet at
c:\programfiles\strategybuilderfx\sampledde.xls to play with.

John
  • #458
  • Feb 19, 2006 2:19pm Feb 19, 2006 2:19pm
Quoting lambrechtj
Should be exactly the same as before
=mt4|ask!GBPUSD or =mt4|ask!GBPUSDm
The software vendor is still Meta Trader regardless of the broker.

You will want to replace GBPUSD with what ever S&P is called.
I could not find that security, I think someone else was explaining how to get it on Metatrader. Must have been Vegas.

There is a sample excel spread sheet at
c:\programfiles\strategybuilderfx\sampledde.xls to play with.

John
John,

Thank you so very much for your prompt response to my question. I had it in front of me the whole time, and I did not pay any attention to it.

It figures since I just installed it today. The Excel sample sheet had all the info in addition to your post that I needed.

Regards,
  • #459
  • Feb 19, 2006 3:53pm Feb 19, 2006 3:53pm
Quoting 5MinuteStudent
xspowerx,

You have a great point there regarding holidays and weekends.

If you go to the sheet titled "Data Sheet," and you go to row 9 cellA, then I believe that Rex (I hope I am right) entered a comment detailing instruction for the insertion of a new row.

The way I would do it is as follows:

Select row 9 and choose insert row by right clicking on the this row.

Copy the top row titeld "Formula." Paste this row in the place where you inserted an empty row.

Then enter the date in the place of the word Formula. Enter the open, high, low. I believe this should be it, but don't hold me to it since I have not done yet.

I have uploaded my latest version.

Regards,
5minutestudent, love the file.

One mistake, you have "m" on the end of the most scripts on the GBP sheet preventing it from showing the designated criteria.. instead showing "N/A"
  • #460
  • Feb 19, 2006 4:13pm Feb 19, 2006 4:13pm
I entered long GBPUSD before Vegas was able to explain why he didn't go long..

Anyways I am up and looking to book half profits now and make this a free trade. After this is done I will move my remaining positions stop to break even. I know its not by the tunnel yet but this isn't showing real strength right now.
0 traders viewing now