Best Grok prompts for Financial and Investment Analysts

Analyze the current market trends and provide a statistical summary of the top 5 performing stocks in the S&P 500 index over the past quarter, including their daily returns, volatility, and correlation with the overall market. Use a combination of SQL and Python to fetch the data from Snowflake and perform the necessary calculations. Then, create a Tableau visualization to display the results and identify potential investment opportunities. Assume a 95% confidence interval and a minimum of 100 trading days for the analysis.

Validate the performance of a given regression model used for predicting stock prices by evaluating its precision and accuracy on a holdout dataset. Use Python to load the model and the dataset from Snowflake, and then calculate the mean squared error, mean absolute error, and R-squared value. Compare the results to the model's performance on the training dataset and provide a detailed report on the model's strengths and weaknesses. Assume a 10% holdout dataset and a minimum of 1000 data points for the analysis.

Design an ETL pipeline to monitor data quality issues in a given dataset, including missing values, outliers, and data type inconsistencies. Use SQL to create a data validation script that checks for these issues and provides a detailed report on the findings. Then, use Python to create a data cleaning script that addresses the identified issues and provides a cleaned dataset for further analysis. Assume a minimum of 1000 data points and a maximum of 10% missing values for the analysis.

Develop a crisis monitoring system to detect potential market crashes or extreme events, such as a global economic downturn or a major company bankruptcy. Use a combination of SQL and Python to fetch real-time market data from Snowflake and create a statistical model that identifies potential warning signs, such as increased volatility or unusual trading activity. Then, create a Tableau visualization to display the results and provide a detailed report on the potential risks and recommended response strategies. Assume a 95% confidence interval and a minimum of 100 trading days for the analysis.