Signal Xpress — Admin Console (Prototype)

Total Users

4,281

▲ 128 new this week

VIP Members

612 / 14.3%

▲ 23 conversions this month

Signals (30d)

347

72.4% win rate · synced 12s ago

Pending Moderation

12

8 posts · 4 comments

Performance

Pips & win rate — synced from Google Sheet

Moderation Inbox

Awaiting your review

12 pending

MK

Marcus K.VIP2m ago

Closed XAU/USD at +84 pips 🎯 TP3 hit exactly as planned. Chart screenshot attached…

💬 6 comments🔥 24 reactions

RT

Ravi T.Free9m ago

New trade idea on GBPJPY — expecting a retest of 194.20 before continuation…

💬 2 comments📣 trade_idea

SD

Sara D.VIP21m ago

Comment on “NFP reaction play”: “Anyone else stopped out on that wick?”

💬 comment queue

Latest Signals

Live from sheet sync

REALTIME

#	Pair	Dir	Entry	Pips	Hit
#347	AU XAU/USD	BUY	2 641.50	+112	TP3
#346	EJ EUR/JPY	SELL	163.240	+47	TP2
#345	GU GBP/USD	BUY	1.27180	−25	SL
#344	UJ USD/JPY	SELL	151.905	+64	TP1

Role Distribution

4,281 users total

VIP customers

Paid subscribers

612

Free customers

Freemium tier

3,655

Admins

Team accounts

14

Moderation Queue

Posts & comments pending review · approval gates from community_settings

REALTIME

MK

Marcus K.VIPtrade_update2m ago

Closed XAU/USD at +84 pips 🎯 TP3 hit exactly as planned. That London-open continuation was textbook — wait for the sweep, then ride it. 🔥

PairXAU/USD

Entry2 641.50

Exit2 650.90

Pips+84

ROI+12.4%

BrokerXM

💬 6🔥 24🚀 11#gold #nfp

AL

Aisha L.VIPscreenshot14m ago

My equity curve after 3 months following the Signal Xpress room 📈 Consistency is everything — no revenge trades, just the plan.

🖼️ 1 image💬 18❤️ 96

JT

James T.Freecomment31m ago

Comment awaiting review: “Stop posting fake results, nobody believes this 🤡” — flagged automatically by moderation rules.

auto-flaggedon “Weekly recap”

Active Signals

18

Live in the app right now

Win Rate 30d

72.4%

▲ 3.1% vs last month

Net Pips 30d

+3,184

Avg 106 pips / signal

Reactions (7d)

5,290

🔥 61% · 🚀 27% · 👍 12%

Signals Registry

signals table · sheet_hash diff sync every minute · tombstones on delete

No	Pair	Dir	Entry	SL	TP1–TP4	Pips	Result	Reactions	Status
#347	XAU XAU/USD	BUY	2641.50	2634.00	45 / 78 / 112 / 160	+112	WIN	🔥 214	TP3 HIT
#346	EJ EUR/JPY	SELL	163.240	163.610	18 / 34 / 47 / 70	+47	WIN	🔥 96	TP2 HIT
#345	GU GBP/USD	BUY	1.27180	1.26930	22 / 40 / 62 / 90	−25	LOSS	💔 88	SL HIT
#344	UJ USD/JPY	SELL	151.905	152.260	20 / 41 / 64 / 95	+64	WIN	🚀 143	TP1 HIT
#343	AU AUD/USD	BUY	0.66480	0.66220	15 / 30 / 48 / 72	—	OPEN	👍 54	PENDING

Trades Registry

trades table · sheet_hash + level_status JSON

No	Date	Pair	Dir	Pips	Profit	Result	Hit Level
#347	01 Oct	XAU/USD	BUY	+112	$1,120	WIN	TP3
#346	01 Oct	EUR/JPY	SELL	+47	$470	WIN	TP2
#345	30 Sep	GBP/USD	BUY	−25	−$250	LOSS	SL
#344	30 Sep	USD/JPY	SELL	+64	$640	WIN	TP1
#343	30 Sep	AUD/USD	BUY	—	—	OPEN	—

Google Sheet Sync

signals:sync-sheet · cron every 1 minute

HEALTHY

Auto-sync schedule

Runs signals:sync-sheet every minute — diffs rows by the No column.

Colour → hit level mapping

Sheet cell colours map to hit_level (TP1–TP4 / SL / BE) and fire “TP2 Hit!” pushes.

Tombstones for deleted rows

Prevents deleted sheet rows resurrecting in the app.

→ 09:41:02 synced 347 rows · 2 changed
→ 09:40:01 synced 347 rows · 0 changed
→ 09:39:01 updated #346 → level_status TP2
→ 09:38:02 broadcast SignalUpdated XAU/USD

Last upload: ib-sept-2026.csv · 1,204 records

Total Lots (30d)

8,412.7

▲ 11% vs last month

Total Commission

$14,286

across 612 members

Avg Lots / Member

13.7

Top: Marcus K. — 214 lots

Unmatched Accounts

7

needs review

Lots by Member

Top 8 from latest CSV upload

Commission Breakdown

Per partner group

Partner	Members	Lots	Commission
Alpha IB Group	148	2,914.2	$4,954
Nexus Capital	121	2,201.8	$3,743
Pro Traders Hub	96	1,764.5	$3,000
Elite FX	84	1,102.3	$1,874
Others (3)	163	429.9	$715

User Directory

PATCH /api/admin/users/{id}/role · vip settings via /api/admin/vip-settings

User	Role	Broker / Account	Partner	Joined	Status
MK Marcus K. marcus@fxmail.com	VIP	XM · 4471902	Alpha IB	12 Mar 2026	Active
RT Ravi T. ravi.t@gmail.com	Free	—	—	28 Sep 2026	Active
SD Sara D. sara@proton.me	VIP	Exness · 8830411	Nexus Capital	04 Jan 2026	Active
JT James T. james.t@outlook.com	Free	—	—	19 Sep 2026	Flagged
AL Aisha L. aisha.l@gmail.com	VIP	IC Markets · 5519204	Pro Traders Hub	22 Jun 2026	Online

IB Partners

ib_partners table · mirrored to Google Sheet

Partner	Members	VIP	Lots (30d)
A Alpha IB Group	148	42	2,914
N Nexus Capital	121	35	2,202
P Pro Traders Hub	96	28	1,765
E Elite FX	84	21	1,102

Recent Members

users rows with partner_id set

Member	SX ID	Broker	Partner
Dilan R.	SX-10482	XM	Alpha IB
Priya M.	SX-10481	Exness	Nexus
Tom H.	SX-10480	IC Markets	Pro Traders
Yuki S.	SX-10479	XM	Elite FX
Omar F.	SX-10478	Exness	Alpha IB

VIP Leaderboard

vip_members · shown in the mobile app

#	Trader	Lots	Win Rate	Favorite Pair	Trades
1	Marcus K. VIP	214.8	78%	XAU/USD	142
2	Sara D. VIP	187.3	74%	EUR/USD	128
3	Aisha L. VIP	166.0	71%	GBP/JPY	119
4	Dilan R. VIP	142.6	69%	XAU/USD	97
5	Priya M. VIP	128.4	67%	USD/JPY	88

Economic Calendar

market_news · synced from nfp.ourforecast.com/calendar.json

SYNCED 4m AGO

Time	Cur	Impact	Event	Forecast	Previous	Actual
12:30	USD	HIGH	Non-Farm Payrolls	185K	142K	223K
12:30	USD	MED	Average Hourly Earnings m/m	0.3%	0.4%	0.2%
14:00	USD	MED	ISM Services PMI	52.5	51.4	—
15:30	CAD	MED	BoC Rate Statement	4.25%	4.50%	—
17:00	USD	LOW	Crude Oil Inventories	-1.2M	+2.1M	—

Online Now

184

▲ live via presence heartbeat

Background

342

App minimized

Peak Today

517

at 14:32 (news release)

Devices

731

68% Android · 32% iOS

Live Presence Board

device_presence · polled via /admin/presence/data

LIVE

MK

Marcus K.Online · XAU/USD chart

SD

Sara D.Online · Community

RT

Ravi T.Background · 4m ago

AL

Aisha L.Online · Signals feed

JT

James T.Online · News

DR

Dilan R.Background · 12m ago

PM

Priya M.Online · Leaderboard

TH

Tom H.Online · Chat

Community Moderation

community_settings keys · POST /api/community/settings

Require post approval

New posts land in pending until an admin approves them.

Require comment approval

Hold comments for review before they appear in the feed.

Require chat approval

Live chat messages enter a moderation queue first.

Max post length

Characters allowed per community post.

VIP Upsell Settings

/api/admin/vip-settings · shown to free users

WhatsApp number

WhatsApp link

Upgrade note

XM broker note

Integrations

env-driven services

Google Sheets sync

SIGNAL_SHEET_URL · IB_GOOGLE_SHEETS_URL

Connected

Telegram notifications

TELEGRAM_BOT_TOKEN

Connected

Firebase FCM push

storage/app/firebase-credentials.json

Connected

Centrifugo realtime

channels: trading:signals, trading:community, chat…

Connected

Market SSO

market.signalxpress.com OAuth

Connected

Balances & Env

SettingsController — writes .env (handle with care)

Start balance

Deposit balance

Withdraw balance

Telegram chat ID

⚠ Saving here rewrites your .env file. In production, prefer environment changes over in-app env editing.

DB: signalxp_backend_db · MySQL 8 · last backup 2 days ago

Backup Files

/admin/database-backup · storage-backed .sql dumps

File	Size	Created	Tables
SQL backup_signalxp_2026-09-29_120000.sql	18.4 MB	29 Sep 2026, 12:00	26
SQL backup_signalxp_2026-09-22_120000.sql	17.9 MB	22 Sep 2026, 12:00	26
SQL backup_signalxp_backend_db_2026-09-16_094253.sql	17.2 MB	16 Sep 2026, 09:42	26