Quote from PointOne:
http://www.elitetrader.com/vb/showthread.php?s=&postid=1489358#post1489358
OK, I've had a lot of PMs regarding my Excel chart of the DOM.
I do not want to distract from Spyder's recommended syllabus or spoil the pace at which he wants to introduce elements of the DOM â so by all means start using my chart but please donât use this thread for questions on design improvements or getting it to work. If there are major issues with it, PM me, but remember
it is given free, âas isâ and it is not supported.
Pre-requisite: Makosgu's PRV spreadsheet
which already has the DOM DDE feed. I cut out the PRV sheet as I no longer needed it, thanks to the recent QT enhancement. This makes everything run faster and Excel remains responsive so you can tweak the chart in real time as required.
Iâve attached the chart (it's actually 3 charts in a row with some simple logic on the DOM numbers) which is linked to hard wired DOM numbers to get you going with the formulas I use. You have to link to
your own DDE derived DOM numbers in
your sheet â and there are several ways to do that. Once you have linked in to the right numbers, save, close, open and allow macros and updates to run. Check the chart is working in real time. (Adjust the horizontal scale as required by double clicking it.)
If it does work first time, as it did for me, you will probably shout "
Holy Shit!, why didn't I do this earlier!"
Enjoy, but please donât get distracted by it â remember where it fits within the toolbox.
Download xls attachment here:
http://www.elitetrader.com/vb/attachment.php?s=&postid=1489358
P1