Best Claude prompts for Financial and Investment Analysts

Using a dataset of historical stock prices, develop a step-by-step validation process for a linear regression model designed to predict future price movements based on a combination of technical and fundamental factors, including but not limited to moving averages, RSI, and earnings per share. Ensure the validation process includes a walkthrough of the data cleaning script, feature engineering, model training, and backtesting, and provide a comprehensive statistical summary of the results, including coefficients, p-values, and R-squared. Additionally, discuss potential limitations of the model and propose methods for addressing these limitations.

Design an optimized ETL pipeline for extracting data from a Snowflake database, transforming it into a usable format for analysis, and loading it into a Tableau dashboard for visualization. The pipeline should handle large volumes of data and incorporate data quality checks to ensure accuracy and completeness. Provide a detailed walkthrough of the pipeline architecture, including data ingestion, data processing, and data loading, and discuss strategies for optimizing query performance and reducing latency. Furthermore, outline a plan for monitoring and maintaining the pipeline to ensure ongoing data integrity and reliability.

Develop a comprehensive risk analysis for a portfolio of assets, including stocks, bonds, and commodities, using a combination of SQL and Python. The analysis should include a calculation of the portfolio's expected return and volatility, as well as a stress test to evaluate its potential performance under various market scenarios. Provide a step-by-step walkthrough of the analysis, including data retrieval, data processing, and results visualization, and discuss the implications of the findings for investment strategy and risk management. Additionally, propose methods for mitigating potential risks and optimizing portfolio performance.

Using a dataset of financial statements and market data, develop a data-driven approach to recommending investment opportunities in the technology sector. The approach should incorporate a combination of financial metrics, such as revenue growth and profit margins, and non-financial metrics, such as industry trends and competitive positioning. Provide a detailed walkthrough of the analysis, including data retrieval, data processing, and results visualization, and discuss the implications of the findings for investment strategy and portfolio construction. Furthermore, outline a plan for ongoing monitoring and evaluation of the recommended investments to ensure continued alignment with investment objectives.