{"id":"cda6f2a0-dd7c-45e9-8720-9910599e47b0","slug":"crewai-nihal108-bi-creawai-agent-azure","name":"creawai-agent-azure","description":"AI financial analyst using CrewAI agents to research stock tickers, combine market data with news sentiment, generate investment reports, and persist results with Azure Blob Storage and PostgreSQL. Built with Python, FastAPI, Streamlit, yfinance, Firecrawl, and Azure.","canonicalUrl":"https://www.xpersona.co/agent/crewai-nihal108-bi-creawai-agent-azure","sourceUrl":"https://github.com/Nihal108-bi/creawai-agent-azure","homepage":null,"source":"GITHUB_OPENCLEW","vendor":{"slug":"nihal108-bi","label":"Nihal108 Bi","url":"https://github.com/Nihal108-bi/creawai-agent-azure"},"protocols":["OPENCLEW"],"capabilities":["crewai","multi-agent"],"trustScore":null,"trustConfidence":"unknown","artifactCount":0,"benchmarkCount":0,"lastRelease":null,"freshnessAt":"2026-05-31T06:18:31.958Z","freshnessLabel":"May 31, 2026","securityReviewed":true,"openapiReady":false,"stats":[{"label":"Trust score","value":"Unknown"},{"label":"Compatibility","value":"OpenClaw"},{"label":"Freshness","value":"May 31, 2026"},{"label":"Vendor","value":"Nihal108 Bi"},{"label":"Artifacts","value":"0"},{"label":"Benchmarks","value":"0"},{"label":"Last release","value":"Unpublished"}],"factsPreview":[{"factKey":"vendor","label":"Vendor","value":"Nihal108 Bi","category":"vendor","href":"https://github.com/Nihal108-bi/creawai-agent-azure","sourceUrl":"https://github.com/Nihal108-bi/creawai-agent-azure","sourceType":"profile","confidence":"medium","observedAt":"2026-05-31T06:18:31.959Z","isPublic":true,"metadata":{}},{"factKey":"protocols","label":"Protocol compatibility","value":"OpenClaw","category":"compatibility","href":"https://www.xpersona.co/api/v1/agents/crewai-nihal108-bi-creawai-agent-azure/contract","sourceUrl":"https://www.xpersona.co/api/v1/agents/crewai-nihal108-bi-creawai-agent-azure/contract","sourceType":"contract","confidence":"medium","observedAt":"2026-05-31T06:18:31.959Z","isPublic":true,"metadata":{}},{"factKey":"handshake_status","label":"Handshake status","value":"UNKNOWN","category":"security","href":"https://www.xpersona.co/api/v1/agents/crewai-nihal108-bi-creawai-agent-azure/trust","sourceUrl":"https://www.xpersona.co/api/v1/agents/crewai-nihal108-bi-creawai-agent-azure/trust","sourceType":"trust","confidence":"medium","observedAt":null,"isPublic":true,"metadata":{}}],"highlights":["Trust evidence available"],"agentCard":{"name":"creawai-agent-azure","description":"AI financial analyst using CrewAI agents to research stock tickers, combine market data with news sentiment, generate investment reports, and persist results with Azure Blob Storage and PostgreSQL. Built with Python, FastAPI, Streamlit, yfinance, Firecrawl, and Azure.","source":"GITHUB_OPENCLEW","sourceId":"crewai:1217064585","repository":"https://github.com/Nihal108-bi/creawai-agent-azure","documentation":"https://www.xpersona.co/agent/crewai-nihal108-bi-creawai-agent-azure","protocols":["OPENCLEW"],"capabilities":["crewai","multi-agent"],"languages":["python"],"install":{"command":"git clone https://github.com/Nihal108-bi/creawai-agent-azure.git","ecosystem":"git"},"examples":[{"kind":"example","language":"mermaid","snippet":"flowchart TD\n User[\"User / Recruiter / Analyst\"] --> UI[\"Streamlit UI
frontend/app.py\"]\n User --> CLI[\"CLI Runner
main.py\"]\n UI --> API[\"FastAPI Backend
src/api/main.py\"]\n API --> Route[\"POST /api/v1/analyze
src/api/routes.py\"]\n CLI --> Crew[\"CrewAI Orchestrator
src/agents/crew.py\"]\n Route --> Crew\n\n Crew --> Quant[\"Senior Quantitative Analyst
src/agents/agents.py\"]\n Crew --> Strategist[\"Chief Investment Strategist
src/agents/agents.py\"]\n\n Quant --> Fundamentals[\"FundamentalAnalysisTool
Yahoo Finance metrics\"]\n Quant --> Compare[\"CompareStocksTool
1-year return vs SPY\"]\n Strategist --> Sentiment[\"SentimentSearchTool
Firecrawl news search\"]\n\n Fundamentals --> Report[\"Markdown Investment Report\"]\n Compare --> Report\n Sentiment --> Report\n\n Report --> LocalFile[\"Local file
investment_report_TICKER.md\"]\n LocalFile --> Blob[\"Azure Blob Storage
reports container\"]\n Report --> Postgres[\"Azure PostgreSQL
reports_log table\"]\n\n API --> Response[\"JSON response
report content + blob URL\"]\n Response --> UI\n\n click UI \"frontend/app.py\" \"Open Streamlit frontend\"\n click CLI \"main.py\" \"Open CLI entry point\"\n click API \"src/api/main.py\" \"Open FastAPI app\"\n click Route \"src/api/routes.py\" \"Open API route\"\n click Crew \"src/agents/crew.py\" \"Open CrewAI orchestration\"\n click Quant \"src/agents/agents.py\" \"Open agent definitions\"\n click Strategist \"src/agents/agents.py\" \"Open agent definitions\"\n click Fundamentals \"src/agents/tools/financial.py\" \"Open financial tools\"\n click Compare \"src/agents/tools/financial.py\" \"Open comparison tool\"\n click Sentiment \"src/agents/tools/scraper.py\" \"Open Firecrawl tool\"\n click Blob \"src/shared/storage.py\" \"Open Azure Blob service\"\n click Postgres \"src/shared/database.py\" \"Open database service\""},{"kind":"example","language":"mermaid","snippet":"sequenceDiagram\n autonumber\n participant U as User\n participant API as FastAPI / CLI\n participant Crew as CrewAI Crew\n participant Q as Quantitative Analyst\n participant S as Investment Strategist\n participant YF as Yahoo Finance\n participant FC as Firecrawl\n participant AZB as Azure Blob\n participant DB as Azure PostgreSQL\n\n U->>API: Submit ticker\n API->>Crew: run_financial_crew(ticker)\n Crew->>Q: Task 1 - collect financial metrics\n Q->>YF: Fetch fundamentals and SPY comparison\n YF-->>Q: Structured market data\n Q-->>Crew: Quantitative summary\n Crew->>S: Task 2 - synthesize recommendation\n S->>FC: Search recent news and sentiment\n FC-->>S: Top scraped search results\n S-->>Crew: Final markdown report\n Crew-->>API: Crew output\n API->>AZB: Upload report markdown\n API->>DB: Save ticker, content, timestamp\n API-->>U: Report content and blob URL"}]}}