Best Jasper prompts for Financial and Investment Analysts

Create a Python script that utilizes historical stock prices to train a machine learning model for predicting potential risks associated with investing in a specific sector, incorporating technical indicators such as moving averages and Relative Strength Index (RSI), and then use this model to forecast the potential impact of a market downturn on a portfolio consisting of the following stocks: AAPL, MSFT, and GOOGL. Ensure the script includes data cleaning, feature engineering, and model evaluation metrics.

Design an optimized ETL pipeline using Snowflake and SQL for loading, transforming, and analyzing financial data from various sources, including CSV files, APIs, and databases, with a focus on minimizing data latency and maximizing query performance. The pipeline should handle data deduplication, handle missing values, and include data quality checks, ensuring that the final dataset is ready for analysis in Tableau.

Develop a comprehensive regression analysis in R to forecast future financial performance based on historical data, including revenue, expenses, and profitability metrics. The model should account for seasonal trends, external economic factors, and internal operational changes, providing a detailed statistical summary of the findings, including coefficients, p-values, and R-squared values. Use this analysis to predict the financial outlook for the next quarter.

Create a detailed dashboard in Tableau that displays key performance indicators (KPIs) for a portfolio of investments, including return on investment (ROI), Sharpe ratio, and value-at-risk (VaR). The dashboard should allow for filtering by investment type, sector, and time frame, and include visualizations to compare the performance of different assets and identify areas for portfolio optimization. Use a sample dataset that includes the following investments: bonds, stocks, and real estate, and calculate these metrics over the last year.