Supply and demand daily and weekly levels spreadsheet | Page 2 | Forex Factory

Options

Go to
Permalinks
Print Thread

Similar Threads

Firehorse's trading spreadsheet 45 replies

Important Levels Spreadsheet 0 replies

Spreadsheet with RSI and IFISH formulas 0 replies

VWB - Average Range Spreadsheet 6 replies

Does anyone have Daily range spreadsheet? 2 replies

Attachments: Supply and demand daily and weekly levels spreadsheet
Exit Attachments

Supply and demand daily and weekly levels spreadsheet

  • #21
  • May 22, 2013 6:45am May 22, 2013 6:45am
You are welcome, doing my best to help others. It's a tool that helps me a lot on my supply and demand trading, I thought that others would find the same benefits.

I will give Excel a try later and see what I can come up with

Thanks again Joe!
Alfonso

Quoting fortunateson
The Open Office does a great job and thanks so much for sharing it. I really appreciate your work so I just wanted to make an attempt to contribute. The excel works fine on my end on 2 different mt4 platforms so I’m confused but moving on. I am grateful and plan on using the spreadsheet you have provided. Thanks again, Joe
Set and Forget supply and demand trading community
  • #22
  • Edited 5:25pm Jun 1, 2013 4:25pm | Edited 5:25pm

Hi Alfonso, I added a position size calculator sheet to this very helpful tool if anyone is interested. It is still in draft mode but I think it is close to completion so any feedback would be appreciated to finalize it.

In row 5 the variables are Closed Equity, %Risk, contract size (depending on broker so this might be a formula issue in the spreadsheet), stop size and stop slippage. Again this is just my take on what I use but I added it to this already great tool provided, for anyone to use ....but I am open for additional ideas for improving the spreadsheet to help traders in any way....... any input or additions are welcome. Either way I hope this helps all of us put all the variables in 1 place.

Thanks,
Joe

P.S. I hope this works to copy ---- 1 st attempt let me know if there are any problems
Attached File(s)
File Type: zip Test 1.zip   40 KB | 763 downloads
  • #23
  • Jun 3, 2013 5:27pm Jun 3, 2013 5:27pm
Hallo Alfonso, I just wanted to say a big thank you for sharing this amazing spreadsheet. I am now following your other thread as well.

Kindest,
Remlad
  • #24
  • Jun 4, 2013 4:44am Jun 4, 2013 4:44am
Thanks for the update Joe! I really appreciate it, you've done a great job, congratulations!

You want me to add it to the first post of this thread maybe?
Alfonso

Quoting fortunateson
Hi Alfonso, I added a position size calculator sheet to this very helpful tool if anyone is interested. It is still in draft mode but I think it is close to completion so any feedback would be appreciated to finalize it.In row 5 the variables are Closed Equity, %Risk, contract size (depending on broker so this might be a formula issue in the spreadsheet), stop size and stop slippage. Again this is just my take on what I use but I added it to this already great tool provided, for anyone to use ....but I am open for additional ideas for improving...
Set and Forget supply and demand trading community
  • #25
  • Jun 4, 2013 4:46am Jun 4, 2013 4:46am
You are welcome Remlad! I'm glad that you like the spreadsheet, because it will give you a snapshot or bird view of where your D1 and WK supply and demand levels are and how high or low you are in the curve (or altitude). There is an updated version posted by Joe (Fortuneson), which has a position size calcualtor on a secon tab. Unfortunately I am using a commercial Position Calculator which works great for me, I use it all the time, so won't be using it, but it's a really nice job that Joe has done on that side.

Thanks again,
Alfonso


Quoting remlad
Hallo Alfonso, I just wanted to say a big thank you for sharing this amazing spreadsheet. I am now following your other thread as well. Kindest, Remlad
Set and Forget supply and demand trading community
  • #26
  • Jun 5, 2013 9:37am Jun 5, 2013 9:37am
Quoting panoramia
Thanks for the update Joe! I really appreciate it, you've done a great job, congratulations! You want me to add it to the first post of this thread maybe? Alfonso {quote}

Hi Alfonso,

Thanks, whatever you decide is great with me. The position size calculator functions properly but I just want everyone to be aware that when you open the “Open Office Calculator” and click yes to update the links that this will have some affect on the stop price placement in column “J and M” (maybe a pip or 2 movement variations) as the spread fluctuations are live, that’s why I added the stop slippage. I hope this makes sense. Those columns are new and I am just trying them out.

Thanks,

Joe

  • #27
  • Jun 24, 2013 9:01am Jun 24, 2013 9:01am
is there any updated spreadsheet ??
  • #28
  • Edited 9:28am Jun 24, 2013 9:03am | Edited 9:28am
Joe, aka Fontunateson, updated the spreadsheet for Excel. I don't post my levels on an updated spreadsheet. The spreadsheet is created for you to add your levels, it's not automatic remember.

Here you are my last levels, updated one hour ago.
Alfonso


Quoting astock
is there any updated spreadsheet ??
Attached Image (click to enlarge)
Click to Enlarge Name: Screenshot1.png Size: 150 KB
Set and Forget supply and demand trading community
  • #29
  • Jun 24, 2013 9:26am Jun 24, 2013 9:26am
Thanks for the update Alfonso..

How often do you update this? Weekly, Daily? I guess it depends on if the levels you have marked get respected or not if they do then they might not change but if they don't then you would need to add in the next level as it were! Would you agree with this? Or have I misunderstood this?

-S
  • #30
  • Jun 24, 2013 9:30am Jun 24, 2013 9:30am
I will update my levels as soon as the are violated. I will always have my spreadsheet and MT running

First first thing I do in the mornings is:

  1. Run MT and look if any D1/WK levels have been violated
  2. See if I'm too high or too low in the curve, it will tell me if I have to keep on buying or selling

Hope that helps
Alfonso

Quoting fwloop
Thanks for the update Alfonso.. How often do you update this? Weekly, Daily? I guess it depends on if the levels you have marked get respected or not if they do then they might not change but if they don't then you would need to add in the next level as it were! Would you agree with this? Or have I misunderstood this? -S
Set and Forget supply and demand trading community
  • #31
  • Jul 2, 2013 7:38pm Jul 2, 2013 7:38pm
Thanks for great tool in this spreadsheet. Trying to get familiar with it.

In regards to entering levels in the spreadsheet, do we only use fresh levels eg brown and blue or do we use the closest level to price even if its means that level has been partially penetrated or spiked like a green or gray zone?

thx
If you act surprised, then you probably missed something
  • #32
  • Jul 3, 2013 1:34am Jul 3, 2013 1:34am
Hi there!

You don't use the levels on the spreadsheet to enter your trades, only to know how high or low you are in the curve. Once you know you are very near or at the D1/WK SD area, you will have to located lower timeframe's levels in order to set your orders. Unless you are doing position trading and using the D1 level as your entry timeframe and your monthly chart as the curve.

It does not matter if D1/WK is not fresh, it's a higher timeframe area and it has to be respected. You can say to yourself "it's a non fresh D1 supply area, I won't trade it", that's perfectly fine, but one thing is not trading it, another thing is assuming it's gonne be broken because it's been touched once. Assuming anything in trading is a recipe for failure, you know what I mean

Hope that helps!
Alfonso

Quoting outapips
Thanks for great tool in this spreadsheet. Trying to get familiar with it. In regards to entering levels in the spreadsheet, do we only use fresh levels eg brown and blue or do we use the closest level to price even if its means that level has been partially penetrated or spiked like a green or gray zone? thx
Set and Forget supply and demand trading community
  • #33
  • Jul 3, 2013 3:43am Jul 3, 2013 3:43am
Quoting panoramia
Hi there! You don't use the levels on the spreadsheet to enter your trades, only to know how high or low you are in the curve. Once you know you are very near or at the D1/WK SD area, you will have to located lower timeframe's levels in order to set your orders. Unless you are doing position trading and using the D1 level as your entry timeframe and your monthly chart as the curve. It does not matter if D1/WK is not fresh, it's a higher timeframe area and it has to be respected. You can say to yourself "it's a non fresh D1 supply area, I won't...
I'm pretty sure I get your meaning and yes, I'm using it for curve not for entries

So we keep the level in the spreadsheet until such time as price makes a clear close thru the level at which time we then enter the next level into the spreadsheet unless a new level is formed from that point.
If you act surprised, then you probably missed something
  • #34
  • Jul 3, 2013 3:48am Jul 3, 2013 3:48am
Yes! Higher odds are lower timeframe levels within those higher timeframe levels... However on the way price travel from one level to the other, having enough room to reach them, there will be nice opportunities on lower timeframes to trade in the direction of the newly formed trend.

The spreadsheet will help you get a snapshot or bird view of how high or low you are in the curve for the pairs you are trading. It helps me a lot!

Alfonso
Quoting outapips
{quote} I'm pretty sure I get your meaning and yes, I'm using it for curve not for entries So we keep the level in the spreadsheet until such time as price makes a clear close thru the level at which time we then enter the next level into the spreadsheet unless a new level is formed from that point.
Set and Forget supply and demand trading community
  • #35
  • Jul 6, 2013 9:10am Jul 6, 2013 9:10am
Hi buddy,

I can help you out with coding part. But keep in mind am in a full time job. So don't expect faster completion time.
PM me. Lets discuss.

Thanks
Ananth
  • #36
  • Jul 18, 2013 1:40am Jul 18, 2013 1:40am
Hi Alfonso,

Could you upload a screenshot of your current spreadsheet levels so I can compare with mine?

Thx
If you act surprised, then you probably missed something
  • #37
  • Jul 18, 2013 2:04am Jul 18, 2013 2:04am
There you have them Those are the D1/WK SD levels I have for the 20 pairs I trade.
Alfonso

Quoting outapips
Hi Alfonso, Could you upload a screenshot of your current spreadsheet levels so I can compare with mine? Thx
Attached Image (click to enlarge)
Click to Enlarge Name: sd_levels.png Size: 131 KB
Set and Forget supply and demand trading community
  • #38
  • Jul 18, 2013 2:09am Jul 18, 2013 2:09am
Quoting panoramia
There you have them Those are the D1/WK SD levels I have for the 20 pairs I trade. Alfonso {quote} {image}

Excellent .. thx
If you act surprised, then you probably missed something
  • #39
  • Jul 18, 2013 3:58am Jul 18, 2013 3:58am
It would be great to have the levels automatically updated in the sheet
MT4/MT5 EAs/Indicators/Alerts coder
  • #40
  • Jul 18, 2013 4:00am Jul 18, 2013 4:00am
That's a big job, a good programmer would need to do that communicating MT4 with Excel or Open Calc with some custom DLL.. or even an indicator that does it on a separate window. I don't have that knowledge I have many ides for such a sheet and other things, but no knowledge for that or time

Alfonso
Quoting FerruFx
It would be great to have the levels automatically updated in the sheet
Set and Forget supply and demand trading community
0 traders viewing now