Main Content

Retrieve Current Financial Data Using Datafeed Toolbox

This example uses:

Open Script

This example shows how to connect to Federal Reserve Economic Data (FRED) and retrieve current financial data.

Connect to FRED

Connect to the FRED data server at https://research.stlouisfed.org/fred2/ using the fred function.

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

Retrieve Current Financial Data

Retrieve current financial data for the S&P 500 series using the fetch function.

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]

Display the numeric representation of the date and the foreign exchange rate.

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

Close the FRED Connection

close(c);

Send Data to ThingSpeak™

Send the last price data to a ThingSpeak channel using the thingSpeakWrite function. Change the channelID and the writeAPIKey to send data to your channel.

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

See Also

Functions

External Websites