majiayu000 Arguments
$ARGUMENTS = TICKER CUTOFF_DATETIME [MONTH_OFFSET]
Examples:
AAPL 2025-04-01T00:00:00→ all news up to April 1stAAPL 2025-04-01T00:00:00 1m→ March onlyAAPL 2025-04-01T00:00:00 2m→ February onlyAAPL 2025-04-01T00:00:00 3m→ January only
Logic
Parse arguments:
- TICKER = first argument
- CUTOFF = second argument (datetime)
- MONTH_OFFSET = optional third argument (1m, 2m, 3m, etc.)
Calculate date range:
- If no offset:
start = '1900-01-01',end = CUTOFF - If offset Nm:
end= first day of month that is (N-1) months before CUTOFFstart= first day of month that is N months before CUTOFF
Example with CUTOFF = 2025-04-01T00:00:00:
- 1m → start: 2025-03-01, end: 2025-04-01 (March)
- 2m → start: 2025-02-01, end: 2025-03-01 (February)
- 3m → start: 2025-01-01, end: 2025-02-01 (January)
Query
MATCH (n:News)-[r:INFLUENCES]->(c:Company {ticker: $ticker})
WHERE n.created >= $start AND n.created < $end
RETURN n.created, n.title, r.daily_stock
ORDER BY n.created ASC
Output
Return pipe-delimited, one per line:
datetime|title|return
If no results: NO_NEWS_FOUND