Sobre

Summary 1. Project Goal I want to build a macro-economic data collection application that automatically gathers key economic indicators, organizes them into structured tables (monthly & quarterly), and displays them clearly so I can visually compare changes between months for each indicator. This is NOT a trading bot. It is a data terminal / macro dashboard focused on clarity, structure, and consistency. ⸻ 2. Core Functionality (MVP – Phase 1) The application must: 1. Automatically collect macroeconomic data from official sources 2. Store the data historically (monthly values) 3. Display the data in tables exactly like a spreadsheet format 4. Allow easy comparison between months for the same indicator No AI bias, scoring, or trading logic is required in Phase 1. ⸻ 3. Currencies & Scope (Phase 1) Start with USD (United States) only. Later phases will extend to: • EUR (Eurozone) • GBP (United Kingdom) • JPY (Japan) ⸻ 4. USD – Required Economic Indicators (Phase 1) For the United States, the app must collect the following indicators: 1. Average Hourly Earnings m/m 2. Non-Farm Employment Change (NFP) 3. Unemployment Rate 4. JOLTS Job Openings 5. ISM Manufacturing PMI 6. ISM Services PMI 7. Core CPI m/m 8. CPI m/m 9. CPI y/y 10. Core Retail Sales m/m 11. Retail Sales m/m Each indicator has monthly frequency. ⸻ 5. Data Sources (Official / Reliable) Preferred official sources: • BLS (Bureau of Labor Statistics) – CPI, Core CPI, NFP, Unemployment Rate, AHE, JOLTS • ISM – Manufacturing PMI, Services PMI • US Census Bureau – Retail Sales, Core Retail Sales • FRED API can be used as an aggregator if easier Data accuracy and consistency are more important than speed. ⸻ 6. Data Structure & Storage The system should store: • Indicator name • Value • Release date • Month & year (for grouping) • Country (USD for now) Storage can be: • SQL database (preferred), or • Structured data storage suitable for historical queries ⸻ 7. Table Output Format (VERY IMPORTANT) The application must display data in quarter-based tables, structured like this: Example: USD – Q4 2025 Indicator Macroeconomic October November December Average Hourly Earnings m/m Non-Farm Employment Change Unemployment Rate JOLTS Job Openings ISM Manufacturing PMI ISM Services PMI Core CPI m/m CPI m/m CPI y/y Core Retail Sales m/m Retail Sales m/m 🔹 Each row = one indicator 🔹 Each column = month of the quarter 🔹 Values must be placed automatically in the correct month No interpretation, no commentary — raw data only. ⸻ 8. User Interface (Phase 1 – Simple) Minimum requirements: • Ability to select: • Currency (USD for now) • Quarter (Q1, Q2, Q3, Q4) • Display the table clearly (spreadsheet-like view) • Clean, readable layout A web dashboard is preferred, but a spreadsheet-style interface is acceptable for MVP. ⸻ 9. Automation Requirements • Data should update automatically when new releases are published • Manual refresh button is acceptable for MVP • System must avoid duplicate entries for the same month/indicator ⸻ 10. Future Phases (Not Required Now, But Important) Later upgrades will include: • EUR / GBP / JPY support • Quarterly summaries • Indicator comparison between currencies • AI-generated macro bias and analysis • Export to Excel / Google Sheets • Visual highlighting (better / worse vs previous month) These are out of scope for Phase 1, but architecture should allow scaling.