Import economic and investment data to Google Sheets effortlessly!
应用详情更新日期:2023年3月20日
适用于:
828
概览
Jive Data lets you easily import economic and financial data to Google Sheets.  

Economic data:
Our economic data comes from St. Louis FRED. Short for Federal Reserve Economic Data, FRED is an online database consisting of hundreds of thousands of economic data time series from scores of national, international, public, and private sources. FRED, created and maintained by the Research Department at the Federal Reserve Bank of St. Louis. FRED includes over 800,000 economic series, including:
GDP | Gross Domestic Product
GDPC1 | Real Gross Domestic Product
T10Y2Y               | 10-Year Treasury Constant Maturity Minus 2-Year Treasury Constant Maturity
 MORTGAGE30US         | 30-Year Fixed Rate Mortgage Average in the United States
 WALCL                | Assets: Total Assets: Total Assets (Less Eliminations from Consolidation): Wednesday Level
 CPIAUCSL             | Consumer Price Index for All Urban Consumers: All Items in U.S. City Average
 T10Y3M               | 10-Year Treasury Constant Maturity Minus 3-Month Treasury Constant Maturity
 UNRATE               | Unemployment Rate
 BAMLH0A0HYM2         | ICE BofA US High Yield Index Option-Adjusted Spread
 T10YIE               | 10-Year Breakeven Inflation Rate
 DGS10                | Market Yield on U.S. Treasury Securities at 10-Year Constant Maturity, Quoted on an Investment Basis
 RRPONTSYD            | Overnight Reverse Repurchase Agreements: Treasury Securities Sold by the Federal Reserve in the Temporary Open Market Operations
 T5YIE                | 5-Year Breakeven Inflation Rate
 DFII10               | Market Yield on U.S. Treasury Securities at 10-Year Constant Maturity, Quoted on an Investment Basis, Inflation-Indexed
 CIVPART              | Labor Force Participation Rate
 DFF                  | Federal Funds Effective Rate
 T5YIFR               | 5-Year, 5-Year Forward Inflation Expectation Rate
 SP500                | S&P 500
 BAMLH0A0HYM2EY       | ICE BofA US High Yield Index Effective Yield
 PAYEMS               | All Employees, Total Nonfarm
 CORESTICKM159SFRBATL | Sticky Price Consumer Price Index less Food and Energy
 APU0000708111        | Average Price: Eggs, Grade A, Large (Cost per Dozen) in U.S. City Average
 CUSR0000SETA02       | Consumer Price Index for All Urban Consumers: Used Cars and Trucks in U.S. City Average
 CPILFESL             | Consumer Price Index for All Urban Consumers: All Items Less Food and Energy in U.S. City Average
 SOFR                 | Secured Overnight Financing Rate
 DGS2                 | Market Yield on U.S. Treasury Securities at 2-Year Constant Maturity, Quoted on an Investment Basis
 CPALTT01USM657N      | Consumer Price Index: Total All Items for the United States
 BAMLC0A4CBBB         | ICE BofA BBB US Corporate Index Option-Adjusted Spread
 ICSA                 | Initial Claims
 DFEDTARU             | Federal Funds Target Range - Upper Limit
 DRCCLACBS            | Delinquency Rate on Credit Card Loans, All Commercial Banks
 BAMLC0A0CM           | ICE BofA US Corporate Index Option-Adjusted Spread
 NFCI                 | Chicago Fed National Financial Conditions Index
 PPIACO               | Producer Price Index by Commodity: All Commodities
 INDPRO               | Industrial Production: Total Index
 HOUST                | New Privately-Owned Housing Units Started: Total Units
 DCOILWTICO           | Crude Oil Prices: West Texas Intermediate (WTI) - Cushing, Oklahoma
 BAMLC0A4CBBBEY       | ICE BofA BBB US Corporate Index Effective Yield
 WTREGEN              | Liabilities and Capital: Liabilities: Deposits with F.R. Banks, Other Than Reserve Balances: U.S. Treasury, General Account: Week Average
 DGS1                 | Market Yield on U.S. Treasury Securities at 1-Year Constant Maturity, Quoted on an Investment Basis
 WPU0911              | Producer Price Index by Commodity: Pulp, Paper, and Allied Products: Wood Pulp
 EFFR                 | Effective Federal Funds Rate
 CES0500000003        | Average Hourly Earnings of All Employees, Total Private
 PCU325211325211      | Producer Price Index by Industry: Plastics Material and Resins Manufacturing
 CCLACBW027SBOG       | Consumer Loans: Credit Cards and Other Revolving Plans, All Commercial Banks
 TOTALSA              | Total Vehicle Sales
 DGS5                 | Market Yield on U.S. Treasury Securities at 5-Year Constant Maturity, Quoted on an Investment Basis
 RECPROUSM156N        | Smoothed U.S. Recession Probabilities
 DTWEXBGS             | Nominal Broad U.S. Dollar Index
 DRSFRMACBS           | Delinquency Rate on Single-Family Residential Mortgages, Booked in Domestic Offices, All Commercial Banks
 IORB                 | Interest Rate on Reserve Balances
 DTB3                 | 3-Month Treasury Bill Secondary Market Rate, Discount Basis
 VIXCLS               | CBOE Volatility Index: VIX
 DBAA                 | Moody's Seasoned Baa Corporate Bond Yield
 DGS30                | Market Yield on U.S. Treasury Securities at 30-Year Constant Maturity, Quoted on an Investment Basis
 BAA10Y               | Moody's Seasoned Baa Corporate Bond Yield Relative to Yield on 10-Year Treasury Constant Maturity
 DGS20                | Market Yield on U.S. Treasury Securities at 20-Year Constant Maturity, Quoted on an Investment Basis
 EXHOSLUSM495S        | Existing Home Sales
 T10YFF               | 10-Year Treasury Constant Maturity Minus Federal Funds Rate
 CPIAUCNS             | Consumer Price Index for All Urban Consumers: All Items in U.S. City Average
 SOFR30DAYAVG         | 30-Day Average SOFR
 M2REAL               | Real M2 Money Stock
 CUUR0000SEHA         | Consumer Price Index for All Urban Consumers: Rent of Primary Residence in U.S. City Average
 DAAA                 | Moody's Seasoned Aaa Corporate Bond Yield
 BAMLH0A3HYC          | ICE BofA CCC & Lower US High Yield Index Option-Adjusted Spread
 BAMLH0A3HYCEY        | ICE BofA CCC & Lower US High Yield Index Effective Yield
 DPSACBW027SBOG       | Deposits, All Commercial Banks
 MORTGAGE15US         | 15-Year Fixed Rate Mortgage Average in the United States
 WPU101707            | Producer Price Index by Commodity: Metals and Metal Products: Cold Rolled Steel Sheet and Strip
 MEDCPIM158SFRBCLE    | Median Consumer Price Index
 BAMLH0A1HYBB         | ICE BofA BB US High Yield Index Option-Adjusted Spread
 DJIA                 | Dow Jones Industrial Average
 TREAST               | Assets: Securities Held Outright: U.S. Treasury Securities: All: Wednesday Level
 DCOILBRENTEU         | Crude Oil Prices: Brent - Europe
 SAHMREALTIME         | Real-time Sahm Rule Recession Indicator
 RSXFS                | Advance Retail Sales: Retail Trade
 DGS3MO               | Market Yield on U.S. Treasury Securities at 3-Month Constant Maturity, Quoted on an Investment Basis
 FIXHAI               | Housing Affordability Index (Fixed)
 PRIME                | Bank Prime Loan Rate Changes: Historical Dates of Changes and Rates
 REAINTRATREARAT10Y   | 10-Year Real Interest Rate
 MABMM301USM189S      | M3 for the United States
 WSHOMCB              | Assets: Securities Held Outright: Mortgage-Backed Securities: Wednesday Level
 DFII5                | Market Yield on U.S. Treasury Securities at 5-Year Constant Maturity, Quoted on an Investment Basis, Inflation-Indexed
 PCUOMFGOMFG          | Producer Price Index by Industry: Total Manufacturing Industries
 DEXUSEU              | U.S. Dollars to Euro Spot Exchange Rate
 GASREGW              | US Regular All Formulations Gas Price
 PERMIT               | New Privately-Owned Housing Units Authorized in Permit-Issuing Places: Total Units
 DPRIME               | Bank Prime Loan Rate
 CCSA                 | Continued Claims (Insured Unemployment)
 NASDAQCOM            | NASDAQ Composite Index
 DGS1MO               | Market Yield on U.S. Treasury Securities at 1-Month Constant Maturity, Quoted on an Investment Basis
 WPU10170502          | Producer Price Index by Commodity: Metals and Metal Products: Steel Wire, Stainless Steel
 GDPNOW               | GDPNow
 USACPIALLMINMEI      | Consumer Price Index: All Items for the United States
 MANEMP               | All Employees, Manufacturing
 PNGASEUUSDM          | Global price of Natural gas, EU
 DRTSCILM             | Net Percentage of Domestic Banks Tightening Standards for Commercial and Industrial Loans to Large and Middle-Market Firms
 CLF16OV              | Civilian Labor Force Level
 WRESBAL              | Liabilities and Capital: Other Factors Draining Reserve Balances: Reserve Balances with Federal Reserve Banks: Week Average
 PCU32733273          | Producer Price Index by Industry: Cement and Concrete Product Manufacturing
 UNEMPLOY             | Unemployment Level
 BAMLHE00EHYIEY       | ICE BofA Euro High Yield Index Effective Yield


Cost to Borrow:
Cost to Borrow are the fees and rebates in connection with short selling stock. Data comes from Interactive Brokers (IBKR) and is updated every 15 minutes. The Fee is the amount a short selling client pays and is expressed as a percentage of the share price. If there is no data for a stock for a particular 15-minute period, it means there are no shares to borrow. More information on fees and rebates can be found at Interactive Brokers.

Failures to Deliver:
The Jive Data Add-on for Google Sheets also includes data for Failures to Deliver, provided by the Securities and Exchange Commission (SEC). The values of total fails to deliver shares represent the aggregate net balance of shares that failed to be delivered as of a particular settlement date. If the aggregate net balance of shares that failed to be delivered is less than 10,000 as of a particular settlement date prior to September 16, 2008, then no record will be present in the file for that date even if there are fails in that security. If the aggregate net balance of shares that failed to be delivered is zero as of a particular settlement date on or after September 16, 2008, then no record will be present in the file for that date. Fails to deliver on a given day are a cumulative number of all fails outstanding until that day, plus new fails that occur that day, less fails that settle that day. The figure is not a daily amount of fails, but a combined figure that includes both new fails on the reporting day as well as existing fails. In other words, these numbers reflect aggregate fails as of a specific point in time, and may have little or no relationship to yesterday's aggregate fails. Thus, it is important to note that the age of fails cannot be determined by looking at these numbers. In addition, the underlying source(s) of the fails-to-deliver shares is not necessarily the same as the underlying source(s) of the fails-to-deliver shares reported the day prior or the day after.

Regulation SHO:
The Jive Data Add-on for Google Sheets also includes data for Regulation SHO. As defined in Rule 203(c)(6) of Regulation SHO, a “threshold security” is any equity security of any issuer that is registered under Section 12 of the Exchange Act, or that is required to file reports under Section 15(d) of the Exchange Act (commonly referred to as reporting securities), where, for five consecutive settlement days: There are aggregate fails to deliver at a registered clearing agency of 10,000 shares or more per security; The level of fails is equal to at least one-half of one percent of the issuer’s total shares outstanding; and the security is included on a list published by a self-regulatory organization (SRO). A security ceases to be a threshold security if it does not exceed the specified level of fails for five consecutive settlement days.

Short Interest:
The Jive Data Add-on for Google Sheets also includes Short Interest data published by the Financial Industry Regulatory Authority (FINRA). Short Interest is a snapshot of the total open short positions existing on the books and records of brokerage firms for all equity securities on a given settlement date. Short interest data is collected for all stocks—both those that are listed and traded on an exchange and those that are traded over-the-counter (OTC). FINRA and U.S. exchange rules require that brokerage firms report short interest data to FINRA on a per-security basis for all customer and proprietary firm accounts twice a month, around the middle of the month and again at the end of each month. FINRA publishes the short interest reports it collects from member firms for all exchange-listed and over-the-counter equity securities.

Yahoo Finance:
Finally, an easy way to import data from Yahoo Finance into Google Sheets. Items include:
Address, City, State, Zip code, Country, Phone, Website, Industry, Sector, Business summary, Full-time Employees, Company Officers, Audit risk, Board risk, Compensation risk, Shareholder rights risk, Overall risk, Governance epoch date, Compensation epoch date, Recommendation Trend, Cash Flow Statement, Symbol, Trailing P/E, PEG (5 yr expected), Estimates, Enterprise Value, Forward P/E, Profit Margin, Category, YTD Return, 3 Year Beta, Total Assets, Yield, Fund Family, Fund Inception Date, Legal Type, 3-Year Average Return, 5-Year Average Return, Float, Shares Outstanding, Shares Short, Shares Short (prior Month), Prior Month Shares Short Date, Shares Short Date, Short % of Shares Outstanding, % Held by Insiders, % Held by Institutions, Short Ratio, Short % of Float, Beta (5Y Monthly), Implied Shares Outstanding, Book Value, Price/Book (mrq), Fiscal Year Ends, Next Fiscal Year End, Most Recent Quarter (mrq), Quarterly Earnings Growth (yoy), Quarterly Revenue Growth (yoy), Net Income available to Common Shareholders, Diluted EPS (ttm), Forward EPS, PEG Ratio, Last Split Factor, Last Split Date, Enterprise Value / Revenue, Enterprise Value / EBITDA, 52-Week Change, S&P500 52-Week Change, Last Dividend, Last Dividend Date, Exchange, Quote Type, Underlying symbol, Short name, Long name, First Trade Date, Time Zone FullName, Time Zone, Message Board ID, Income Statement, Top Mutual Fund Holders, Price Hint, Previous Close, Open, Low, High, Dividend, Dividend Yield, Ex-Dividend Date, Payout Ratio, 5 Year Average Dividend Yield, PE Ratio (TTM), Volume, Regular Market Volume, Avg. Volume, Avg. Volume (10-day), Avg. Daily Volume (10-day), Bid, Ask, Bid Size, askSize, Market Cap, 52 week Low, 52 Week High, Price/Sales (ttm), 50-Day Moving Average, 200-Day Moving Average, Trailing Annual Dividend Rate, Trailing Annual Dividend Yield, Currency, Insiders, Earnings, Next Dividend Date, Analyst Upgrades & Downgrades, Pre Market Source, Change Percent, Change, Time, Price hint, Price, Avg.Daily Volume (3-month), Source, Exchange Name, Delay, Name, Quote Source, Currency Symbol, Annual Balance Sheet, SEC Filings, Top Institutional Holders, % of Shares Held by All Insiders, % of Shares Held by Institutions, % of Float Held by Institutions, Number of Institutions Holding Shares, Quarterly Balance Sheet, Earnings History, Total ESG Risk score, Controversy Level, Number of Buy Transactions, Shares, Number of shares (%), Number of Sale Transactions, Total Number of Transactions, Net Shares Purchased (Sold), % Net Shares Purchased (Sold), Total Insider Shares Held, Insider Transactions, Quarterly Income Statement, Quarterly Cash Flow Statement, Short-Term Trend, Mid-Term Trend, Long-Term Trend, Current Price, Highest Analyst Price Target, Lowest Analyst Price Target, Average Analyst Price Target, Median Analyst Price Target, Average Recommendation Rating, Recommendation Key, No. of Analysts, Cash, Cash per Share, EBITDA, Total Debt, Quick Ratio, Current Ratio, Revenue, Debt to Equity, Revenue per Share, Return on Assets, Return on Equity, Gross Profit, Free Cash Flow, Operating Cash Flow, Earnings Growth, Revenue Growth, Gross Margin, EBITDA Margin, Operating Margin
其他信息
定价免费
开发者
非交易者
Jive Data”将请求获得以下权限。了解详情
Jive Data”将需要访问您的 Google 账号
这样可让Jive Data
查看和管理其中已安装此应用的电子表格
在 Google 应用的提示和边栏中显示和运行第三方网页内容
连接到外部服务
查看您的 Google 账号的主电子邮件地址
查看您的个人信息,包括您已公开的任何个人信息
评价
语言:
排序依据:
Google 不会核实评价或评分。 详细了解评价
没有评论
搜索
清除搜索内容
关闭搜索框
Google 应用
主菜单