StockFetcher Forums · Indicators and Measures · Date Based References (DATE)<< >>Post Follow-up
stockfetcher
963 posts
msg #126346
11/30/2015 9:26:33 AM

Date Based References (DATE)

ParametersPeriod Indicator
UsageDATE(YEARSTART,open) DATE(MONTHSTART,RSI(10))
DescriptionThe DATE([PERIOD],[INDICATOR]) function allows you to access past values of measures based on specific dates in the past. In function, this feature works similar to the "days ago" phrase, as it modifies the desired measure; however, you can provide specific instructions on the actual offset of the days ago phrase. The example below returns matches that are more than 10% above the opening price for the year.
Fetcher[close is more than 10% above DATE(YEARSTART,open)]

Value PERIOD values are:
  • YEARSTART: Initial value of the indicator for the year
  • YEAREND: Last value of the indicator for the prior year
  • MONTHSTART: Initial value of the indicator for the month
  • MONTHEND: Final value of the indicator for the prior month
  • MONDAY - FRIDAY: Value from the specific day of the week
  • YYYYMMDD: Specfic date
More examples: To find stocks that are below the RSI(10) from the start of the month:
Fetcher[RSI(10) is below DATE(MONTHSTART,RSI(10))]

Fetcher[/* Plot the return based on the start of the year */ set{var1, DATE(YEARSTART,open)} set{diff, close - var1} and draw var1 on plot price and draw diff and plottype{diff,zerobar} and close is above 3.00 and average volume(30) is above 250000]

Fetcher[/* Plot the return based on the start of the month */ set{var1, DATE(MONTHSTART,open)} set{diff, close - var1} and draw var1 on plot price and draw diff and plottype{diff,zerobar} and close is above 3.00 and average volume(30) is above 250000]

Fetcher[/* Reference a specific date */ set{var1,DATE(20130211,close)} draw var1 on plot price and close is above 4.00 and average volume(30) is above 250000]

Fetcher[/* Stocks more than 10% below last year close */ set{var1, DATE(YEAREND,close)} draw var1 on plot price and close is more than 10% below var1 and close is above 4.00 and average volume(30) is above 250000]

Fetcher[/* Price last FRIDAY gained more than 10% */ set{change,close - open} set{ratio, change / open} set{pct, ratio * 100.0 } set{var1, DATE(FRIDAY,pct)} show stocks where var1 is above 10 and close is above 3.00 and average volume(30) is above 250000]



StockFetcher Forums · Indicators and Measures · Date Based References (DATE)<< >>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