我试图通过以下方法获得代码AAPL的收益表的ttm值
from yahoo_fin import stock_info as si
import yfinance as yf
import pandas as pd
import matplotlib.pyplot as plt
import pandas_datareader
pd.set_option('display.max_columns', None)
income_statement = si.get_income_statement("aapl")
income_statement
但是结果没有
我正在为小型金融网络应用程序工作,我需要生成一个所有用户的月度一般报告,其中显示了每个用户在一个月内所有的交易总数。表结构如下。
username amount date
-----------------------------
a 1000 2018-8-1
b 2000 2018-8-1
c 1500 2018-8-3
b 1700 2018-8-6
b 1100 2018-8-7
a 2000 2018-8-10
c
我想创建一个宏,以获取实时股票报价从一个金融网站。下面是我的密码。
Private Sub Worksheet_Change(ByVal Target As Range)
Dim stock As Long, rng As Range, quote As String, ie As InternetExplorer, doc As HTMLDocument
Set rng = Range("A1")
stock = rng.Value
Set ie = CreateObject("InternetExplorer.Application")
If Targ