Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

MACD Scans Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
bull1
Posted : Wednesday, April 7, 2010 12:08:53 AM
Registered User
Joined: 3/9/2005
Posts: 10
Hi,
I am using  MACD(12,29,9) exponential.  I want to scan for stocks in my watchlist where the MACD is above the 9 EMA and for stocks where the MACD is below the 9 EMA.
I also want to scan for stocks as stated above but using the weekly and monthly charts (i.e., weekly chart MACD is above the weekly chart 9 EMA, etc).

Also, I want to scan for stocks where the MACD is about to cross above the 9 EMA and for stocks where the MACD is about to cross below the 9 EMA.

Thanks.
Bruce_L
Posted : Wednesday, April 7, 2010 9:19:32 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (bull1)
I am using  MACD(12,29,9) exponential.  I want to scan for stocks in my watchlist where the MACD is above the 9 EMA...

The easy and obvious way to write this would be:

Understanding MACD

XAVGC12 - XAVGC26 > XAVG(XAVGC12,9) - XAVG(XAVGC26,9)

Another way to write this that will be useful for creating Weekly and Monthly versions is (the techniques given in Cascades of Moving Averages were used to convert the formula and are also used to manually expand the Moving Averages to create the Weekly and Monthly formulas):

3 * XAVGC26 + 14 * XAVGC9 > 17 * XAVGC12

QUOTE (bull1)
...and for stocks where the MACD is below the 9 EMA.

3 * XAVGC26 + 14 * XAVGC9 < 17 * XAVGC12

QUOTE (bull1)
I also want to scan for stocks as stated above but using the weekly...

Weekly Exponential MACD 12,26 above its EMA9 Signal Line (or Histogram above 0):

.0348926326871455 * (C + 25 / 27 * (C5 + 25 / 27 * (C10 + 25 / 27 * (C15 + 25 / 27 * (C20 + 25 / 27 * (C25 + 25 / 27 * (C30 + 25 / 27 * (C35 + 25 / 27 * (C40 + 25 / 27 * (C45 + 25 / 27 * (C50 + 25 / 27 * (C55 + 25 / 27 * (C60 + 25 / 27 * (C65 + 25 / 27 * (C70 + 25 / 27 * (C75 + 25 / 27 * (C80 + 25 / 27 * (C85 + 25 / 27 * (C90 + 25 / 27 * (C95 + 25 / 27 * (C100 + 25 / 27 * (C105 + 25 / 27 * (C110 + 25 / 27 * (C115 + 25 / 27 * (C120 + 25 / 27 * (C125 + 25 / 27 * (C130 + 25 / 27 * (C135 + 25 / 27 * (C140 + 25 / 27 * (C145 + 25 / 27 * (C150 + 25 / 27 * (C155 + 25 / 27 * (C160 + 25 / 27 * (C165 + 25 / 27 * (C170 + 25 / 27 * (C175 + 25 / 27 * (C180 + 25 / 27 * (C185 + 25 / 27 * (C190 + 25 / 27 * (C195 + 25 / 27 * (C200 + 25 / 27 * (C205 + 25 / 27 * (C210 + 25 / 27 * (C215 + 25 / 27 * (C220 + 25 / 27 * (C225 + 25 / 27 * (C230 + 25 / 27 * (C235 + 25 / 27 * (C240 + 25 / 27 * (C245 + 25 / 27 * (C250 + 25 / 27 * (C255 + 25 / 27 * (C260 + 25 / 27 * (C265 + 25 / 27 * (C270 + 25 / 27 * (C275 + 25 / 27 * (C280 + 25 / 27 * (C285 + 25 / 27 * (C290 + 25 / 27 * (C295 + 25 / 27 * (C300 + 25 / 27 * (C305 + 25 / 27 * (C310 + 25 / 27 * (C315 + 25 / 27 * (C320 + 25 / 27 * (C325 + 25 / 27 * (C330 + 25 / 27 * (C335 + 25 / 27 * (C340 + 25 / 27 * (C345 + 25 / 27 * (C350 + 25 / 27 * (C355 + 25 / 27 * (C360 + 25 / 27 * (C365 + 25 / 27 * (C370 + 25 / 27 * (C375 + 25 / 27 * (C380 + 25 / 27 * (C385 + 25 / 27 * (C390 + 25 / 27 * (C395 + 25 / 27 * (C400 + 25 / 27 * (C405 + 25 / 27 * (C410 + 25 / 27 * (C415 + 25 / 27 * (C420 + 25 / 27 * (C425 + 25 / 27 * (C430 + 25 / 27 * (C435 + 25 / 27 * (C440 + 25 / 27 * (C445)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + .439651095630187 * (C + .8 * (C5 + .8 * (C10 + .8 * (C15 + .8 * (C20 + .8 * (C25 + .8 * (C30 + .8 * (C35 + .8 * (C40 + .8 * (C45 + .8 * (C50 + .8 * (C55 + .8 * (C60 + .8 * (C65 + .8 * (C70 + .8 * (C75 + .8 * (C80 + .8 * (C85 + .8 * (C90 + .8 * (C95 + .8 * (C100 + .8 * (C105 + .8 * (C110 + .8 * (C115 + .8 * (C120 + .8 * (C125 + .8 * (C130 + .8 * (C135 + .8 * (C140 + .8 * (C145 + .8 * (C150))))))))))))))))))))))))))))))) > .410624808171576 * (C + 11 / 13 * (C5 + 11 / 13 * (C10 + 11 / 13 * (C15 + 11 / 13 * (C20 + 11 / 13 * (C25 + 11 / 13 * (C30 + 11 / 13 * (C35 + 11 / 13 * (C40 + 11 / 13 * (C45 + 11 / 13 * (C50 + 11 / 13 * (C55 + 11 / 13 * (C60 + 11 / 13 * (C65 + 11 / 13 * (C70 + 11 / 13 * (C75 + 11 / 13 * (C80 + 11 / 13 * (C85 + 11 / 13 * (C90 + 11 / 13 * (C95 + 11 / 13 * (C100 + 11 / 13 * (C105 + 11 / 13 * (C110 + 11 / 13 * (C115 + 11 / 13 * (C120 + 11 / 13 * (C125 + 11 / 13 * (C130 + 11 / 13 * (C135 + 11 / 13 * (C140 + 11 / 13 * (C145 + 11 / 13 * (C150 + 11 / 13 * (C155 + 11 / 13 * (C160 + 11 / 13 * (C165 + 11 / 13 * (C170 + 11 / 13 * (C175 + 11 / 13 * (C180 + 11 / 13 * (C185 + 11 / 13 * (C190 + 11 / 13 * (C195 + 11 / 13 * (C200 + 11 / 13 * (C205))))))))))))))))))))))))))))))))))))))))))

Weekly Exponential MACD 12,26 below its EMA9 Signal Line (or Histogram below 0):

.0348926326871455 * (C + 25 / 27 * (C5 + 25 / 27 * (C10 + 25 / 27 * (C15 + 25 / 27 * (C20 + 25 / 27 * (C25 + 25 / 27 * (C30 + 25 / 27 * (C35 + 25 / 27 * (C40 + 25 / 27 * (C45 + 25 / 27 * (C50 + 25 / 27 * (C55 + 25 / 27 * (C60 + 25 / 27 * (C65 + 25 / 27 * (C70 + 25 / 27 * (C75 + 25 / 27 * (C80 + 25 / 27 * (C85 + 25 / 27 * (C90 + 25 / 27 * (C95 + 25 / 27 * (C100 + 25 / 27 * (C105 + 25 / 27 * (C110 + 25 / 27 * (C115 + 25 / 27 * (C120 + 25 / 27 * (C125 + 25 / 27 * (C130 + 25 / 27 * (C135 + 25 / 27 * (C140 + 25 / 27 * (C145 + 25 / 27 * (C150 + 25 / 27 * (C155 + 25 / 27 * (C160 + 25 / 27 * (C165 + 25 / 27 * (C170 + 25 / 27 * (C175 + 25 / 27 * (C180 + 25 / 27 * (C185 + 25 / 27 * (C190 + 25 / 27 * (C195 + 25 / 27 * (C200 + 25 / 27 * (C205 + 25 / 27 * (C210 + 25 / 27 * (C215 + 25 / 27 * (C220 + 25 / 27 * (C225 + 25 / 27 * (C230 + 25 / 27 * (C235 + 25 / 27 * (C240 + 25 / 27 * (C245 + 25 / 27 * (C250 + 25 / 27 * (C255 + 25 / 27 * (C260 + 25 / 27 * (C265 + 25 / 27 * (C270 + 25 / 27 * (C275 + 25 / 27 * (C280 + 25 / 27 * (C285 + 25 / 27 * (C290 + 25 / 27 * (C295 + 25 / 27 * (C300 + 25 / 27 * (C305 + 25 / 27 * (C310 + 25 / 27 * (C315 + 25 / 27 * (C320 + 25 / 27 * (C325 + 25 / 27 * (C330 + 25 / 27 * (C335 + 25 / 27 * (C340 + 25 / 27 * (C345 + 25 / 27 * (C350 + 25 / 27 * (C355 + 25 / 27 * (C360 + 25 / 27 * (C365 + 25 / 27 * (C370 + 25 / 27 * (C375 + 25 / 27 * (C380 + 25 / 27 * (C385 + 25 / 27 * (C390 + 25 / 27 * (C395 + 25 / 27 * (C400 + 25 / 27 * (C405 + 25 / 27 * (C410 + 25 / 27 * (C415 + 25 / 27 * (C420 + 25 / 27 * (C425 + 25 / 27 * (C430 + 25 / 27 * (C435 + 25 / 27 * (C440 + 25 / 27 * (C445)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + .439651095630187 * (C + .8 * (C5 + .8 * (C10 + .8 * (C15 + .8 * (C20 + .8 * (C25 + .8 * (C30 + .8 * (C35 + .8 * (C40 + .8 * (C45 + .8 * (C50 + .8 * (C55 + .8 * (C60 + .8 * (C65 + .8 * (C70 + .8 * (C75 + .8 * (C80 + .8 * (C85 + .8 * (C90 + .8 * (C95 + .8 * (C100 + .8 * (C105 + .8 * (C110 + .8 * (C115 + .8 * (C120 + .8 * (C125 + .8 * (C130 + .8 * (C135 + .8 * (C140 + .8 * (C145 + .8 * (C150))))))))))))))))))))))))))))))) < .410624808171576 * (C + 11 / 13 * (C5 + 11 / 13 * (C10 + 11 / 13 * (C15 + 11 / 13 * (C20 + 11 / 13 * (C25 + 11 / 13 * (C30 + 11 / 13 * (C35 + 11 / 13 * (C40 + 11 / 13 * (C45 + 11 / 13 * (C50 + 11 / 13 * (C55 + 11 / 13 * (C60 + 11 / 13 * (C65 + 11 / 13 * (C70 + 11 / 13 * (C75 + 11 / 13 * (C80 + 11 / 13 * (C85 + 11 / 13 * (C90 + 11 / 13 * (C95 + 11 / 13 * (C100 + 11 / 13 * (C105 + 11 / 13 * (C110 + 11 / 13 * (C115 + 11 / 13 * (C120 + 11 / 13 * (C125 + 11 / 13 * (C130 + 11 / 13 * (C135 + 11 / 13 * (C140 + 11 / 13 * (C145 + 11 / 13 * (C150 + 11 / 13 * (C155 + 11 / 13 * (C160 + 11 / 13 * (C165 + 11 / 13 * (C170 + 11 / 13 * (C175 + 11 / 13 * (C180 + 11 / 13 * (C185 + 11 / 13 * (C190 + 11 / 13 * (C195 + 11 / 13 * (C200 + 11 / 13 * (C205))))))))))))))))))))))))))))))))))))))))))

QUOTE (bull1)
...and monthly charts (i.e., weekly chart MACD is above the weekly chart 9 EMA, etc).

Monthly Exponential MACD 12,26 above its EMA9 Signal Line (or Histogram above 0):

.0348926326871455 * (C + 25 / 27 * (C21 + 25 / 27 * (C42 + 25 / 27 * (C63 + 25 / 27 * (C84 + 25 / 27 * (C105 + 25 / 27 * (C126 + 25 / 27 * (C147 + 25 / 27 * (C168 + 25 / 27 * (C189 + 25 / 27 * (C210 + 25 / 27 * (C231 + 25 / 27 * (C252 + 25 / 27 * (C273 + 25 / 27 * (C294 + 25 / 27 * (C315 + 25 / 27 * (C336 + 25 / 27 * (C357 + 25 / 27 * (C378 + 25 / 27 * (C399 + 25 / 27 * (C420 + 25 / 27 * (C441 + 25 / 27 * (C462 + 25 / 27 * (C483 + 25 / 27 * (C504 + 25 / 27 * (C525 + 25 / 27 * (C546 + 25 / 27 * (C567 + 25 / 27 * (C588 + 25 / 27 * (C609 + 25 / 27 * (C630 + 25 / 27 * (C651 + 25 / 27 * (C672 + 25 / 27 * (C693 + 25 / 27 * (C714 + 25 / 27 * (C735 + 25 / 27 * (C756 + 25 / 27 * (C777 + 25 / 27 * (C798 + 25 / 27 * (C819 + 25 / 27 * (C840 + 25 / 27 * (C861 + 25 / 27 * (C882 + 25 / 27 * (C903 + 25 / 27 * (C924 + 25 / 27 * (C945 + 25 / 27 * (C966 + 25 / 27 * (C987 + 25 / 27 * (C1008 + 25 / 27 * (C1029 + 25 / 27 * (C1050 + 25 / 27 * (C1071 + 25 / 27 * (C1092 + 25 / 27 * (C1113 + 25 / 27 * (C1134 + 25 / 27 * (C1155 + 25 / 27 * (C1176 + 25 / 27 * (C1197 + 25 / 27 * (C1218 + 25 / 27 * (C1239 + 25 / 27 * (C1260 + 25 / 27 * (C1281 + 25 / 27 * (C1302 + 25 / 27 * (C1323 + 25 / 27 * (C1344 + 25 / 27 * (C1365 + 25 / 27 * (C1386 + 25 / 27 * (C1407 + 25 / 27 * (C1428 + 25 / 27 * (C1449 + 25 / 27 * (C1470 + 25 / 27 * (C1491 + 25 / 27 * (C1512 + 25 / 27 * (C1533 + 25 / 27 * (C1554 + 25 / 27 * (C1575 + 25 / 27 * (C1596 + 25 / 27 * (C1617 + 25 / 27 * (C1638 + 25 / 27 * (C1659 + 25 / 27 * (C1680 + 25 / 27 * (C1701 + 25 / 27 * (C1722 + 25 / 27 * (C1743 + 25 / 27 * (C1764 + 25 / 27 * (C1785 + 25 / 27 * (C1806 + 25 / 27 * (C1827 + 25 / 27 * (C1848 + 25 / 27 * (C1869)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + .439651095630187 * (C + .8 * (C21 + .8 * (C42 + .8 * (C63 + .8 * (C84 + .8 * (C105 + .8 * (C126 + .8 * (C147 + .8 * (C168 + .8 * (C189 + .8 * (C210 + .8 * (C231 + .8 * (C252 + .8 * (C273 + .8 * (C294 + .8 * (C315 + .8 * (C336 + .8 * (C357 + .8 * (C378 + .8 * (C399 + .8 * (C420 + .8 * (C441 + .8 * (C462 + .8 * (C483 + .8 * (C504 + .8 * (C525 + .8 * (C546 + .8 * (C567 + .8 * (C588 + .8 * (C609 + .8 * (C630))))))))))))))))))))))))))))))) > .410624808171576 * (C + 11 / 13 * (C21 + 11 / 13 * (C42 + 11 / 13 * (C63 + 11 / 13 * (C84 + 11 / 13 * (C105 + 11 / 13 * (C126 + 11 / 13 * (C147 + 11 / 13 * (C168 + 11 / 13 * (C189 + 11 / 13 * (C210 + 11 / 13 * (C231 + 11 / 13 * (C252 + 11 / 13 * (C273 + 11 / 13 * (C294 + 11 / 13 * (C315 + 11 / 13 * (C336 + 11 / 13 * (C357 + 11 / 13 * (C378 + 11 / 13 * (C399 + 11 / 13 * (C420 + 11 / 13 * (C441 + 11 / 13 * (C462 + 11 / 13 * (C483 + 11 / 13 * (C504 + 11 / 13 * (C525 + 11 / 13 * (C546 + 11 / 13 * (C567 + 11 / 13 * (C588 + 11 / 13 * (C609 + 11 / 13 * (C630 + 11 / 13 * (C651 + 11 / 13 * (C672 + 11 / 13 * (C693 + 11 / 13 * (C714 + 11 / 13 * (C735 + 11 / 13 * (C756 + 11 / 13 * (C777 + 11 / 13 * (C798 + 11 / 13 * (C819 + 11 / 13 * (C840 + 11 / 13 * (C861))))))))))))))))))))))))))))))))))))))))))

Monthly Exponential MACD 12,26 below its EMA9 Signal Line (or Histogram below 0):

.0348926326871455 * (C + 25 / 27 * (C21 + 25 / 27 * (C42 + 25 / 27 * (C63 + 25 / 27 * (C84 + 25 / 27 * (C105 + 25 / 27 * (C126 + 25 / 27 * (C147 + 25 / 27 * (C168 + 25 / 27 * (C189 + 25 / 27 * (C210 + 25 / 27 * (C231 + 25 / 27 * (C252 + 25 / 27 * (C273 + 25 / 27 * (C294 + 25 / 27 * (C315 + 25 / 27 * (C336 + 25 / 27 * (C357 + 25 / 27 * (C378 + 25 / 27 * (C399 + 25 / 27 * (C420 + 25 / 27 * (C441 + 25 / 27 * (C462 + 25 / 27 * (C483 + 25 / 27 * (C504 + 25 / 27 * (C525 + 25 / 27 * (C546 + 25 / 27 * (C567 + 25 / 27 * (C588 + 25 / 27 * (C609 + 25 / 27 * (C630 + 25 / 27 * (C651 + 25 / 27 * (C672 + 25 / 27 * (C693 + 25 / 27 * (C714 + 25 / 27 * (C735 + 25 / 27 * (C756 + 25 / 27 * (C777 + 25 / 27 * (C798 + 25 / 27 * (C819 + 25 / 27 * (C840 + 25 / 27 * (C861 + 25 / 27 * (C882 + 25 / 27 * (C903 + 25 / 27 * (C924 + 25 / 27 * (C945 + 25 / 27 * (C966 + 25 / 27 * (C987 + 25 / 27 * (C1008 + 25 / 27 * (C1029 + 25 / 27 * (C1050 + 25 / 27 * (C1071 + 25 / 27 * (C1092 + 25 / 27 * (C1113 + 25 / 27 * (C1134 + 25 / 27 * (C1155 + 25 / 27 * (C1176 + 25 / 27 * (C1197 + 25 / 27 * (C1218 + 25 / 27 * (C1239 + 25 / 27 * (C1260 + 25 / 27 * (C1281 + 25 / 27 * (C1302 + 25 / 27 * (C1323 + 25 / 27 * (C1344 + 25 / 27 * (C1365 + 25 / 27 * (C1386 + 25 / 27 * (C1407 + 25 / 27 * (C1428 + 25 / 27 * (C1449 + 25 / 27 * (C1470 + 25 / 27 * (C1491 + 25 / 27 * (C1512 + 25 / 27 * (C1533 + 25 / 27 * (C1554 + 25 / 27 * (C1575 + 25 / 27 * (C1596 + 25 / 27 * (C1617 + 25 / 27 * (C1638 + 25 / 27 * (C1659 + 25 / 27 * (C1680 + 25 / 27 * (C1701 + 25 / 27 * (C1722 + 25 / 27 * (C1743 + 25 / 27 * (C1764 + 25 / 27 * (C1785 + 25 / 27 * (C1806 + 25 / 27 * (C1827 + 25 / 27 * (C1848 + 25 / 27 * (C1869)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + .439651095630187 * (C + .8 * (C21 + .8 * (C42 + .8 * (C63 + .8 * (C84 + .8 * (C105 + .8 * (C126 + .8 * (C147 + .8 * (C168 + .8 * (C189 + .8 * (C210 + .8 * (C231 + .8 * (C252 + .8 * (C273 + .8 * (C294 + .8 * (C315 + .8 * (C336 + .8 * (C357 + .8 * (C378 + .8 * (C399 + .8 * (C420 + .8 * (C441 + .8 * (C462 + .8 * (C483 + .8 * (C504 + .8 * (C525 + .8 * (C546 + .8 * (C567 + .8 * (C588 + .8 * (C609 + .8 * (C630))))))))))))))))))))))))))))))) < .410624808171576 * (C + 11 / 13 * (C21 + 11 / 13 * (C42 + 11 / 13 * (C63 + 11 / 13 * (C84 + 11 / 13 * (C105 + 11 / 13 * (C126 + 11 / 13 * (C147 + 11 / 13 * (C168 + 11 / 13 * (C189 + 11 / 13 * (C210 + 11 / 13 * (C231 + 11 / 13 * (C252 + 11 / 13 * (C273 + 11 / 13 * (C294 + 11 / 13 * (C315 + 11 / 13 * (C336 + 11 / 13 * (C357 + 11 / 13 * (C378 + 11 / 13 * (C399 + 11 / 13 * (C420 + 11 / 13 * (C441 + 11 / 13 * (C462 + 11 / 13 * (C483 + 11 / 13 * (C504 + 11 / 13 * (C525 + 11 / 13 * (C546 + 11 / 13 * (C567 + 11 / 13 * (C588 + 11 / 13 * (C609 + 11 / 13 * (C630 + 11 / 13 * (C651 + 11 / 13 * (C672 + 11 / 13 * (C693 + 11 / 13 * (C714 + 11 / 13 * (C735 + 11 / 13 * (C756 + 11 / 13 * (C777 + 11 / 13 * (C798 + 11 / 13 * (C819 + 11 / 13 * (C840 + 11 / 13 * (C861))))))))))))))))))))))))))))))))))))))))))

QUOTE (bull1)
Also, I want to scan for stocks where the MACD is about to cross above the 9 EMA and for stocks where the MACD is about to cross below the 9 EMA.

It is generally only possible to create formulas for what a symbol has already done, not for what that symbol is about to do.

How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
bull1
Posted : Thursday, April 8, 2010 12:22:14 AM
Registered User
Joined: 3/9/2005
Posts: 10
Thanks for the formula Bruce.
bull1
Posted : Thursday, April 8, 2010 1:13:40 AM
Registered User
Joined: 3/9/2005
Posts: 10
Bruce,
the Monthly MACD above EMA9 formula is excluding stocks that should be included.  I think it happens when a stock has traded for a short time period such as under 4 years.  Can you correct the formula?

For example, the stock "LVS" has a monthly MACD above EMA9, but the "LVS" gets excluded by your formula.

Thanks.



Bruce_L
Posted : Thursday, April 8, 2010 9:11:40 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
It is not possible to "correct" the formula. It will not calculate for symbols with less than about three and a half years of data (it uses the Close from 861 Trading Days Ago in its calculations).

While it would be possible to create a formula that uses less data, doing so would result in a formula that would like return incorrect results for symbols with lots of data. As the formula gets shorter, the number of symbols for which it won't calculate decreases, but its accuracy decreases at the same time (and no matter how short you make it, some symbols will still be excluded).

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
bull1
Posted : Thursday, April 8, 2010 11:46:25 AM
Registered User
Joined: 3/9/2005
Posts: 10
Thanks Bruce for the reply.
"LVS" has traded since 2005, but is still excluded by the monthly MACD formula.  Is there a reason? or is my assumption wrong?
Bruce_L
Posted : Thursday, April 8, 2010 11:58:24 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
I was looking at the wrong part of the formula (I was looking at the part calculating the EMA12) when I said it needed 861-Trading Days of data earlier. It actually needs data for the Close from 1869-Trading Days Ago to calculate the EMA26 portion of the formula which is closer to seven and half years of data.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
bull1
Posted : Thursday, April 8, 2010 11:10:19 PM
Registered User
Joined: 3/9/2005
Posts: 10
Bruce,
does the weekly MACD calculation also need 1869 trading days?
thanks
Bruce_L
Posted : Friday, April 9, 2010 8:32:19 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
No, the oldest data the Weekly formulas need is from 445 Bars Ago.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.