Forecasting Economic Activity with Data-Mining

This product contains software that analyzes the Yield-Curve and High-Yield Credit Market to forecast the direction of economic activity.

Why did I create this?

I wanted software that could analyze key economic data from the Federal Reserve (like Yield-Curve Slopes & High-Yield Credit Spreads) to forecast the direction of the economy in service of helping me make better asset allocation decisions for my own investing portfolio.

Unfortunately, no such software existed so I had to build it myself.  

You’ll benefit from this if:

• You have an interest in the economy and investing.

• You want to better understand asset allocation theory and strategies.

• You are interested to see how low-code tools can be used to create powerful software.

• You are interested to see how open-source Federal Reserve data can be leveraged to analyze economic metrics like growth and inflation.

What’s inside:

• Complete software package in ready-to-execute format.

• 125 minutes of step-by-step video detailing the building of the software.

  • Video #1 - Setup database and folder structure

  • Video #2 - Downloading the first dataset (High Yield Credit Data)

  • Video #3 - Downloading the second dataset (Yield Curve Slope Data)

  • Video #4 - Setting up the UiPath program structure

  • Video #5 - Review the datasets.

  • Video #6 - Accessing Personal Excel Macro Workbook

  • Video #6.1 - Reviewing File Paths to Project Files

  • Video #7 - Build Excel Macro for First Dataset

  • Video #8 - Build Excel Macro for Second Dataset

  • Video #9 - Saving Macro Outputs to UiPath Variables

  • Video #10 - Setting UiPath Variables to Proper Variable Type

  • Video #11 - Writing to storage database from UiPath

  • Video #12 - Testing the software

  • Video #13 - Fully Automating the Software To Run Daily

• 15 minutes of video detailing the process of planning the software.

  • Video #1 – High Level Architecture

  • Video #2 – Pseudo-code for Functions & Execution

• 35 minutes of video providing background on the datasets that we’ll be using.

  • Video #1 – Bonds & Everything Bond Related

  • Video #2 – High Yield Credit Markets & Credit Spreads

  • Video #3 - Forecasting Macro Economic Activity From Bond Yields & Credit Spreads

• 12 minute Quick-Start video

• 30+ slides detailing all facets of the project

Disclaimer:

None of this constitutes investment advice, consult your own certified financial adviser before making investment decisions.

FAQs:

Does this work with the Community (Free) version of UiPath as well as the Enterprise version?

Yes, I have only used it on the Community version but there are no limitations that would prevent you from using it with other versions.

Is there a refund policy?

I do not offer refunds, purchases are final.

Will I need to create the software from scratch?

No, upon purchase you will receive files that contain all the compiled code. You will also receive videos that demonstrate how the code is built step-by-step, so you can build from scratch on your own if you choose to.

How do I know if this software is compatible with my computer?

You will need a version of Excel already installed on your computer. You will also need to install UiPath (Community Edition). These programs can run on Windows machines as well as Mac. For Linux users you’ll likely need to consult the UiPath & Excel help webpages for support on how to ensure proper function with the Linux kernel you are using.

What makes you qualified to create this?

I have undergraduate and graduate degrees in Computer Engineering and work as a Software Engineer by day, additionally I’ve read extensively on the topic of economics and investing and consider it a hobby.