Book Image

The Future of Finance with ChatGPT and Power BI

By : James Bryant, Aloke Mukherjee
2.5 (4)
Book Image

The Future of Finance with ChatGPT and Power BI

2.5 (4)
By: James Bryant, Aloke Mukherjee

Overview of this book

In today's rapidly evolving economic landscape, the combination of finance, analytics, and artificial intelligence (AI) heralds a new era of decision-making. Finance and data analytics along with AI can no longer be seen as separate disciplines and professionals have to be comfortable in both in order to be successful. This book combines finance concepts, visualizations through Power BI and the application of AI and ChatGPT to provide a more holistic perspective. After a brief introduction to finance and Power BI, you will begin with Tesla's data-driven financial tactics before moving to John Deere's AgTech strides, all through the lens of AI. Salesforce's adaptation to the AI revolution offers profound insights, while Moderna's navigation through the biotech frontier during the pandemic showcases the agility of AI-focused companies. Learn from Silicon Valley Bank's demise, and prepare for CrowdStrike's defensive maneuvers against cyber threats. With each chapter, you'll gain mastery over new investing ideas, Power BI tools, and integrate ChatGPT into your workflows. This book is an indispensable ally for anyone looking to thrive in the financial sector. By the end of this book, you'll be able to transform your approach to investing and trading by blending AI-driven analysis, data visualization, and real-world applications.
Table of Contents (13 chapters)
Free Chapter
1
Part 1: From Financial Fundamentals to Frontier Tech: Navigating the New Paradigms of Data, EVs, and AgTech
6
Part 2: Pioneers and Protectors: AI Transformations in Software, Finance, Biotech, and Cybersecurity

Implementing the Regional Bank ETF trade – a commercial real estate strategy

Let’s break down the trading strategy with specific steps, required information, and Python code examples for our non-technical readers. We will use the CRE vacancy rate and sentiment analysis, using the OpenAI GPT API, to capture volatility in the regional bank ETF. For simplicity, we will use the yfinance library to fetch historical ETF data and assume access to the OpenAI GPT API.

  1. Data collection:
    • Historical ETF data:
      • Required information: Historical price and volume data for the regional bank ETF and IAT
      • Here’s a Python code example:
      pip install yfinance
      import yfinance as yf
      # Define the ETF symbol
      etf_symbol = "IAT"
      # Fetch historical data from Yahoo Finance
      etf_data = yf.download(etf_symbol, start="2022-06-30", end="2023-06-30")
      # Save ETF data to a CSV file
      etf_data.to_csv("IAT_historical_data.csv")
    • For the CRE vacancy rate data, we will...