Supply and demand daily and weekly levels spreadsheet | Page 3 | 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

  • #41
  • Jul 18, 2013 4:10am Jul 18, 2013 4:10am
Quoting panoramia
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 {quote}
The important is to have precise rules to define the levels.
MT4/MT5 EAs/Indicators/Alerts coder
  • #42
  • Jul 18, 2013 4:19am Jul 18, 2013 4:19am
Yep, there would two ways of doing it and the indicator and/or spreadsheet would allow you to choose:

1. Using the existing automatic supply and demand indicator by insanities industries. This would be the no brainer one, rules are on the indicator itself
2. Using manual SD rectangle levels painted by anyone using the charts. The indicator would detect closest manual ones above/below current price and calculate how high or low we're in the curve. This would be more subjective but very important as well

The application would allow to choose which timeframes you want to use as the curve D1/WK or even monthly, and allow you to see how high/low in the curve you'd be based on which timeframe you'd like to use as the curve.

The automatic SD indicator does quite a good job in that sense, but sometimes levels are just too wide and one needs to drill them down, and the continuation patterns (rally-base-rally and drop-base-drop) are not detected, so those can be done manually
Quoting FerruFx
{quote} The important is to have precise rules to define the levels.
Set and Forget supply and demand trading community
  • #43
  • Jul 18, 2013 8:37am Jul 18, 2013 8:37am
Quoting panoramia
There you have them Those are the D1/WK SD levels I have for the 20 pairs I trade. Alfonso {quote} {image}
thanks alfonso, very helpfull for comparing - maybe you can upload them - once a week.

  • #44
  • Jul 28, 2013 5:15am Jul 28, 2013 5:15am
Hy!Can someone please tell me,how to update this?
  • #45
  • Jul 28, 2013 5:19am Jul 28, 2013 5:19am
you must ask alfonso or wait until he post the update


Quoting astronaud
Hy!Can someone please tell me,how to update this?
  • #46
  • Jul 28, 2013 5:27am Jul 28, 2013 5:27am
As I understand it, Alfonso updates it by entering the numbers in manually. As they are longer term numbers they shouldn't need to be updated everyday.

He uses the spreadsheet to guage where the currency pair is in the "curve" on each timeframe.

From the first post:



The sole purpose of this spreadsheet is to allow you to know how high or low you are in the D1 and WK supply and demand curve if you manually add the distal and proximal lines for both D1 and WK SD levels on your charts, or whatever timeframe you want to use as the curve (demand and supply in control of current price)
It never gets easier, you just get better
  • #47
  • Jul 28, 2013 5:31am Jul 28, 2013 5:31am
Exactly Shabs! Thanks for the explanation.

This spreadsheet is a VERY powerful tool. I am planning to record a video just today in order to explain how to use it correctly and how it can help us on our supply and demand trading. Stay tuned

Levels need to be entered manually, I would love that the manual/automatic SD rectangles on the charts were sent via DLL to the spreadsheet, but that would be a lot of coding work, I am into many things and I can't do it, but if anybody out there with the required coding experience is willing to help us do it, please contact me, it have planned a very nice tool and/or indicator to do it much better.

Alfonso

Quoting Shabs19
As I understand it, Alfonso updates it by entering the numbers in manually. As they are longer term numbers they shouldn't need to be updated everyday. He uses the spreadsheet to guage where the currency pair is in the "curve" on each timeframe.
Set and Forget supply and demand trading community
  • #48
  • Jul 28, 2013 7:19am Jul 28, 2013 7:19am
Quoting panoramia
Exactly Shabs! Thanks for the explanation. This spreadsheet is a VERY powerful tool. I am planning to record a video just today in order to explain how to use it correctly and how it can help us on our supply and demand trading. Stay tuned Levels need to be entered manually, I would love that the manual/automatic SD rectangles on the charts were sent via DLL to the spreadsheet, but that would be a lot of coding work, I am into many things and I can't do it, but if anybody out there with the required coding experience is willing to help us do...
Looking forward to this video and more news on the spreadsheet.

Could be an ideal start for a new grid trader. I'm sure one of the coders in the grid/martingale threads would enjoy a look at this..
  • #49
  • Jul 28, 2013 8:20am Jul 28, 2013 8:20am
Quoting panoramia
Exactly Shabs! Thanks for the explanation. This spreadsheet is a VERY powerful tool. I am planning to record a video just today in order to explain how to use it correctly and how it can help us on our supply and demand trading. Stay tuned Levels need to be entered manually, I would love that the manual/automatic SD rectangles on the charts were sent via DLL to the spreadsheet, but that would be a lot of coding work, I am into many things and I can't do it, but if anybody out there with the required coding experience is willing to help us do...
I cant wait,thanx!
  • #50
  • Jul 28, 2013 8:20am Jul 28, 2013 8:20am
Quoting astock
you must ask alfonso or wait until he post the update {quote}
Thanx!
  • #51
  • Edited 12:41pm Jul 28, 2013 12:21pm | Edited 12:41pm
I've recorded a 1 hour video on how to correctly use the Supply and Demand spreadsheet. I've also uploaded a modified spreadsheet to this thread's first post.

You can download it from there, as well as finding instructions on how to install it (it requires installation of Apache Open Calc)

  1. The spreadsheet is a snapshot or bird view of higher timeframe supply and demand levels for all the instruments you are trading
  2. It helps you to assess how high or how low you are in the D1 & WK curves
  3. It helps you find confluences by comparing different instrument’s higher timeframe curves
  4. It also helps you find correlations between Commodity Dollars (Australian, New Zealand and Canadian dollars), Oil and Gold

For example:

  1. WK supply on Dollar index vs WK/D1 demand on the majors
  2. NZDUSD at or near D1 Demand vs EURNZD/GBPNZD at or near D1 Supply
  3. Gold at D1 demand vs AUDUSD at D1 demand
  4. Copper at WK demand vs AUDUSD at WK demand
  5. Oil at WK supply vs USDCAD and D1/WK demand

Trading supply and demand is all about buying low in the curve, and Selling high in the curve
Add the spreadsheet to your daily routine and it will improve your entries.

Watch the video below, you will learn full details on how to use it.

Inserted Video
Set and Forget supply and demand trading community
  • #52
  • Jul 28, 2013 2:14pm Jul 28, 2013 2:14pm
Quoting panoramia
I've recorded a 1 hour video on how to correctly use the Supply and Demand spreadsheet. I've also uploaded a modified spreadsheet to this thread's first post. You can download it from there, as well as finding instructions on how to install it (it requires installation of Apache Open Calc) The spreadsheet is a snapshot or bird view of higher timeframe supply and demand levels for all the instruments you are trading It helps you to assess how high or how low you are in the D1 & WK curves It helps you find confluences by comparing different instrument’s...

First of all thanx a lot for taking your time to do this video and helping many of us!God bless you.

I also have one question,could you please tell me how to add monthly S/D levels ,because i use them as a part of my analysis?
  • #53
  • Edited 2:35pm Jul 28, 2013 2:20pm | Edited 2:35pm
It's all explained on the video. In order to add Monthly you have to delete/overwrite the D1 or the Weekly. The spreadsheet is only ready for 2 Curves, not 3, you have to decide which one you want to replace! In the future I might add the Monthly, I didn't do it on this version.

Alfonso


Quoting astronaud
{quote} First of all thanx a lot for taking your time to do this video and helping many of us!God bless you. I also have one question,could you please tell me how to add monthly S/D levels ,because i use them as a part of my analysis?
Set and Forget supply and demand trading community
  • #54
  • Jul 28, 2013 9:12pm Jul 28, 2013 9:12pm
Thanks Panoramia for the video
MT4/MT5 EAs/Indicators/Alerts coder
  • #55
  • Jul 29, 2013 7:15pm Jul 29, 2013 7:15pm
Hi Alfonso, I've downloaded the spreadsheet and it connects to mt4 fine but when I try to edit the supply/demand levels it says "this document cannot be edited, possibly due to missing access rights". I'm not familiar with open office and all I have tried to do is edit the document using the button in the top tool bar. Its probably something very simple but its stumped me, any advice that might steer me in the right direction would be appreciated. I haven't really had much use for spreadsheets in the past but I watched the video you made earlier and I can see the value in the way you use it to keep track of the curve on so many pairs.
  • #56
  • Jul 30, 2013 5:01am Jul 30, 2013 5:01am
Just ignore me Alfonso, I got it working this morning! Thanks for all your hard work.
  • #57
  • Jul 31, 2013 5:28pm Jul 31, 2013 5:28pm
I have added some modifications to the Supply and Demand Spreadsheet, which will enhance it even more.

  1. Monthly Curve. Now we can add Monthly Supply and demand, as well as Weekly and Daily like before
  2. Curve % is now located on the far left of the spreadsheet. By doing so, you will see at a glance an overview of how high or low price is in the D1/WK/MN curve
  3. Changed the conditional formatting for the Curve %, Open Calc only allows 3 conditons. So now if price is within Demand and penetrated it it will be blue or read
  4. You can only see the pairs that I trade. You can add other pairs but you need to do it carefully. It's common sense but you need some practice and knowledge. I can't help you there, too many things to do on this side

You can download the new spreadsheet from the first post in this thread.

You can have a quick overview of how it looks like with today's levels on this post.

Set and Forget supply and demand trading community
  • #58
  • Jul 31, 2013 6:14pm Jul 31, 2013 6:14pm
Quoting panoramia
I have added some modifications to the Supply and Demand Spreadsheet, which will enhance it even more. Monthly Curve. Now we can add Monthly Supply and demand, as well as Weekly and Daily like before Curve % is now located on the far left of the spreadsheet. By doing so, you will see at a glance an overview of how high or low price is in the D1/WK/MN curve Changed the conditional formatting for the Curve %, Open Calc only allows 3 conditons. So now if price is within Demand and penetrated it it will be blue or read You can only see the pairs that...
this is really great stuff Alfonsjo thanks a lot !
  • #59
  • Jul 31, 2013 7:56pm Jul 31, 2013 7:56pm
Quoting panoramia
I have added some modifications to the Supply and Demand Spreadsheet, which will enhance it even more. Monthly Curve. Now we can add Monthly Supply and demand, as well as Weekly and Daily like before Curve % is now located on the far left of the spreadsheet. By doing so, you will see at a glance an overview of how high or low price is in the D1/WK/MN curve Changed the conditional formatting for the Curve %, Open Calc only allows 3 conditons. So now if price is within Demand and penetrated it it will be blue or read You can only see the pairs that...
Great job as always!
MT4/MT5 EAs/Indicators/Alerts coder
  • #60
  • Aug 1, 2013 11:23am Aug 1, 2013 11:23am
i just downloaded zip file, but unable to run excel file. Please help me out
0 traders viewing now