Stockastic

Sign in to start validation

Stockastic
Users Home
Financial Funds Recommendations Indices Disclosed metrics Price normalization Financial data quality Financial statement scan Approvals

Today

Financial Info Validation Check a company's AI-extracted quarterly statements, metrics and ratios, fix errors, and publish the validated numbers. Fund Updates Update fund prices and details by hand, or trigger the price-fetch jobs; filter by source or fund name. Market Recommendations Log broker buy/sell calls — fundamental and technical — by hand or from a screenshot. Indices Constituents Keep EGX index membership current: toggle companies in the matrix or upload EGX's quarterly constituents files. Disclosed Metrics Capture figures companies state only in prose — CAR, NPL ratio, provision coverage, LCR. Price Normalization See a company's real close beside its cleaned (back-adjusted) close, every corporate action flagged; export both to Excel.

Under development features

Financial data quality Beta

What this week's checks found in the company figures on the website. Correct a figure in the financial editor, mark the current one as right, or set it aside with a note.

TickerPeriodFieldsWhy

More
FieldNowSuggestedChangeWhy

Tick the rows you want to act on, then choose what to do:

Opens this quarter in the financial editor at the ticked fields (a suggested value is filled in where the check has one). You correct them and press Confirm & Save there.
The check was wrong. Closes the finding; no data changes.
A known issue or not worth fixing. Closes the finding and keeps your note.

The financial editor can't open this quarter: its company isn't on the website, so it can't be fixed there — mark it correct or ignore it.

Financial statement scan Beta

Upload a company's financial statements PDF. We read it and set the figures aside: nothing reaches the website until you publish figures through the financial editor.

Type a company's name or ticker and press Find reports. You'll see its results filings from EGX of the last two years, with their copy in our Drive.

One report: quarterly or annual, Arabic or English.
Leave blank to find it from the company name.
Include
With a key, this scan runs on Google AI Studio and is billed to that key — it doesn't use today's allowance. Used for this scan only and never saved.

Scans

StatusCompanyPeriodFileScanned

Uses the PDF already read — no new scan, nothing counted against today's allowance.

More: every figure, side by side
FieldFrom the PDFCurrent figureChangeStatus

Tick the figures to publish.

Opens this quarter in the financial editor with the ticked figures from the PDF filled in. Check them, then press Confirm & Save there to publish. Ratios and the 12-month and yearly totals are recalculated by themselves.

Every line as printed in the PDF, in its own wording, before any mapping to our fields.

Every figure the notes give, as printed, with what the note says about it (interest-bearing, Islamic, rate, counterparty).

Written by the scan; publishing this quarter puts them on its website page.

Approvals

User Management

Portal accounts. Deactivating keeps the username resolvable in records it has already signed; deleting does not.

Loading users…
Username Role Status Created Updated Access Actions
No accounts found.

New user

Select Data Point

Validation worklist

Companies with statements for a quarter that no one has validated yet. Click one to open it.

Fetching data from Stockastic DB...

| Warehouse only

This is a historical quarter only our warehouse (BigQuery) holds — the website has no page for it. Its Trend Data fields are loaded from BigQuery, there are no statements to edit, and Confirm & Save writes to BigQuery only.

Balance Sheet

▼

Income Statement

▼

Cash Flow Statement

▼

Statement of Changes in Equity

▼

Notes Summary

Financial Summary

Company Information

Financial Metrics

Absolute values from financial statements

Financial Ratios

Calculated from the figures on the left when you save, so there is nothing to type here.

Show the ratios

Other figures

From StockAnalysis. This editor does not save or recalculate them, so they can't be edited here.

Fund Updates

Filter by source(s) and/or fund name, then edit a row's price and click Update. Administrators can also edit a fund's full details or add a new fund.

Fund Name Manager Source Last Updated Current Price Actions

No funds match the current filters.

Update prices using AI

Add each app's fund-list screenshots to its own box — as many as you like. Gemini reads every fund and price and matches it to our funds; a fund's own app decides its price. You also get, per app, the funds it lists that we don't have. Nothing is saved until you review and apply. Your API key stays in this browser.

🤖 AI can make mistakes, so revise wisely.

These jobs run on a schedule — trigger them here only when:

  1. You updated prices after the scheduled jobs ran. Run 1, then 2.
    • 1 · Sync prices to BigQuery runs daily at 9:00 PM Cairo.
    • 2 · Recompute YTD vs index runs at 9:30 PM Cairo, Sunday–Thursday.
    Prices edited before 9:00 PM are published by that night's run, so you don't need to trigger anything.
  2. You edited fund details (added a fund or changed its data) and need them in BigQuery. Run 3. Sync fund details to BigQuery runs automatically on the 1st of every month — any change made between those runs is not in BigQuery until you run it.

Market recommendations

Add or edit a recommendation. Fields adapt to your dropdown choices.

Symbol Source Action Opened at Created at Timeframe Type Status
No recommendations match the current filters.

New recommendation

Carried over
What happened?

Stop, targets, trend and timeframe are what an update moves — edit those below. Entry price, buy range, trigger and the source's published percentages are locked: they belong to the original call, and this step becomes the row every downstream return is measured from. If one of them is genuinely wrong, close this and correct the original step instead.

⚠️ Exit optional — fill in when the call is closed

A call counts as closed only once a Close reason is set. Close date may already hold the derived close datetime (from “Fill from timeframe”) while the call is still open — on its own it does not mark the call closed.

Import using AI

Upload an EFG, Mubasher or Rumble screenshot — Gemini extracts the recommendations for you to review and edit before saving. Your API key stays in this browser. Mubasher's new app shows one card per stock, so upload one image per call (several at once is fine); its old Trading Ideas table gave many rows in a single shot.

Paste a screenshot — Ctrl+V anywhere on this tab, or drop an image here. Adds to the files above.

🤖 AI can make mistakes, so revise wisely.

Indices constituents

Maintain EGX index membership. Edit the matrix directly, or upload the quarterly constituents file to diff & apply. Download the files from EGX Indices ↗.

No companies match the current filters.

Assign the correct index to each file (auto-guessed from the filename — change if wrong).

FileIndex

Added

Removed

New company

Price normalization

Real EGX close versus the cleaned (back-adjusted) close. Every corporate action is flagged at the day the price reacts; hover a point for the cumulative adjustment factor.

Stockastic

real vs cleaned

TradingView

open ↗

TradingView shows this line back-adjusted the same way we do — splits, bonus shares and cash dividends — so the two shapes should match. Check the ADJ badge at its bottom right is on. Levels can still differ: they rebase off their own latest close. A step we have and they do not (or the reverse) is a real finding worth chasing.

Corporate actions in range

Ex-dateActionAmountAnnouncementNotes
No corporate actions in this range.

Disclosed metrics

Record figures a company discloses in narrative form — capital adequacy, asset quality, liquidity. Ratios are typed as percentages and stored as fractions.

Symbol Period Source Entered by Created at
No disclosed metrics match the current filters.

New disclosure

Metric Value Stored as

Which company has a disclosure for which quarter. Click a filled cell to open it, an empty one to start that disclosure.

Bulk upload

One line per company-quarter, ratios written as percentages (22.1 = 22.1%) exactly as in the form above. Leave a metric blank when the company didn't disclose it. Nothing is saved until you review the preview.

ColumnRequiredValue