Forecast PMI

Question

Forecast PMI

television 0

How could Excel better support a macroeconomic forecasting workflow for predicting U.S. Q4 PMI for investment and risk management?

For example, could Power Query, dynamic-array formulas, LAMBDA, Power Pivot/DAX, and interactive charts be integrated more seamlessly so users can automatically combine economic data, create lagged indicators, run regression/scenario forecasts, backtest the model, and visualize Base/Bull/Bear PMI scenarios in one workbook?

The goal is not to fix errors, but to make Excel capable of supporting a complete, refreshable economic forecasting and risk-analysis workflow.

0 comments

1 answer

Your answer

Answer 1

Ivory 1,415 Independent Advisor

Hi television,

Based on your description, the request focuses on enhancing Excel capabilities such as:

Power Query for data acquisition and transformation
Dynamic-array formulas and LAMBDA for feature engineering and reusable calculations
Power Pivot and DAX for data modeling
Forecasting, scenario analysis, and backtesting
Interactive charts and dashboards for visualization

Since these features are primarily part of the Excel ecosystem, your suggestion would be best reviewed by the Excel community, where users and subject matter experts with experience in advanced Excel modeling and analytics can provide more specialized guidance and feedback. You can create a post in the Excel Community and describing your proposed workflow there under Data Analytics tag.

User's image

Thank you for sharing your idea regarding a more integrated macroeconomic forecasting and risk-analysis workflow in Excel.

If the answer is helpful, please click "Yes" and kindly upvote it. If you have any extra questions about this answer, please click "Comment".

Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

television 0 Reputation points

2026-09-15T03:26:47.3766667+00:00

Hi. You may not be an expert in this field, but the answer you gave was truly superficial. If that is the extent of your input, I think you shouldn't be "advising" me; it would have been more reasonable to simply tell me to search on Google or ask an AI chatbot instead.
Ivory 1,415 Reputation points Independent Advisor

2026-09-15T15:55:17.3666667+00:00

Hi television,

I think there may have been a misunderstanding regarding the reason for the referral.

Your question wasn't a typical Excel support question such as how to fix a feature, resolve an error, or troubleshoot a workbook. It was a broad discussion about how Excel could evolve to support an end-to-end macroeconomic forecasting and risk-analysis workflow, including integration of Power Query, Power Pivot, DAX, LAMBDA, dynamic arrays, scenario modeling, backtesting, and visualization.

That's an interesting topic, but it's also quite specialized and touches on solution architecture, financial modeling, and potential product enhancements. Because of that, I felt that the Excel Community would be a better place to get detailed feedback from Excel MVPs, power users, economists, data analysts, and others who regularly build models of this nature.

The suggestion was not meant to dismiss your question or avoid answering it. Rather, it was an attempt to direct it to people who are more likely to have hands-on experience with the specific forecasting workflow you're describing.

I apologize if my original reply came across as superficial. That was not my intention, and I do appreciate the level of thought behind your question.
Mr White 105 Reputation points

2026-09-16T03:10:47.84+00:00

As you said, this could be a little specialized topic. Yes but I realized that I had a high expectation that should not be. Just wanna say that if you could ask anything before redirecting me to another place and repeat again my question, that would be more acceptaled.
Mr White 105 Reputation points

2026-09-16T03:15:24.91+00:00

I think this forum just for troubleshooting right? Even it provide many documents and training courses, the Q&A section was splited to this Learn and Tech community. Based on your reply, I guess so. Hopefully it could be merged or any article or notification tell me about this. Thanks again.
television 0 Reputation points

2026-09-16T07:04:33.27+00:00

Never mind, just wondering that if Excel Community have "users and subject matter experts with experience in advanced Excel", then this "Microsoft 365 and Office | Excel | For education | Windows" or any would contains which "advisors" at some levels?