Portiqo7 is a next-generation platform designed to bring clarity and intelligence to portfolio management. It combines financial analytics, AI-driven insights, and seamless automation to help individual investors and professional asset managers make better decisions.
Check out the live application running on production: 👉 Portiqo7 - Launch App
- Real-time tracking of multiple portfolios with unlimited holdings per plan
- Advanced analytics including correlation matrices, risk metrics, and sector exposure
- Performance insights: Sharpe Ratio, Beta, Value at Risk (VaR 95%), Max Drawdown
- Diversification Score: AI-powered analysis of portfolio concentration risk
- Interactive visualizations: Using recharts for trends, allocation pie charts, and comparisons
- Historical data: 30 days (Free), 5 years (Pro), unlimited (Enterprise)
- Transaction tracking: Manual CSV import with automatic cost basis calculation
- Multi-currency support: Track international holdings with live exchange rates
- Document Summarization: Extract key insights from earnings reports, 10-Ks, and financial documents
- Market Sentiment Analysis: AI-driven sentiment scoring from aggregated news sources (News API)
- Interactive Assistant: Natural language queries powered by Google Gemini API
- Smart Recommendations: AI suggestions for diversification based on correlation analysis
- Risk Alerts: Automated notifications for over-concentration in sectors
- Contextual Answers: Portfolio-specific responses using historical data and current holdings
- Usage Limits: 10 requests/month (Free), 500/month (Pro), unlimited (Enterprise)
- Multi-tenant Organizations: Create unlimited workspaces for teams
- 4-Tier Role System: Owner, Admin, Member, Viewer with granular permissions
- Shared Portfolios & Watchlists: Collaborate on investment strategies across teams
- Smart Invitation System: Email-based invites with 7-day expiry tokens
- Auto-accept on Sign Up: New users automatically join organizations they were invited to
- Member Management: Add, remove, and change roles with permission enforcement
- Self-protection: Members cannot remove themselves or delete the organization owner
- Audit Logging: Comprehensive tracking of all sensitive actions (invites, removals, billing changes)
- 3-Tier Pricing: Free (hobbyists), Pro ($19.99/mo for investors), Enterprise ($99.99/mo for teams)
- Stripe Integration: Secure checkout with customer portal for self-service billing
- Real-time Webhooks: Automatic plan activation, renewals, and cancellations
- Usage Enforcement: Middleware-based limits per resource (portfolios, AI requests, PDF reports)
- Usage Dashboard: Live tracking of current consumption vs. plan limits
- Flexible Cancellation: Cancel anytime with access until period end
- Plan Comparison: Interactive pricing page with feature matrix
- 4 Report Types: Performance, Risk Analysis, Sector Breakdown, Full Comprehensive
- Professional PDFs: Generated with pdfmake library, ready for client presentations
- Manual Downloads: On-demand report generation with loading indicators
- Scheduled Delivery: Automated daily/weekly/monthly reports via email (Resend integration)
- Cron Automation: Hourly job processing scheduled reports
- Email Attachments: PDF reports delivered directly to inbox
- Report Management: View, edit, and delete scheduled reports
- Plan-based Limits: Free (0 reports), Pro (50/month), Enterprise (unlimited)
Portiqo7 is built on a modern, serverless architecture designed for scalability and performance:
┌──────────────────────────────────────────────────────────────────────────────────┐
│ USER (Browser/Mobile) │
├──────────────────────────────────────────────────────────────────────────────────┤
│ Clerk Auth │ Next.js Frontend │ TanStack Query │
└──────────┬──────────────────────────────┬──────────────────────────────┬─────────┘
│ │ │
▼ ▼ ▼
┌──────────────────────────────────────────────────────────────────────────────────┐
│ CLOUDFLARE WORKERS (Hono Backend API) │
├──────────────────────────┬───────────────────────────┬───────────────────────────┤
│ • Organization Middleware│ • Billing Integration │ • Error Monitoring (Sentry│
│ • RBAC Enforcement │ • Rate Limiting (Upstash) │ • Input Validation (Zod) │
│ • Usage Limits │ • PDF Generation │ • Audit Logging │
└─────┬─────────────┬──────┴──────┬─────────────┬──────┴──────┬─────────────┬──────┘
│ │ │ │ │ │
▼ ▼ ▼ ▼ ▼ ▼
┌──────────┐ ┌──────────┐ ┌──────────┐ ┌──────────┐ ┌──────────┐ ┌──────────┐
│ D1 (SQL) │ │ KV Cache │ │ Upstash │ │ Stripe │ │ Gemini │ │ Sentry │
│ Database │ │ Storage │ │ Redis │ │ API │ │ AI API │ │ Error │
│ (SQLite) │ │ (Session)│ │ (Limits) │ │ (Billing)│ │ (Chat/AI)│ │ Logs │
└──────────┘ └──────────┘ └──────────┘ └──────────┘ └──────────┘ └──────────┘
- Serverless-First: Edge computing via Cloudflare Workers for global low latency
- Type-Safe: End-to-end TypeScript across frontend, backend, and shared packages
- Multi-Tenant: Organization-based data isolation with role-based access control
- AI Integration: Google Gemini API for document analysis and conversational insights
- Real-time Data: Integration with Polygon.io for live market data and historical prices
| Layer | Technology |
|---|---|
| Frontend | Next.js 16 + TypeScript + Tailwind CSS |
| Backend | Cloudflare Workers (Hono Framework) |
| Database | Cloudflare D1 (SQLite) + KV Storage |
| AI/ML | Google Gemini API |
| Auth | Clerk (User Management & SSO) |
| Payments | Stripe (Subscriptions & Billing) |
| Rate Limit | Upstash Redis |
| Monitoring | Sentry (Error Tracking) |
| Deployment | Vercel (Frontend) + Cloudflare (Backend) |
| CI/CD | GitHub Actions |
Goal: User can manually input their portfolio and view its current value.
- Step 0: Tech Foundations ✅
- Step 1: Authentication (Clerk Integration) ✅
- Step 2: Backend - Portfolio API Endpoints ✅
- Step 3: Database - Cloudflare D1 Schema & Connection ✅
- Step 4: Secure Backend (Clerk Middleware for Auth) ✅
- Step 5: Frontend - Portfolio UI (TanStack Query Integration) ✅
Focus: Adding key visualization, data, and user management features.
- Step 6: Data Visualizations and Charts ✅
- Step 7: Financial News Aggregation ✅
- Step 8: Transaction Import (from File) ✅
- Step 9: Watchlists Implementation ✅
Focus: Leveraging AI to deliver intelligent, unique value.
- Step 10: Document Summarization (AI) ✅
- Step 11: Market Sentiment Analysis (AI) ✅
- Step 12: Interactive Portfolio Assistant (AI) ✅
Focus: Deeper financial analysis and risk/performance metrics.
- Step 13: Asset Correlation Analysis ✅
- Correlation matrix between tickers
- Heat map visualization
- Detection of strong relationships
- Step 14: Portfolio Risk Metrics ✅
- Sharpe Ratio (return/risk)
- Beta (volatility vs market)
- Value at Risk (VaR 95%)
- Diversification Score
- Step 15: Sector Exposure Analysis ✅
- Grouping by sectors
- Allocation % chart
- Alerts for over-concentration
- Diversification recommendations
Focus: Preparing the platform for commercial use and ensuring stability. Status: Completed! ✅
- Step 17: Multi-Tenant Organizations & Team Management ✅
- Create unlimited organizations (workspaces)
- Default organization created automatically for each user
- Invite team members via email with role selection (Viewer/Member/Admin)
- Time-limited invitation tokens (7-day expiry)
- Auto-accept invites on sign-up/sign-in flow
- Member list with role badges and management UI
- Remove members with RBAC enforcement (can't remove self or owner)
- Share portfolios and watchlists across organization
- Secure invitation system with token validation
- Dark backdrop behind Clerk authentication modal
- Step 18: Payment Integration & Subscription Management ✅
- Stripe Test Mode integration with 3 product tiers
- Checkout flow: Create session → Redirect → Payment → Webhook
- Webhook event handling (checkout.session.completed, customer.subscription.*)
- Subscription status tracking (active/cancelled/past_due)
- Customer portal for self-service billing management
- Plan badge display (FREE/PRO/ENTERPRISE)
- Success page with auto-redirect after payment
- Usage limit enforcement per plan tier
- Automatic plan upgrade/downgrade handling
- Step 19: Advanced Reporting & Automation ✅
- PDF generation with pdfmake library
- 4 report types: Performance, Risk Analysis, Sector Breakdown, Full
- Manual download with loading indicators
- Scheduled reports system with database table
- Cron job (hourly) for processing scheduled deliveries
- Email integration via Resend for report attachments
- Report management UI: create, view, delete schedules
- Plan-based limits: Free (0), Pro (50/month), Enterprise (unlimited)
- Step 20: Production Hardening & Security ✅
- Rate limiting with Upstash Redis ✅
/api/organizations: 10 requests/minute/api/billing/*: 5 requests/minute/api/reports/*: 5 requests/minute
- Input validation with Zod schemas on all endpoints ✅
- Comprehensive audit logging for sensitive actions ✅
- Audit log viewer for Admin/Owner roles ✅
- Middleware-based RBAC enforcement ✅
- Error monitoring with Sentry ✅
- Production deployment ✅
- GDPR compliance features ✅
- Rate limiting with Upstash Redis ✅
Focus: State-of-the-art machine learning models for market prediction and optimization.
- ⏳ LSTM Price Predictions
- Time series forecasting for individual stocks
- Multi-step ahead predictions (1-day, 1-week, 1-month)
- Confidence intervals and prediction accuracy metrics
- Integration with historical price data
- ⏳ Anomaly Detection
- Detect unusual portfolio behavior and market movements
- Real-time alerts for significant deviations
- Pattern recognition for fraud detection
- Historical anomaly analysis
- ⏳ Portfolio Optimization (Modern Portfolio Theory)
- Efficient frontier calculation
- Risk-return optimization
- Multi-objective optimization (return, risk, ESG)
- Rebalancing recommendations
- ⏳ Advanced Graph Neural Networks
- Sheaf-GNN for market relationship modeling
- Stock correlation networks
- Sector influence propagation
- Community detection in market structure
- ⏳ Technical Indicators Dashboard
- Moving Averages (SMA, EMA, WMA)
- RSI (Relative Strength Index)
- MACD (Moving Average Convergence Divergence)
- Bollinger Bands
- Support/Resistance levels
- Fibonacci retracements
- Volume indicators (OBV, VWAP)
- Trend strength indicators (ADX)
- ✅ Completed
- ⏳ In Progress
- ⬜ Planned
- 1 User (Solo)
- 1 Portfolio
- 20 holdings per portfolio
- 5 AI requests/month
- 30 days historical data
- Basic analytics
- 1 User (Solo)
- Unlimited portfolios
- Unlimited holdings
- 100 AI requests/month
- 5 years historical data
- Advanced analytics & risk metrics
- PDF Reports (Personal)
- CSV export
- 5 team members
- Unlimited portfolios & holdings
- Unlimited AI requests
- Full historical data
- Advanced analytics & risk metrics
- Unlimited PDF reports (Client-ready)
- Role-Based Access Control (RBAC)
- Priority support
Portiqo7 takes security seriously with multiple layers of protection:
- Authentication: Clerk-based SSO with MFA support
- Authorization: Role-Based Access Control (RBAC) for all resources
- Rate Limiting: API abuse prevention via Upstash Redis
- Input Validation: Zod schemas for all user inputs
- Audit Logging: Comprehensive tracking of sensitive actions
- Data Encryption: All data encrypted at rest and in transit
- Webhook Verification: Cryptographic signature validation for payment events
- Error Monitoring: Real-time alerts via Sentry
Portiqo7 implements a 4-tier role system with granular permissions:
| Category | Action | 👁️ Viewer | 👤 Member | 🛡️ Admin | 👑 Owner |
|---|---|---|---|---|---|
| PORTFOLIOS | View shared portfolios | ✅ | ✅ | ✅ | ✅ |
| Create new portfolio in organization | ❌ | ✅ | ✅ | ✅ | |
| Edit holdings & transactions | ❌ | ✅ | ✅ | ✅ | |
| Delete portfolio permanently | ❌ | ❌ | ✅ | ✅ | |
| WATCHLISTS | View shared watchlists | ✅ | ✅ | ✅ | ✅ |
| Create/Edit organization watchlists | ❌ | ✅ | ✅ | ✅ | |
| Delete organization watchlists | ❌ | ❌ | ✅ | ✅ | |
| TEAM | View member list | ✅ | ✅ | ✅ | ✅ |
| Send email invitations | ❌ | ❌ | ✅ | ✅ | |
| Remove Viewer/Member | ❌ | ❌ | ✅ | ✅ | |
| Remove Admin | ❌ | ❌ | ❌ | ✅ | |
| Remove Owner (impossible) | ❌ | ❌ | ❌ | ❌ | |
| REPORTS | Download PDF manually | ✅ | ✅ | ✅ | ✅ |
| Schedule automated reports (Pro+) | ❌ | ❌ | ✅ | ✅ | |
| ORGANIZATION | Manage billing & subscription plans | ❌ | ❌ | ❌ | ✅ |
| Delete entire organization | ❌ | ❌ | ❌ | ✅ |
- 👁️ Viewer (Observer): Read-only access. Perfect for clients, investors, or junior analysts who need to see data but not modify it.
- 👤 Member (Employee): Operational role. Can create and edit portfolios/holdings but cannot delete or manage team structure.
- 🛡️ Admin (Manager): Team management. Full data control including deletions and ability to invite/remove lower-tier members.
- 👑 Owner (Creator): God mode. Absolute control including billing, plan changes, and organization deletion. Cannot be removed by anyone.
Portiqo7 exposes a comprehensive REST API built with Hono framework:
Organizations
POST /api/organizations- Create new organizationGET /api/organizations- List user's organizationsGET /api/organizations/:orgId- Get organization detailsPATCH /api/organizations/:orgId- Update organization settingsDELETE /api/organizations/:orgId- Delete organization (Owner only)
Team Management
GET /api/organizations/:orgId/members- List all membersPOST /api/organizations/:orgId/members- Add member directly (internal)PATCH /api/organizations/:orgId/members/:userId- Change member roleDELETE /api/organizations/:orgId/members/:userId- Remove member
Invitations
POST /api/organizations/:orgId/invites- Send email invitationGET /api/organizations/:orgId/invites- List pending invitesGET /api/invites/:token- Get invite details (for accept page)POST /api/invites/:token/accept- Accept invitationDELETE /api/invites/:inviteId- Cancel invitation
Portfolios
GET /api/portfolios- List portfolios (filtered by organization)POST /api/portfolios- Create portfolioGET /api/portfolios/:id- Get portfolio detailsPATCH /api/portfolios/:id- Update portfolioDELETE /api/portfolios/:id- Delete portfolio
Holdings
GET /api/portfolios/:id/holdings- List holdingsPOST /api/portfolios/:id/holdings- Add holdingPATCH /api/holdings/:id- Update holdingDELETE /api/holdings/:id- Delete holding
Watchlists
GET /api/watchlists- List watchlistsPOST /api/watchlists- Create watchlistPOST /api/watchlists/:id/tickers- Add ticker to watchlistDELETE /api/watchlists/:id/tickers/:ticker- Remove ticker
Billing & Subscriptions
POST /api/billing/create-checkout- Create Stripe checkout sessionPOST /api/billing/create-portal- Redirect to Stripe customer portalPOST /api/billing/webhook- Handle Stripe webhooks (internal)GET /api/billing/subscription- Get current subscription detailsPOST /api/billing/cancel- Cancel subscription
Reports & Analytics
POST /api/portfolio/:portfolioId/report/generate- Generate PDF reportPOST /api/reports/schedule- Schedule automated reportGET /api/reports/scheduled- List scheduled reportsDELETE /api/reports/:reportId- Delete scheduled report
Usage Tracking
GET /api/usage- Get current usage limits and consumption
AI Features
POST /api/chat- Interactive portfolio assistantPOST /api/summarize- Document summarizationGET /api/sentiment/:ticker- Market sentiment analysis
Market Data
GET /api/market/:ticker- Real-time price and company infoGET /api/market/:ticker/historical- Historical price dataGET /api/news- Aggregated financial news feed
Audit & Security
GET /api/audit-logs- View audit logs (Admin/Owner only)
All endpoints require Clerk JWT tokens via Authorization: Bearer <token> header.
- Free: 100 requests / 10 seconds
- Pro: 500 requests / 10 seconds
- Enterprise: 2000 requests / 10 seconds
Portiqo7 is developed following modern best practices:
- Monorepo Architecture: Organized codebase with shared packages
- Type Safety: End-to-end TypeScript for compile-time guarantees
- Serverless-First: Edge computing for global performance
- Test-Driven: Unit, integration, and E2E tests with high coverage
- CI/CD: Automated testing and preview deployments on every PR
- Performance: Aggressive caching, lazy loading, and code splitting
- Accessibility: WCAG 2.1 AA compliance for inclusive design
| Home Page | Portfolios Dashboard | Holdings & Charts |
|---|---|---|
 |
 |
 |
| Welcome screen and main navigation. | Overview of all user portfolios. | Details and performance metrics. |
| News Feed & Sentiment Analysis | Watchlist & Smart Analytics | AI Document Summarizer | Interactive Assistant |
|---|---|---|---|
 |
 |
 |
 |
| Aggregated feed of the latest relevant market news. | Watchlists with smart portfolio analytics (correlation, risk). | Leveraging AI for quick document insights. | AI-powered chat for quick portfolio queries. |
| Portfolio Risk Metrics | Sector Exposure Analysis |
|---|---|
 |
 |
| Key metrics like Sharpe Ratio, Beta, and VaR (VaR 95%). | Allocation chart and alerts for sector concentration. |
Portiqo7 uses a multi-database architecture for optimal performance:
Cloudflare D1 (SQLite) - Primary Database
- Users: Managed by Clerk, referenced in all tables
- Organizations: Multi-tenant workspaces with plan tiers (Free/Pro/Enterprise)
- OrganizationMembers: RBAC with 4-tier role hierarchy
- OrganizationInvites: Email invitation system with 7-day expiring tokens
- Portfolios: User/organization-owned with sharing capabilities
- Holdings: Individual assets with cost basis tracking and transactions
- Watchlists: Tracked tickers with organization sharing support
- Subscriptions: Stripe integration for billing and plan management
- UsageLimits: Real-time enforcement of plan restrictions per resource
- ScheduledReports: Cron-based automation for PDF delivery
- AuditLog: Compliance and security tracking for all sensitive actions
Cloudflare KV Storage - Cache Layer
- User preferences and settings
- API response cache (5-minute TTL)
- Session data for improved performance
Upstash Redis - Rate Limiting
- Request throttling per endpoint
- Distributed rate limiting across workers
- Usage tracking for API abuse prevention
- KV Storage: User preferences, API response cache (5min TTL)
- Browser Cache: Static assets with immutable hashing
- SWR Pattern: TanStack Query for optimistic updates
- Edge Rendering: Next.js middleware at Cloudflare edge
- Code Splitting: Route-based lazy loading
- Image Optimization: WebP with responsive srcsets
- Bundle Size: Tree-shaking and dynamic imports (<100KB gzipped)
This is a showcase repository. The full application codebase resides in a private monorepo.
If you're interested in:
- Collaborating on specific features
- Reviewing the codebase for hiring purposes
- Partnering on commercial deployment
- Licensing the platform for your organization
Please reach out via email for access to:
- Private repository invitation
- Demo environment credentials
- Technical architecture documentation
- API reference and SDKs
We believe in building in public. Here's what's next:
Q1 2025 (Completed ✅)
- ✅ Phase 4 completion (Organizations, Billing, Reporting, Security)
- ✅ Production deployment with full monitoring
- ✅ GDPR compliance implementation
Q2 2026/03 (Current)
- ⏳ Phase 5: Advanced ML models (LSTM predictions, anomaly detection)
- ⏳ Technical indicators dashboard
- ⏳ Mobile app (React Native)
- ⏳ Public API beta launch
Q3 2026/04
- ⬜ Portfolio optimization (Modern Portfolio Theory)
- ⬜ Graph Neural Networks (Sheaf-GNN)
- ⬜ Social features (portfolio sharing, leaderboards)
- ⬜ Integration marketplace (brokers, tax software)
Q4 2026
- ⬜ Enterprise SSO (SAML, LDAP)
- ⬜ White-label platform
- ⬜ Regulatory compliance certifications (SEC, FCA)
Portiqo7 operates on a SaaS subscription model with three revenue streams:
- Direct Subscriptions: Individual and team plans via Stripe
- Enterprise Licenses: Custom deployments with white-label options
- API Access: Pay-per-call pricing for institutional integrations
Target markets:
- B2C: Retail investors, financial advisors, wealth managers
- B2B: Fintech companies, robo-advisors, portfolio management tools
- B2B2C: Banks and brokerages seeking white-label solutions
This showcase repository contains documentation, screenshots, and architectural overviews.
The actual source code is proprietary and not publicly available.
For licensing inquiries, please contact us directly.
Portiqo7 is being developed by a team passionate about combining AI, finance, and clean engineering. Our mission is to democratize sophisticated portfolio management tools previously available only to institutions.
Team Expertise:
- Full-stack development (10+ years)
- Financial engineering & quantitative analysis
- Machine learning & AI systems
- Scalable cloud architecture
- Product design & UX
📧 Email: takzen.app@gmail.com
🌐 Website: portiqo7.pl
Built with amazing open-source technologies:
- Next.js, React, TypeScript
- Cloudflare Workers & D1
- Hono, TanStack Query
- Clerk, Stripe
- Google Gemini AI
Special thanks to the developer community for continuous inspiration.
© 2025 Krzysztof Pika. All rights reserved.