Investep Service Documentation
Symbol-specific earnings research is published separately so a dated market snapshot is never confused with the service's enduring operating contract. See the ORCL post-report intraday study: opening candles, returns after the first 15 minutes and hour, and Bollinger context across 15min/1h/1D. BMO uses the report session; AMC uses the next trading session.
Investep combines a public market-reference table, scheduled technical scans, strategy-specific alerts, deterministic replay, and a daily health report. It supports trading decisions; it does not place or close trades.
When enabled, the EOD workflow writes one policy-neutral Saliendo BB 1D
leveraged-ETF candidate. The separate alpaca-trade service owns the paper-only
10% allocation, +1.25% target, -0.75% stop, one-trade-per-session gate,
PostgreSQL lifecycle state, and the 15:55 ET close.
The 15:30 run has two phases. eod --phase signals fetches only daily bars,
sends the Saliendo BB 1D alerts and writes the candidate within minutes, so
the paper trade lands inside its 15:30–15:55 ET window. eod --phase table
then performs the multi-timeframe table refresh, whose rate-limited 1-hour
history alone takes about twenty minutes. A session without an eligible ETF
writes an empty candidate, which the trade step treats as no trade.
Only a restricted paper universe can become a trade (config/paper_trade.yml):
the ten largest companies by market capitalization in that run's table, one
share class per company, plus SOXX, SPY, IWM, QQQ, DIA, GLD, SLV and USO. The candidate is
chosen from every deliverable Saliendo BB 1D setup in that universe, not only
from the three nearest-band symbols the alert displays.
Public surfaces
- Signals — filterable market reference.
- Señales activas — configured detection and preparation rules.
- Estrategias — academy-method reference and reviewed print PDFs.
- Docs — this service guide.
The screened table contains companies with market capitalization strictly above
USD 1 billion and company country United States from TradingView, not merely
a US listing. Unknown country or missing/invalid capitalization excludes a stock.
NYSE and NASDAQ provide the screened exchange coverage. Its exact membership changes with the screen and data
availability.
Explicit stocks from config/stock_additions.yml are also included outside
the exchange screen, but must pass the same global country and capitalization filters.
Curated ETFs are exempt from these company filters. A complete country-provider
failure aborts the scan before replacing the existing universe; partial missing
country values exclude the affected stocks. Deployment requires a full refresh
before the new universe reaches table-scoped scheduled jobs.
UUUU (Energy Fuels, AMEX) remains a stock: all target, earnings,
technical and freshness gates still apply. Membership propagates through the
table snapshot to table-scoped alerts; method-specific universes are unchanged.
Its leveraged ETF candidates are issuer-verified UUUG (2×)
and UUUC (2×), selected by live 10-day average
volume after leverage. No live exact UUUU inverse was verified on 2026-09-18;
that field remains blank rather than substituting a sector inverse. A filing
alone is not a tradable listing; future exact matches can be discovered normally.
WhatsApp review windows
The generated channel matrix below defines each review window; the signal catalog identifies the destination of every strategy.
Opportunity messages contain one strategy and direction, actual send time in New
York and the number of listed assets. Per-symbol blocks show price, the relevant
ETF if available, readable confirmations and the original TradingView link. The
header links to the configured reference: bullish Momentum uses its detail
Google Sheet, while other strategies link to their public rules. Every company alert uses the same available
fundamentals: recommendation score and label (SB/B/H/S/SS), analyst count,
Low Target and Avg Target with signed percentage distance from the alert price,
and days to earnings. Missing values are omitted; ETF alerts omit company
fundamentals. Optionability remains a delivery eligibility input where required,
but WhatsApp alerts do not display CALL/PUT contract lines. Associated
leveraged/inverse ETFs may still appear beside the symbol. Earnings notices
include both directional ETF vehicles because they do not predict a direction.
Health/error messages have no asset investment details. Momentum 1H removes
Worden from both eligibility and messages. Combined BB uses weekly percentage
distance, greatest first; bullish Momentum 1H prioritizes Strong Buy (raw score 1–1.5), then nearest
absolute percentage distance to MA200 1H. Bearish Momentum ranks by MA200
distance only. Both headings count all eligible assets before the top-three cap;
the bullish Reglas link points to its detail Google Sheet. Unified
daily trends use nearest daily-band percentage distance.
Each strategy card in /signals/ documents its order-by criterion separately
from entry conditions, including direction, tie-break and presentation cap.
No candidates means no opportunity message. Control's daily health report shows the last technical evaluations, including zero matches, evaluation errors and missing/stale observations. These counts are not WhatsApp delivery receipts; API acceptance likewise does not prove receipt on a phone. Intraday dedup counts do not represent all daily notifications.
“También cumple” highlights another enabled strategy observed for that symbol, same direction and destination within 30 minutes on the same New York date. It is not a probability estimate, a delivery claim or a synchronized rescan. Later evaluations do not retroactively edit messages already sent.
Deployment requires renaming the existing Swing group to Investep Cierre and Diario to Investep Control, preserving their participants and group IDs. After merge, coordinate the rename and checkout update between scheduled runs; validate all four destinations before resuming sends. Do not create duplicate groups or deploy the new names before the existing groups are renamed. Rollback restores both old names and the prior checkout. No live renames occur during PR review.
Upcoming earnings notice
The market table's Earnings In column keeps TradingView's date/day count and adds BO (Before open) or AC (After close) from Nasdaq when the symbol and date match exactly. Daily/EOD scans query each represented date once within the next 14 calendar days, including today. Sorting and existing day-range filters remain numeric. Reports under five days retain their warning and show ? when timing cannot be confirmed; the tooltip explains the code, source and query time. Nasdaq dates/timing are expected and may change. Missing dates, provider failure, unmatched dates and ETFs do not acquire an inferred session. Intraday price refreshes preserve this separately timestamped metadata; they do not requery the calendar or imply the timing was just refreshed. Timing is table-only and does not change strategy earnings gates or the independent notice below.
Earnings próximos is an informational notice in Investep Cierre, separate from directional strategies and paper-trading candidates. Thirty minutes before the exchange's actual close it lists table-universe stocks expected to report after close today or before open on the next exchange session. Within each section, companies are ordered by descending table market capitalization, without a top-three limit. Long lists are split without separating a company's associated ETFs from its entry.
The Nasdaq earnings calendar provides explicit before-open/after-close classifications. Dates are expected, not guaranteed issuer confirmations. Missing or unrecognized timing is shown separately as Horario sin confirmar, never guessed from the date. ETFs do not report corporate earnings and are excluded as subjects; each stock's table metadata supplies both its leveraged and inverse ETF, when available, including daily leverage and any related-exposure qualification. This is not a CALL/PUT recommendation and the bearish tradability filter does not apply.
The Alpaca exchange calendar selects the next session across weekends/holidays and the actual close on early-close days. The workflow checks at 12:30 and 15:30 America/New_York; only the close-minus-30 check proceeds. NY daylight-saving time applies, rather than a fixed UTC offset. The table must have been refreshed on the same New York date. Both requested Nasdaq dates must load successfully before any send; provider errors fail the run instead of masquerading as zero matches. No relevant entries means no WhatsApp message.
Accepted message parts are journaled to Sheets Signals with Bogotá timestamps and their displayed symbols. Per-day event keys prevent ordinary retries from resending accepted parts; failed parts remain retryable. Partial delivery reports to Control while letting accepted parts reach Sheets. This is not transactional exactly-once delivery across WhatsApp, local state and Sheets: a crash between acceptance and state persistence can require reconciliation. No order or trading candidate is created by this notice.
The checked-in workflow is deployment intent only. After merge, import and verify its SSH/Sheets connections, Cierre destination and timezone before activation.
Schedule matrix
| Workflow | Cron | Command |
|---|---|---|
| Investep Earnings Notice | 30 12,15 * * 1-5 | entrypoint.py earnings-notice |
| Investep Hourly Gaps | 45 12,15 * * 1-5 | entrypoint.py gaps |
| Investep Premarket BB 15min | 25 9 * * 1-5 | -u entrypoint.py premarket |
| Investep Daily Signal | 0 9 * * 1-5 | entrypoint.py scan |
| Investep Intraday Tick | 13,28,43,58 9-14 * * 1-5 | entrypoint.py tick |
| Investep Daily Trend Signals | 30 15 * * 1-5 | entrypoint.py eod --phase signals |
| Investep Daily Check | 30 16 * * 1-5 | entrypoint.py health |
| Investep Combined Bollinger Returns 1D 1W 1M | 45 12,15 * * 1-5 | entrypoint.py bollinger --timeframe 1w1m |
| Investep Monthly Bollinger Returns (retired no-op) | 30 12,15 * * 1-5 | entrypoint.py bollinger --timeframe 1m |
This table is generated from checked-in n8n workflow JSON. It describes intended commands and cron expressions, not proof that a live workflow is active, uses a particular timezone, or matches the repository. Operational status must be verified against n8n at runtime.
Execution flow
The repository currently has a transitional execution model:
- Morning scan uses the complete legacy scanner to build the screened universe, fundamentals snapshot, table, summary, and compact 200-candle 1H cache.
- The package tick evaluates configured engine strategies on the forming candle. ATH runs every tick; the mirrored 1H trend rules run at :58 ET before each market-hour candle closes, except the disabled final 15:58 NY tick. A forced weekday run after 16:00 ET instead evaluates the completed 15:00–16:00 ET hour from that same session. The job dispatches alerts, saves successful-delivery dedup, then refreshes existing table rows.
- At 15:30 ET the pre-close job rebuilds the table, applies the strict mirrored
“Saliendo BB 1D” rules, sends the top three matches per direction
to Diario, and then runs any other configured
eodstrategies in an isolated engine pass. It writes the highest-ranked directional ETF candidate; n8n then invokesalpaca-tradeto validate and execute it. - One combined job fetches native Alpaca 1D, 1W and 1M candles. The latest available daily close must be outside all three same-side BB(20,2) bands. Daily candle color and close-to-close direction are not gates. It sends the three farthest matches by weekly percentage distance, 15 minutes before the actual exchange close (12:45/15:45 NY), excluding holidays. Delivery is blocked after the close. The standalone daily premarket return is disabled.
- Health reads artifacts and the live intraday workflow to produce a daily proof-of-life report.
The scan/EOD implementation remains transitional. The historical intraday CLI is now a wrapper around the engine and cannot restore deleted signals. Repository workflow definitions and live n8n state can differ, so this page does not claim that checked-in intent is deployed.
Signal catalog
Premarket reference
The premarket 15-minute trend-change strategies compare the latest available IEX trade with frozen BB(20,2) from the previous regular close. Bands use the final 20 complete SIP 15-minute regular-session candles, excluding extended hours; the close is the last of those candles. Alpaca's exchange calendar identifies the actual prior session, including holidays and early closes. Missing bars or a last IEX trade older than 60 minutes suppress that symbol (IEX premarket trades are sparse: a 3-minute cap left about 10 of ~1,900 symbols, missing even the largest companies); the alert shows the trade's New York time; zero usable evidence is an execution error, not a no-match result. IEX is real-time but not consolidated market data.
The signal is indicative preparation, not a guaranteed opening price. It uses only the crossing/inside-band rules shown in the catalog, not the separate trend signals' earnings, target, or moving-average gates. Each direction keeps the three largest matches by market cap and journals only delivered symbols. The job cannot send at or after 09:30 New York, even if its data fetch runs late.
Saliendo BB 1D — unified Momentum and Bollinger strategy
Both directions run in the existing 15:30 New York legacy EOD pass. The separate Saliendo BB signals are disabled. This is an AND intersection, not an OR union. Daily Momentum technical gates remain: daily MA20/40 positive for up (negative for down), daily MA100/200 opposite, no hourly MA or hourly-history requirements, directional daily MM20 slope, price inside the relevant BB and Upper rising for up / Lower falling for down. Strict MA20 inequalities from Momentum take precedence over Saliendo BB's inclusive zero. BB is SMA20 with two population standard deviations.
Stocks on both sides require earnings >14 days. Bullish stocks accept Buy or Strong Buy (the table's raw score 1–2.5, inclusive); bearish stocks retain Strong Buy only (score 1–1.5). Bullish stocks also require Avg Target above price. Low Target is informational only and has no minimum upside requirement. Bearish stocks retain Avg Target below price; Low Target is ignored. ETFs in the table universe are exempt from all fundamental filters, but retain every technical gate. Missing or invalid required stock fundamentals exclude the stock; unknown asset classes never receive an ETF exemption. Order is nearest to the relevant band first: Upper descending from negative zero, Lower ascending from positive zero; ties use symbol. Only the top three eligible candidates per direction are notified (vehicle filtering precedes cap). Standard bearish inverse/options eligibility, bullish optional leverage, option lines, original TradingView links and accepted-send Signals logging apply. The existing legacy delivery/journal path is retained; no additional engine notification is sent. Historical standalone Signals records remain unchanged.
BB 15-minute four-sigma return and two-sigma exit
The two Regreso BB 15min 4σ signals detect exposure beyond SMA20 ± four population standard deviations and beyond SMA20 ± two population standard deviations on both 1H and 1D on the same side, not a confirmed reversal. Above all three upper bands means a potential bearish return; below all three lower bands means a potential bullish return. All three timeframes must qualify simultaneously. Equality, zero dispersion, invalid prices or insufficient history do not qualify. No extra candle, earnings, target or return-movement condition is added; stocks and ETFs use the same technical criteria.
The two Saliendo BB 15min signals reuse this data and the same strict exposure checks with 2σ on all three timeframes. Above the upper bands in 15min, 1H and 1D means al alza / CALL; below all three lower bands means a la baja / PUT. A new crossing, candle color or confirmed turn is not required. The 4σ return points in the opposite direction from a 2σ exit on the same side; both can qualify concurrently beyond 4σ. Each strategy has independent ranking, top-three selection, interval dedup and delivery journal. For companies, consensus follows the alert direction, not the exposed band: bullish alerts require Buy or Strong Buy (raw score 1–2.5 inclusive), and bearish alerts require Sell or Strong Sell (raw score >3.5 and <=5). Hold, missing, nonfinite or out-of-range scores exclude the company before ranking. ETFs remain exempt from analyst consensus. This applies equally to premarket and intraday, and retains the bearish inverse-ETF/optionability delivery gate and broker exclusions. Premarket evidence is computed separately for 2σ and 4σ, using the same price and reference history; a missing 2σ payload never falls back to a 4σ band.
At 09:25 New York the existing premarket job uses SIP history ending at the
prior regular close: 20 complete 15-minute closes and 20 completed clock-hour
closes and 20 completed daily closes, with the same fresh IEX premarket trade (at most 180 seconds
old), and routes to Investep Apertura. It does not change the existing 2σ
strategies or table bands. During the session the existing tick evaluates at
:13/:28/:43/:58 (first regular run 09:43; no 15:58 tick), using its latest 20 IEX 15-minute
closes, including the forming bar, from a dedicated corporate-action-adjusted
history (adjustment=all, including dividends and splits). All three BB-return
timeframes use this adjustment basis, including the premarket reference history.
Intraday bars are restricted to calendar-defined regular sessions: 09:30 NY to
the exchange close, excluding premarket, after-hours, holidays and early-close
after-hours bars. Missing adjusted data suppresses this strategy; it never falls
back to the split-only data used by other strategies.
It routes to Investep Intradía. IEX is not consolidated data, so exposure
can differ from TradingView/SIP. The premarket coverage limitation still applies.
The 1H confirmation uses 20 clock-hour closes and population standard deviation
(ddof=0). Intraday it aggregates the already-fetched IEX 15-minute history on
every tick, including the current forming hour, independently of the :58-only
MA200 cache. A missing final :45 quarter in a completed hour fails closed.
The opening clock-hour contains only 09:30–10:00. Premarket uses a separate
adjusted SIP history request: it takes the final calendar-expected regular quarter
of each of the previous 20 clock-hours, including the 09:30–10:00 opening
half-hour and respecting holidays/early closes. Missing hourly closing quarters
exclude that symbol. All three premarket bands remain frozen; none includes the
premarket price. Messages show all three band values and distances. No live scheduler,
table band or unrelated strategy is changed.
Intraday 1D confirmation uses the 19 immediately preceding exchange-calendar
sessions' SIP closes plus the current IEX 15-minute close as today's forming daily
close, with population standard deviation (ddof=0). Historical daily data is
fetched before fresh IEX bars to avoid aging the signal price. Missing, duplicate,
nonpositive or nonfinite daily closes exclude that symbol; provider failure
suppresses these BB-return signals without disabling other tick strategies.
Each side sends at most three, ranked by abs(price - relevant_band) /
relevant_band * 100, descending, symbol as tie-breaker. The 1H and 1D bands are
confirmation only and does not affect ranking. Bearish candidates
require an inverse ETF or explicit optionability before ranking; bullish
candidates do not require a leveraged ETF, but include it when known. Existing
associated ETF and original-symbol TradingView presentation rules apply.
An accepted send is deduplicated for that symbol/strategy/15-minute interval;
continued exposure may notify again in the next interval. Only delivered symbols
are journaled automatically to Sheets by the existing premarket/tick workflows.
No new scheduler or separate credentials are required; deployment after merge
is still necessary before these strategies run in production.
The generated active-signals catalog is the single public inventory of enabled detection rules. It derives status, execution, scope, channel, and user-facing conditions from configuration. “Active” does not by itself prove that the live scheduler invokes the owning job.
Hourly and daily trend strategies use strict AND semantics: missing or unmeasurable evidence fails the setup. ATH retains its documented optional-data leniency.
The two hourly trend signals still measure the consecutive setup before the candidate candle, but the minimum is temporarily 0 for diagnosis, so this measurement does not currently filter opportunities. Bullish signals measure prior closes below their contemporaneous MA20; bearish signals measure closes above it. The count excludes the candidate candle, equality breaks the streak, and hourly signals measure 1H candles. Daily signals do not require or display a prior-MA20 candle streak. On the signal timeframe, MA20 confirms the breakout. For 1H, MA40 must also be positive for bullish signals and negative for bearish signals. For 1D Momentum (stocks and ETFs), MA40 is positive for bullish signals and negative for bearish signals, and the unrounded current MM20 1D must be strictly above/below its previous-session value respectively. Missing values or equal averages do not pass. Daily Saliendo BB retains negative MA100/200 distances for bullish signals and positive distances for bearish signals. Momentum 1H instead requires MA100 < MA200 and price > MA200 for up, mirrored for down. On 1D, up requires price strictly above MM20 and MM40 and below MM100 and MM200; down requires price strictly below MM20 and MM40 and above MM100 and MM200. These unrounded comparisons also apply to ETFs. No previous-bar cross of MA200 is required. The matching hourly candle, MA20/40 hourly distances, MA20 slope, MA20 15M and price inside the directional hourly BB are retained; Worden is no longer a gate. Stocks require directional Avg Target, earnings in at least 14 calendar days (including exactly 14), and Buy/Strong Buy for up or Sell/Strong Sell for down. ETFs are exempt from target, earnings and analyst consensus; all technical gates remain mandatory. Hourly and daily evaluation therefore require at least 200 candles on their respective signal timeframes. Saliendo BB 1D does not require hourly data or MA20/40/100/200 confirmation on 1H. Momentum does not require a daily candle classification or Worden threshold. The daily upper BB distance stays negative for up; lower BB stays positive for down.
All four trend strategies also require the relevant Bollinger band to open in
the signal's direction: upper now > upper on the previous candle for bullish
setups, lower now < lower on the previous candle for bearish setups. Daily
signals compare consecutive trading-session candles; hourly signals compare
consecutive hourly candles and also require daily opening in the same direction.
Momentum daily MM20/40/100/200 and BB use 199 prior calendar-aligned SIP daily closes and the
current IEX price; missing history fails closed. BB(20,2) uses population standard deviation (ddof=0)
and the comparison uses unrounded band prices, not price-to-band distances.
The current candle may still be forming. Equality, missing or non-finite values
fail closed. This is a directional band slope, not a requirement that both bands
move apart simultaneously or that total band width increases. All existing gates
remain required; the separate BB-return alerts are unchanged. The daily scanner
stores bb_1d_values from its actual daily bars and uses the same comparison as
the engine; older snapshots without those values cannot qualify until refreshed.
Universe scopes
| Scope | Membership |
|---|---|
table | Screened NYSE, NASDAQ; company country: United States; market cap > $1B; curated ETFs exempt |
strategies | SPY, NVDA, TSLA, META, AAPL, GOOG, AMZN |
Each strategy declares one scope. The engine unions only the scopes needed by a run, fetches each symbol once, and evaluates the strategy against its own scope.
Data sources and candle timing
| Data | Source |
|---|---|
| Screened universe, shares outstanding and book value per share | Yahoo Finance screener |
| Intraday, daily, weekly and monthly bars | Alpaca Market Data: IEX for latency-sensitive 15-minute checks; native SIP candles for broader and long-term scans |
| Average, low and high analyst targets, recommendation, sector, earnings and ATH/ATL | TradingView/FactSet scanner |
| Single-stock ETF liquidity | TradingView ETF scanner; exact ticker-to-underlying matching |
| Notifications | Self-hosted Evolution API |
The fundamental group presents Low Target, Avg Target, and High Target
in that order. Each shows the analyst target price and signed percentage distance:
(target − table price) / table price × 100. Dollar distances are not displayed.
Sorting and filters use percentage distance. Targets refresh with the full
scan; their distances refresh with the intraday table price. Missing/invalid
targets and ETF targets show a dash, never zero. These are analyst estimates,
not entry signals; existing alert rules continue using the average target.
TradingView fields are price_target_low and price_target_high; Finviz values
may differ by source update time, and its displayed percentages may use a
different price snapshot.
Intraday checks inspect the latest forming candle shortly before close. Hourly trend changes also require the unrounded MA20 1H to rise (up) or fall (down) versus the previous hourly bar. The difference must be strictly positive or negative respectively; flat or unavailable values suppress the signal for stocks and ETFs. This is a one-bar SMA change, not an angle threshold. Current session filtering retains bucket starts from 09:00 through 15:59 ET, so the first hourly bucket includes the 09:00 and 09:15 premarket bars. It differs from a TradingView hour anchored at the 09:30 regular-session open.
The only hourly freshness exception is explicit and fail-closed: after 16:00
ET, tick --force can use the final regular-market hour only if its latest IEX
bar is the 15:45 bucket from the tick's own weekday session. It does not reuse
an incomplete hour or the previous trading day's final hour. Normal scheduled
ticks retain the current-bar freshness requirement. The engine applies this
exception only while dispatching the two hourly trend strategies; ATH retains
its strict current-bar requirement.
The morning scan stores the last 200 native 1H candles per table symbol in an atomic cache. At :58, the engine overlays the current IEX-built hour onto that history before calculating MA20/40/100/200, Worden, candle type, and Bollinger distance. After alert delivery it persists the merged history for the next hour; dry-runs do not mutate the cache. If the cache is absent, corrupt, or short for a symbol, its hourly trend checks fail closed without blocking ATH or the table refresh.
Bearish notification eligibility
Every bearish WhatsApp candidate (stocks and ETFs) must have either a
selected associated inverse ETF or Opcionable = Sí in the Alpaca catalog.
Missing/unknown optionability without an inverse blocks the notification.
A leveraged long ETF or stock shortability does not satisfy this rule.
Each symbol block starts with icon, symbol and price under its strategy header. The second line names
its directional ETF when known: “ETF apalancado” for bullish moves or “ETF inverso”
for bearish moves. WhatsApp does not show an option contract line or percentage
plan. Bullish candidates without a leveraged ETF still send;
bearish candidates without either an inverse or known options do not.
An inverse ticker with missing leverage is still named,
without inventing a multiplier. TradingView links and journal symbols continue
to identify the original underlying, not its associated ETF.
Optionability carries the catalog limitations described below; it does not
guarantee a specific active put contract, liquidity or account permissions.
This is a delivery filter, applied before ordering/top-three selection in the shared dispatcher, the daily-trend sender and bearish daily-summary lists. Suppressed candidates do not consume notification slots, mark delivery dedup or create Google Sheets rows. If the daily bearish list is empty, no bearish daily notification is sent. Premarket/gap jobs distinguish deliberate suppression from an actual delivery failure. Bullish notifications and technical detection rules are unchanged; the table's strategy checklist can still show technical bearish matches that are not eligible for notification.
The full scan propagates optionability and its query timestamp into the shared universe snapshot, so all jobs use the same metadata as the table. Older snapshots without these fields allow bearish notifications only for known inverse ETFs.
Daily volume, optionability and strategy filters
Vol 1D shows accumulated share volume from the latest native Alpaca SIP daily
candle, with its New York session date. It is not average volume or a sum of
IEX bars. During the session it is partial and may lag 15 minutes; on weekends
or before a new daily bar exists, the date identifies the previous session.
The tooltip includes the exact share count and query time. The full scan loads
it and intraday ticks refresh it after alert delivery. A failed volume request
retains the previous value and query time; a missing symbol shows a dash.
Opcionable is Sí, No or a dash (unknown), using Alpaca's active US-equity
catalog and its has_options / legacy options_enabled attribute. It covers
both stocks and ETFs and refreshes with the full scan. This is a listing flag,
not account permission or a liquidity check. In particular, Alpaca documents
that has_options can remain for historical/expired contracts; it does not
prove a particular active call/put expiration is available. Provider failures
and absent assets remain unknown, never No.
Source: Alpaca assets API.
The Estrategias checklist above the table lists only enabled strategies from the same configuration as the public signal catalog. Select several to show the union (any selected strategy), intersected with the ordinary column filters. Clear all resets both. Each entry shows the timestamp, match count and evaluation coverage of its latest actual strategy run. An unavailable snapshot is disabled, not displayed as zero matches. A later zero-match run clears previous matches.
These are last-evaluation matches, not live setups at the latest table price. Premarket, hourly, pre-close and daily jobs evaluate at different times; their timestamps remain visible even after the table refreshes. All passing candidates are included before notification caps and delivery deduplication. No alert rules, schedules, WhatsApp messages or Sheets deduplication change. Disabled strategies are excluded even if an old snapshot file remains. The interface fetches the latest available snapshots on page load; reload to retrieve subsequent runs.
The market table shows analyst Recom on the familiar 1–5 scale (1 strong
buy, 3 hold, 5 strong sell), calculated from FactSet consensus counts. It also
publishes SHS Outstand from Yahoo's implied shares outstanding, falling back
to basic shares when needed, and Book/share from Yahoo's book-value field.
Book/share displays its signed percentage distance from the current row price:
(Book/share − price) / price × 100. It recalculates whenever the table loads
updated prices. Zero and negative book values are valid; a negative book value
can produce a distance below −100%. Missing book values show a dash; an invalid
or nonpositive price suppresses only the percentage. Sorting/filtering retain
their existing book-value basis. Book value is accounting data, not a price target.
Those definitions align with the corresponding Finviz concepts more closely
than the superficially similar TradingView fields. ETF
columns prefer leverage before liquidity: long 3×, 2×, then 1.5×; inverse 3×,
2×, then 1×; equal-leverage candidates use 10-day average share volume. Stocks
require exact single-stock matches. Curated fund associations are maintained in
config/fund_etfs.yml with issuer sources and require a current TradingView fund
listing. Related (non-identical) exposures are marked ≈ in the table and explicitly
labeled in WhatsApp; an unavailable product remains blank. The ten Bollinger columns are signed
value and percentage distances from close to the upper/lower BB(20,2) on 15M,
1H, 1D, 1W and 1M; they are context, not a replacement for internal alert logic.
The moving-average group ends with MA20 15min, immediately after MA200 1H,
and refreshes that value during each intraday table update.
Curated ETFs
The table and table-scoped alert universe include GLD, USO, SLV, BITO, SOXX, VGT, XLE, XBI, IYR, KRE and XLI, plus SPY, QQQ, IWM and DIA. These explicit additions bypass the company market-cap floor, not technical or freshness requirements. For each hourly/daily trend direction, ETFs alone are exempt from target price and earnings gates; stocks retain both. Fund AUM and NAV/share come from Yahoo and are separate from company market cap and book value. Inapplicable company fundamentals remain null; missing fund statistics do not remove a fund. Market-cap ordering ranks ETFs by fund AUM in place of market cap, so large index funds compete with the largest companies; values missing from both stay last. Native Alpaca bars supply the same indicators as for stocks.
Every directional alert mentions the selected leveraged ETF on an upward signal or inverse ETF on a downward signal when available. QQQ down can mention SQQQ; the TradingView URL, dedup key and Google Sheets journal retain QQQ. Candidates are selected by leverage and then current average volume from the curated catalog, not by a hardcoded volume ranking. KRE has no verified inverse in this catalog. Leveraged products reset daily; related commodity, crypto and sector exposures are not exact replicas or guaranteed hedges.
The table is arranged in decision order: identity and freshness; Bollinger (50%); moving averages (25%); technical confirmation; price levels; trading vehicles; and fundamental analysis last. Within technical groups, the table moves top-down from 1M to 1W to 1D to 1H to 15M. Hourly trend notification blocks rank by absolute percentage distance to MA200 1H, nearest first; unified daily trends rank nearest-band first. Combined Bollinger return notifications instead rank by absolute percentage distance beyond the weekly band, greatest first; daily and monthly exposure are gates only.
Each hourly trend direction is capped independently at three displayed symbols after nearest-MA200 percentage ordering (symbol breaks ties). Every displayed hourly symbol includes its generic TradingView chart URL, and only that displayed set is deduplicated and written to the Signals journal. Bullish hourly setups additionally require price above MA20 15M; bearish setups require price below MA20 15M.
The two combined Bollinger returns require exposure outside BB(20,2) on 1D,
1W and 1M at once, on the same side. The latest available daily SIP close is
compared with all three bands; SIP may lag. The daily candle can still be forming.
No color, neutral/bullish/bearish classification or daily return direction is
required. Missing or invalid data excludes the symbol.
They are journaled independently under their public names:
Regreso BB 1D 1W 1M a la baja and Regreso BB 1D 1W 1M al alza.
Missing any of the three timeframes excludes the symbol. Each message shows three percentage
distances; the top three use weekly absolute percentage distance as score, greatest first.
Monthly distance does not influence selection or ordering.
Superior is a PUT (arriba → abajo); inferior is a CALL (abajo → arriba). Each
is capped at three and includes close, daily/weekly/monthly
percentage distances and the TradingView link. Full rules are linked in the header.
Rollout: update the existing weekly n8n workflow in place to invoke
bollinger --timeframe 1w1m, then deactivate the existing monthly workflow.
The checked-in monthly workflow is inactive; that flag does not deactivate a live instance.
Legacy --timeframe 1w is an alias sharing the combined dedup file;
--timeframe 1m is a no-op, preventing duplicate sends during migration.
One combined job runs each trading day 15 minutes before the exchange close.
Preserve historical Signals rows; new deliveries use only the two combined names.
Refresh the public catalog/table evaluations on deployment.
The former standalone Regreso BB 1D signals are disabled and folded into this
combined job. Historical journal rows remain intact. The 09:25 premarket job
retains Cambio tendencia 15min. Only the previous regular close must be strictly
below its MA20 for up, above for down; the former seven-candle streak was
removed because the original method does not require it. It fetches at least
26 expected RTH bars; gaps or equality fail closed.
Salto 1H
The two mirrored gap alerts run once per trading session, 15 minutes before the calendar close: 15:45 New York normally, 12:45 on early closes. Up requires positive MA20/40 and negative MA100/200 hourly distances, at least 35 consecutive prior closes below their contemporary MA40, and current price above the previous regular daily close. Down mirrors every comparison. The current MA20 1H must also strictly rise for up, fall for down. The candidate is excluded from the streak, and equality breaks it; 35 candles is only approximately five days. Stocks require a directional analyst target and earnings more than five days away; ETFs are exempt. No candle, Worden, Bollinger or 15-minute MA gate applies.
The last 199 completed cached hourly bars plus a fresh IEX trade form the 200-bar calculation; missing/stale hourly history excludes a symbol. Prior daily close is fetched from the previous exchange session's SIP bar. Each direction sends at most three symbols by market cap to Diario, preserving directional ETF associations, original TradingView links and Signals journaling.
Alert channels
| Channel | Destination | Purpose |
|---|---|---|
apertura | Investep Apertura | Premarket: Cambio tendencia BB 15min, Regreso BB 1D y exposición BB 15min 3σ. |
intradia | Investep Intradía | Cambio tendencia 1H, exposición BB 15min 3σ y ruptura de máximo histórico durante la sesión. |
cierre | Investep Cierre | Momentum 1D, Regreso BB 1W 1M, Saltos y aviso informativo de próximos earnings. |
control | Investep Control | Resumen del mercado, estado de las evaluaciones y fallos de envío. |
Each strategy routes to exactly one channel. Channels represent reaction time, not strategy taxonomy.
After a WhatsApp strategy notification is accepted, its Bogotá timestamp,
strategy name, displayed symbol count, and symbols are appended to the
Signals worksheet in the configured Google Sheet. n8n owns Google
authentication. Dry-runs, failed WhatsApp deliveries, health reports, and
routine morning summaries do not create strategy-journal rows.
The bullish Momentum 1H al alza path also writes every eligible asset to its
dedicated detail sheet after delivery succeeds. Each row records the Bogotá
and New York delivery timestamps, the New York hourly candle, fundamentals,
and the 1H/15M/1D technical measurements. The detail sheet is uncapped and
upserts by session date, candle time, and symbol; the WhatsApp message and
standard Signals row remain capped at three symbols. The WhatsApp heading
counts every eligible asset, and its Reglas URL links to this detail sheet.
Failure and degradation behavior
| Condition | Outcome |
|---|---|
| Missing fundamentals snapshot | Table-scoped tick strategies have no universe and emit nothing. |
| Missing or fewer than 200 candles in the hourly cache | Hourly trend checks cannot evaluate MA200 and fail closed; ATH and table refresh continue. |
| Missing or stale symbol bar | That symbol cannot produce a current signal. Forced post-close hourly evaluation accepts only the same session's completed 15:00–16:00 ET hour. |
| Engine batch failure | Other strategy/direction batches continue, including in the same group; failed delivery is not confirmed in dedup. |
| Engine site-refresh failure | Logged after alerts; successful alerts remain delivered. |
| Pre-close engine-pass failure | Logged after the legacy table/trend pass; the published table remains available. |
| Google Sheets journal failure | WhatsApp remains delivered; n8n raises the append failure through its global error workflow. |
These guarantees apply to the engine tick; scan/EOD failure boundaries remain documented separately in the operational context.
Health report scope
The daily report checks table readability and age, the state date when present, last technical evaluation snapshots, enabled strategies missing a job, and the live command of the intraday workflow. It does not prove that every workflow is active or that committed systemd units are installed.
Limitations
- Signals are entry-side decision support; orders and exits are not automated.
- Premarket and the combined long-term return job check the exchange-holiday calendar; other jobs retain their existing scheduling behavior.
- Third-party feed coverage and latency can suppress an otherwise valid setup.
- Repository configuration and live scheduler state require separate checks.
Disclaimer
Investep provides informational market analysis. It is not investment advice and does not guarantee results. Confirm the complete setup, data freshness, risk plan, and order details before acting.
Strategy detail tabs in Investep Señales
The Signals summary and Estrategias analysis remain separate from the
strategy detail tabs in spreadsheet
193y6eRkm4pKi2D9WZ6dwUXuwaUlcOXOgt994_U07Skw:
Momentum 1H al alza(gid=377227137): all eligible hourly snapshots.Saliendo BB 1D al alza(gid=165527534): all eligible daily snapshots.
Both start with Candle Time New York, Symbol, Sector, Analyst Consensus, Analyst Score, Analyst Count, Current Price, Target Low, Target Average, Target High, and Days to Earnings. Remaining fields follow in their original relative order. Current Price is the price at the alert snapshot, not a live quote; it replaces the former Price / Price 1H label. Daily historical rows only preserve the candle session date, so their Candle Time New York contains that date without a fabricated intraday time.
Writers upsert by a single Record Key: session + hourly candle + symbol for Momentum, session + symbol for the daily strategy. This avoids n8n's single-match-column limitation. All detail writers and bullish WhatsApp reference links use these tabs. No code depends on the original standalone spreadsheets. Both originals were deleted through the connected owner Drive account after verifying all 248 Momentum and 34 daily historical snapshots in the destination tabs. Original fundamental and technical values are preserved. Sheets numeric date serials are normalized for session/candle dates; Next Earnings retains date formatting.