Prioritize news from watchlist

[FriendlyUser]

Prioritize news from stock list I track

• fstocks, the initial release does not matter as
• screeners from rbc, etc ...

Goal is to send myself news from companies I care about and/or from companies with low pes and/or low p/b

Download screener files from rbc direct investing, feed that into deno script that grabs data.

Created index using

CreateIndex({name:'ref_by_ts',source:Collection("Article"),values:[{field:['ts']},{field:['ref']}]})

Use

• sheetjs for deno
• read data from xlsx sheets from rbc direct invest
• use github actions as cron (before market opens, and afterwards)
• read data from faunadb for new entries.

Map(Paginate(Range(Match('all_docs_ts'),[ToMicros(ToTime('2020-07-14T06:30:00Z'))],[ToMicros(ToTime('2020-07-14T18:59:59Z'))])),Lambda(['ts','ref'],Get(Var('ref'))), {size: 1000})

remove size arg if it does not work

see

https://stackoverflow.com/questions/63353619/faunadb-how-to-paginate-count-all-documents-within-the-last-n-days

[FriendlyUser]

Fixed with commit 465296d3412a3cc3160396e65e393d0743c11aef