Does anyone know of any (freebie) websites that list values of various moving averages (exponential and simple) for a stock? I'm getting conflicting values when I guestimate from the TC2000 curves (which don't provide the actual number) and compare these to values available in stockcharts.com. And in the freebie version of stockcharts, one can only see two MA's listed at a time. I'm hoping there are websites where I can see values for EMA's (10, 20, 50 200) and SMA's (20, 50 200), all nicely listed. And then see if they match! The calculation for an SMA is simple, so I don't expect to see conflicting values for them. But I'm beginning to suspect there are different ways being used to calculate EMA's. I do incidentally use intraday trading software which lists MA values, but would like to cross check this with other sources. It's nice to see that accurately knowing where the 200 SMA is is becoming important Thanks in advance
you could make tc2000 produce the actual numbers. just make a PCF for each moving average. then sort the list on the left by the PCF you want. it will list the value of the calculation. simple moving averages are easy. all you need is "AVGC20" for a 20sma. you can also do exponential, but it's a bit harder. let me know if you want to do exponential calculations.
Thanks for the response Gordon. If you have a PCF handy for EMA's in TC2000 that would be appreciated. I recently received a reply from TC2000 saying: " This is the exact formula used to calculate an exponential moving average in TC2000 and in TCNet: Exponential Average average = first price K = 2/(period+1) for each price after #1 average = ((price - average) * K ) + average" But I haven't tried PCFing it yet To be honest, I'm questioning the MA plots in TC2000 at the moment. Some of them move, depending on the zoom, and that doesn't seem right. For example, in zoom 6 the 200 ema might touch the top of a particular candle, then in zoom 3 it crosses the middle of the same candle. Not good. That is actually what triggered my original question
One place you might want to try is barchart.com- I know they have alot of technical data by stock. bob.
One place you might want to try is barchart.com- I know they have alot of technical data by stock. bob.
Thanks Bob, Barcharts does list key EMA's. Interesting though, that in their description they point out how they calculate their EMA's, and how others do it differently. Maybe that explains why so many people use SMA's vs EMA's. Although SMA's are less responsive to changes, at least everyone should be calculating them the same way, and are therefore looking at the same number. Cheers
i found this on the internet a while ago. this is how i calculate exponential mas in tc2000. these instructions might seem a little confusing, but it works perfect. the following is for a 21ema, but you could use this information to calculate any ema (you'd have to make some adjustments). if you have trouble, let me know..it's easy for me. From the Personal Criteria Formulas window, . Click: Create New . Name: #0 21-day EMA . Click inside Editing formula for ⦠window . Copy and Paste formula into the Editing formula for ⦠window: (2/(21+1)) . . Test: the result is the 21-day exponential percentage (ep) or 0.09 . Highlight and clear Editing formula for ⦠window. . Copy and Paste formula into the Editing formula for ⦠window: (1-(2/(21+1))) . . Test: the result is ep1 or 0.91 Next: Writing the 21-day EMA PCF Writing the 21-day EMA PCF For the 21-period EMA, copy the following formula to a word processor: (((((((((((((((((((((AVGC21.21 *ep1+C20*ep) *ep1+C19*ep) *ep1+C18*ep) *ep1+C17*ep) *ep1+C16*ep) *ep1+C15*ep) *ep1+C14*ep) *ep1+C13*ep) *ep1+C12*ep) *ep1+C11*ep) *ep1+C10*ep) *ep1+C9*ep) *ep1+C8*ep) *ep1+C7*ep) *ep1+C6*ep) *ep1+C5*ep) *ep1+C4*ep) *ep1+C3*ep) *ep1+C2*ep) *ep1+C1*ep) *ep1+C*ep) Replace: ep with 0.09 or the result of ep Replace: ep1 with 0.91 or the result of ep1 Count the number of â)â or right parens after each item in the list. The number of right parens must equal the number of â(â or left parens in the top line. Remove ALL spaces and line returns from the formula. Highlight and clear Editing formula for ⦠window. Copy the spaceless formula to the Editing formula for ⦠window. Test. If a Syntax Error occurs, . be sure the number of left parens equals the number of right parens. Calculate For: All Stocks Update All Criteria.