JoeMcDonald
My Resume and Areas of Interest
Example Tools Used.
Tradestation
I use the TradeStation platform as a market analysis and screening tool across equities, futures, and other financial instruments. I use it to run screens, monitor technical indicators, and track price trends, volatility, and market behavior across different asset classes. I also use TradeStation’s API to export market data and integrate it into my Python and Excel-based models for further analysis and research. This allows me to combine market data with my own indicators, forecasting models, and analytics workflows. The platform is an important part of my overall process for market monitoring, data collection, and quantitative analysis.

Currency Array Indicator Tradestation
I use the Currency Array indicator to monitor the relative strength and weakness of major global currencies by tracking all 28 major currency pairs in a single interface. This allows me to quickly identify which currencies are strengthening or weakening, which pairs are trending, and which markets are moving sideways or showing signs of consolidation. By viewing currencies as a group rather than as individual pairs, the indicator helps identify broader macro trends, shifts in risk sentiment, and divergence between currencies within the same currency complex. This is particularly useful for understanding global capital flows, interest rate expectations, and macroeconomic sentiment across regions. The tool is used as part of my broader macro and cross-asset analysis to help monitor global financial market trends and currency-driven macro conditions.

Visual Studio
use Python in Visual Studio to build custom analysis tools, automate data collection, and connect different parts of my workflow across Excel, PowerPoint, Word, and Outlook. Using API connections, Python can pull financial and economic data from external data providers, process and organize the data, and then push the results into Excel for modeling, charting, and further analysis. From there, Python can automatically update PowerPoint presentations with new charts and data, generate Word reports with updated tables and commentary, and help prepare Outlook emails with attachments or summaries for distribution. This allows data to move seamlessly between programs and significantly reduces the amount of manual work required to update reports, presentations, and investor materials. The goal of this system is to create a repeatable workflow where data is collected, analyzed, and turned into reports and presentations efficiently, which supports research, investor communication, and business development activities.

Excel Python
I use Python directly within Excel to manage data, run custom analysis, and integrate data from external API data sources. This allows me to pull financial and economic data directly into Excel, process and structure the data using Python, and then use Excel for modeling, analysis, and charting. Using Python within Excel makes it possible to clean data, run statistical analysis, build custom indicators, and automate repetitive data tasks without leaving the Excel environment. This is particularly useful for working with large financial datasets, time-series data, and models that need to be updated frequently. Combining Python and Excel creates a flexible environment for financial modeling, data analysis, and building repeatable research and reporting workflows.

FRED API Plugin
I use the Federal Reserve Economic Data (FRED) API within Excel to pull macroeconomic and interest rate data directly into my models and research dashboards. This allows me to automatically update datasets such as Treasury yields, inflation data, housing indicators, employment data, and other economic time series without manual data entry. The data can then be used in Excel models, charts, and market indicators that track changes in economic conditions and capital markets. Using the FRED API ensures that macroeconomic data is always current and allows economic indicators to be integrated directly into financial models and research reports. This is an important part of my workflow for tracking interest rates, economic trends, and broader market conditions.

Apollo.io CRM
I use Apollo.io as an AI-assisted outreach and CRM platform to manage business development campaigns and investor communication. The platform allows me to segment contacts based on firm type, investment focus, geography, and other criteria, and then generate customized emails and outreach messages tailored to each group. This is particularly useful when sharing research reports, presentations, and investment materials, because messages can be framed differently depending on whether the recipient is a family office, RIA, institutional investor, or operating partner. The platform also helps track communication history, manage follow-ups, and maintain an organized outreach pipeline. This creates a more structured and scalable process for business development, investor outreach, and relationship management.

Connecting MS Office w/Python
I use Python together with Microsoft Excel, PowerPoint, and Word to automate repetitive tasks and speed up the process of turning data into analysis and presentation materials. Data can be pulled from external sources using APIs, processed and analyzed in Python, sent into Excel for modeling and charts, and then exported into PowerPoint and Word for reports and presentations. This allows analysis, charts, and written materials to be updated quickly and consistently without manually rebuilding reports each time data changes. This type of workflow is especially useful when preparing research reports, investor presentations, and other materials used for business development and strategic discussions. The overall goal is to create a system where data flows efficiently from analysis to finished materials, making it easier to communicate ideas, opportunities, and market insights.

Preqin Database
I use Preqin as a research and business development tool to identify and research institutional investors, family offices, private credit funds, and real estate investors. The platform is useful for understanding investor focus, allocation strategies, fund activity, and key contacts, which helps support targeted outreach and capital raising efforts. It is also helpful for researching competing funds, understanding how different strategies are positioned in the market, and identifying potential investors and strategic partners. Preqin is used as part of a broader process for investor research, relationship development, and business development planning.
