Main Content

本页采用了机器翻译。点击此处可查看英文原文。

使用 Datafeed Toolbox 检索当前财务数据

此示例使用:

打开脚本

此示例演示如何连接到美联储经济数据 (FRED) 并检索当前财务数据。

连接到 FRED

使用 fred 函数连接到 https://research.stlouisfed.org/fred2/ 上的 FRED 数据服务器。

c = fred('https://research.stlouisfed.org/fred2/');

检索当前财务数据

检索 S 的当前财务数据&P 500 系列使用 fetch 功能。

series = 'SP500';
d = fetch(c,series)

d = 

  struct with fields:

                 Title: ' S&P 500'
              SeriesID: ' SP500'
                Source: ' S&P Dow Jones Indices LLC'
               Release: ' Standard & Poors (Not a Press Release)'
    SeasonalAdjustment: ' Not Seasonally Adjusted'
             Frequency: ' Daily'
                 Units: ' Index'
             DateRange: ' 2009-01-12 to 2019-01-09'
           LastUpdated: ' 2019-01-09 7:10 PM CST'
                 Notes: ' The Federal Reserve Bank of St. Louis and S&P Dow Jones Indices LLC have reached a new agreement on the use of Standard & Poors and Dow Jones Averages series in FRED. FRED and its associated services will include 10 years of daily history for Standard & Poors and Dow Jones Averages series.  The S&P 500 is regarded as a gauge of the large cap U.S. equities market. The index includes 500 leading companies in leading industries of the U.S. economy, which are publicly held on either the NYSE or NASDAQ, and covers 75% of U.S. equities. Since this is a price index and not a total return index, the S&P 500 index here does not contain dividends.  Copyright © 2016, S&P Dow Jones Indices LLC. All rights reserved. Reproduction of S&P 500 in any form is prohibited except with the prior written permission of S&P Dow Jones Indices LLC (“S&P”). S&P does not guarantee the accuracy, adequacy, completeness or availability of any information and is not responsible for any errors or omissions, regardless of the cause or for the results obtained from the use of such information. S&P DISCLAIMS ANY AND ALL EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, ANY WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE OR USE. In no event shall S&P be liable for any direct, indirect, special or consequential damages, costs, expenses, legal fees, or losses (including lost income or lost profit and opportunity costs) in connection with subscriber’s or others’ use of S&P 500.  Permission to reproduce S&P 500 can be requested from index_services@spdji.com. More contact details are available from https://us.spindices.com/contact-us/ including phone numbers for all of its regional offices.'
                  Data: [2608×2 double]

显示日期和外汇汇率的数字表示形式。

d.Data(1:5,1:2)

ans =

   1.0e+05 *

    7.3379    0.0087
    7.3379    0.0087
    7.3379    0.0084
    7.3379    0.0084
    7.3379    0.0085

关闭 FRED 连接

close(c);

将数据发送至 ThingSpeak™

使用 thingSpeakWrite 函数将最后的价格数据发送到 ThingSpeak通道。更改 channelID 和 writeAPIKey 以将数据发送到您的通道。

channelID=17504;
writeAPIKey='23ZLGOBBU9TWHG2H';
thingSpeakWrite(channelID,d.Data(end, 2),'WriteKey',writeAPIKey);

另请参阅

函数

外部网站