StockFetcher Forums · Announcements · New Feature: Custom Moving Averages<< 1 2 >>Post Follow-up
stegosaurus1
5 posts
msg #31486
Ignore stegosaurus1
3/22/2004 10:25:32 AM

Hi Tom,

I tried the following and it didn't appear to work:

Fetcher[
AND DATE OFFSET IS 0
AND MARKET IS NASDAQ AND MARKET IS NOT OTCBB
AND PRICE IS BETWEEN 2 AND 6 AND AVGVOL(10) IS ABOVE 100000

AND SET{cl2cl,CLOSE MINUS CLOSE 1 DAY AGO}
AND SET{temp1,cl2cl MULTIPLIED BY VOLUME}
AND SET{myMFI,temp1 DIVIDED BY 1000}

AND CMA(myMFI,10) is above CMA(myMFI,20)

AND ADD COLUMN cl2cl {cl2cl}
AND ADD COLUMN myMFI {myMFI}
AND ADD COLUMN CMA(myMFI,10) {myMFI10}
AND ADD COLUMN CMA(myMFI,20) {myMFI20}
]



In looking at the column values of myMFI, I just guessed that CMA didn't support user variables.

Thanks for the quick response and SF sample.

Dan.


tomb
267 posts
msg #31487
Ignore tomb
3/22/2004 10:34:39 AM

Hi,

When I ran your example, the values appeared to be correct to me. What are you seeing in your results? Also, below is an example that adds the "draw" command to your example to plot the values on the chart.

Fetcher[
AND DATE OFFSET IS 0
AND MARKET IS NASDAQ AND MARKET IS NOT OTCBB
AND PRICE IS BETWEEN 2 AND 6 AND AVGVOL(10) IS ABOVE 100000

AND SET{cl2cl,CLOSE MINUS CLOSE 1 DAY AGO}
AND SET{temp1,cl2cl MULTIPLIED BY VOLUME}
AND SET{myMFI,temp1 DIVIDED BY 1000}

AND CMA(myMFI,10) is above CMA(myMFI,20)

AND ADD COLUMN cl2cl {cl2cl} and draw cl2cl
AND ADD COLUMN myMFI {myMFI} and draw myMFI
AND ADD COLUMN CMA(myMFI,10) {myMFI10} and draw CMA(myMFI,10)
AND ADD COLUMN CMA(myMFI,20) {myMFI20} and draw CMA(myMFI,20)

]



The first line of the results for me (sorted in descending volume) is:

SUNW, cl2cl=-0.09 mymfi=-3695.11 mymfi10=-6286.10 mymfi20=-5626.55

Hope the above helps!

Tom
StockFetcher.com Support




stegosaurus1
5 posts
msg #31488
Ignore stegosaurus1
3/22/2004 11:00:34 AM

Hi Tom,

Do you get 270 returns on the query?

Yes, I get the same results for SUNW, but isn't -6286 ~BELOW~ -5626?

SUNW cl2cl=-0.09 mymfi=-3695.11 mymfi10=-6286.10 mymfi20=-5626.55


The following are two examples from the 1st page of results that should be mutually exclusive:

SIRI cl2cl=0.03 mymfi=977.28 mymfi10=972.04 mymfi20=1445.92 (mymfi10 ~BELOW~ mymfi20)
MFCO cl2cl=0.59 mymfi=2513.34 mymfi10=497.31 mymfi20=248.68 (mymfi10 ~ABOVE~ mymfi20)

Thanks for your help.

Dan.


tomb
267 posts
msg #31489
Ignore tomb
3/22/2004 12:13:33 PM

Hi,

That was my mistake, I was just looking to verify that the CMA is computed on a variable. It turns out that the problem is related to the "multiplied by" "divided by" phrases in your "set{}" syntax. When using the "set" syntax it is best to use the actual mathematical symbol. We will look into why the text-versions did not produce consistent results, but the filter below should do a bit better:

Fetcher[
AND DATE OFFSET IS 0
AND MARKET IS NASDAQ AND MARKET IS NOT OTCBB
AND PRICE IS BETWEEN 2 AND 6 AND AVGVOL(10) IS ABOVE 100000

AND SET{cl2cl,CLOSE - CLOSE 1 DAY AGO}
AND SET{temp1,cl2cl * VOLUME}
AND SET{myMFI,temp1 / 1000}

AND CMA(myMFI,10) is above CMA(myMFI,20)

AND ADD COLUMN cl2cl {cl2cl} and draw cl2cl
AND ADD COLUMN myMFI {myMFI} and draw myMFI
AND ADD COLUMN CMA(myMFI,10) {myMFI10} and draw CMA(myMFI,10)
AND ADD COLUMN CMA(myMFI,20) {myMFI20} and draw CMA(myMFI,20)
]



Tom
StockFetcher.com Support


stegosaurus1
5 posts
msg #31491
Ignore stegosaurus1
3/22/2004 2:02:40 PM

Tom,

Thanks for having the tenacity to stick with a problem until a solution (or workaround LOL!) was found.

Dan.


defghca
150 posts
msg #31729
Ignore defghca
4/14/2004 8:34:03 AM

Tomb
cema(indicator,days) in the works?


yepher
353 posts
msg #32001
Ignore yepher
5/7/2004 11:52:50 AM

Can you add a third optional parameter to CMA so you can offset it in time just like DMA?


john0024
7 posts
msg #119177
Ignore john0024
4/21/2014 6:48:55 AM

What if I just wanted to check a monthly moving average over another monthly moving average? Say for example, the ma of 4 months vs. the ma of 30 months, how would I write this? (All basis the close)

Kevin_in_GA
4,553 posts
msg #119178
Ignore Kevin_in_GA
4/21/2014 8:41:43 AM

SF does not provide monthly data.

StockFetcher Forums · Announcements · New Feature: Custom Moving Averages<< 1 2 >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2016 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus