# lastancientone/stock_analysis_for_quant architecture

> Architecture diagram of the GitHub repository lastancientone/stock_analysis_for_quant, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-03-31). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/lastancientone/stock_analysis_for_quant
- Repository: https://github.com/lastancientone/stock_analysis_for_quant

## Overview

This project is a comprehensive, multi-technology repository for quantitative stock analysis. Its purpose is to offer a wide range of analytical tools – from Excel models and VBA macros, to Matlab scripts, Power BI dashboards, extensive Python notebooks (covering technical indicators, forecasting, machine learning, and portfolio strategies), R scripts for regression, risk ratios, and technical analysis, as well as Tableau visualizations. The aim is to support quantitative research and the design and evaluation of trading and investment strategies across different asset classes.

##### Main Components
- Data Input and Sources: Although not a live data acquisition system, many files point to historical stock data (e.g., CSV files, Excel data, etc.). Label a “Data Inputs” component showing sources such as Yahoo finance downloads, CSV files (like ^GSPC.csv), and manually uploaded datasets.
- Analysis Modules per Technology:
- Excel Module: Contains a wide variety of workbooks for risk-adjusted ratios, portfolio strategies, technical indicators, etc. It even includes VBA macro-based modules.
- Matlab Module: Contains scripts and live script files (.m and .mlx) for daily return analysis and financial modeling.
- Power BI Module: Contains PBIX dashboards for stock analysis, forecasting, and visualization.
- Python Module: Contains numerous Jupyter notebooks grouped into topics (time series forecasting, technical indicators, portfolio strategies, options strategies, candlestick analysis, etc.) and subfolders that reflect advanced quantitative and mathematical applications.
- R Module: Contains multiple scripts organized into sections for forecasting, regression analysis, risk/return ratios, technical analysis, and time series studies.
- Tableau Module: Contains packaged workbooks for interactive stock analytics and candlestick charts.
- Common Themes/Functional Blocks:
- Data Preprocessing & Cleaning: Many notebooks and Excel sheets perform preprocessing steps (e.g., “Preprocessing_us_companies.xlsx” in the Excel_Machine_Learning folder, and similar tasks in R and Python).
- Quantitative and Statistical Modeling: There are dedicated modules for regression, risk-adjusted returns, technical indicators, and forecasting.
- Visualization & Reporting: Report/dashboards in Power BI and Tableau are clearly separated.
- Trading & Portfolio Strategies: Separate folders and workbooks outline various strategies and risk considerations.

##### Relationships and Interactions
- That each module “outputs” results such as dashboards, reports, or statistical summaries (for example, risk ratios, forecast figures, or trading signals) back to a “Reporting/Insights” layer.
- If needed, indicate common research or cross-validation flows – for instance, how models developed in one tool (e.g., in Python’s forecasting notebooks) can be compared with results from R or Excel.

##### Architectural Patterns and Design Principles
- Modularity: Emphasize the separation of components by technology (Excel, Matlab, Power BI, Python, R, Tableau); each module can be seen as an independent analysis “service”.
- Reusability: Many analytical techniques (technical indicators, risk measurement, forecasting) are reused across technologies. Label these as “common algorithms” that are implemented in multiple languages.
- Data Flow Orientation: The architecture should clearly show the flow of data from acquisition/preprocessing to analysis and then to visualization/reporting.

##### Relevant Technologies, Frameworks, and Tools
- Software: Excel (with VBA), Matlab, Power BI, Python (with Jupyter Notebook, libraries for machine learning and statistical analysis), R (with various statistical packages), and Tableau.
- That the repository is used for both “model development” and “analysis visualization”, and highlight that many files implement advanced quantitative methods (portfolio optimization, risk-adjusted returns, time series forecasting, and technical analysis).

## Diagram (Mermaid)

```mermaid
graph TB
    %% Data Ingestion Layer
    DataInputs["Data Inputs"]:::data
    click DataInputs "https://github.com/lastancientone/stock_analysis_for_quant/blob/master/PowerBI_Stock/^GSPC.csv"

    %% Preprocessing Layer
    Preprocessing["Data Preprocessing & Cleaning"]:::preprocessing

    %% Analysis Modules Subgraph
    subgraph "Analysis Modules"
        ExcelMod["Excel Analysis Module\n(Risk Ratios, Portfolio Strategies, VBA)"]:::analysis
        click ExcelMod "https://github.com/lastancientone/stock_analysis_for_quant/tree/master/Excel_Stock"
        
        MatlabMod["Matlab Analysis Module\n(Financial Modeling, Daily Returns)"]:::analysis
        click MatlabMod "https://github.com/lastancientone/stock_analysis_for_quant/tree/master/Matlab_Stock"
        
        PythonMod["Python Quant Notebooks Module\n(Time Series Forecasting, Technical Indicators)"]:::analysis
        click PythonMod "https://github.com/lastancientone/stock_analysis_for_quant/tree/master/Python_Stock"
        
        RMod["R Statistical Analysis Module\n(Regression, Risk/Return Ratios, Technical Analysis)"]:::analysis
        click RMod "https://github.com/lastancientone/stock_analysis_for_quant/tree/master/R_Stock"
        
        PowerBIMod["Power BI Dashboard Module\n(Interactive Dashboards, Forecasting)"]:::analysis
        click PowerBIMod "https://github.com/lastancientone/stock_analysis_for_quant/tree/master/PowerBI_Stock"
        
        TableauMod["Tableau Visualization Module\n(Interactive Analytics, Candlestick Charts)"]:::analysis
        click TableauMod "https://github.com/lastancientone/stock_analysis_for_quant/tree/master/Tableau_Stock"
    end

    %% Reporting/Insights Layer
    Reporting["Reporting & Insights\n(Combined Dashboards & Statistical Summaries)"]:::reporting

    %% Data Flow Connections
    DataInputs -->|"feeds"| Preprocessing
    Preprocessing --> ExcelMod
    Preprocessing --> MatlabMod
    Preprocessing --> PythonMod
    Preprocessing --> RMod
    Preprocessing --> PowerBIMod
    Preprocessing --> TableauMod

    ExcelMod -->|"outputs"| Reporting
    MatlabMod -->|"outputs"| Reporting
    PythonMod -->|"outputs"| Reporting
    RMod -->|"outputs"| Reporting
    PowerBIMod -->|"outputs"| Reporting
    TableauMod -->|"outputs"| Reporting

    %% Class Definitions for Colour Coding
    classDef data fill:#FFE0B2,stroke:#FF5722,stroke-width:2px;
    classDef preprocessing fill:#FFF9C4,stroke:#FFEB3B,stroke-width:2px;
    classDef analysis fill:#C8E6C9,stroke:#4CAF50,stroke-width:2px;
    classDef reporting fill:#BBDEFB,stroke:#2196F3,stroke-width:2px;
```
