You need to enable JavaScript to run this app

1

Click the "Customize" menu button in the top-right corner of the Chrome window

2

Select the Settings menu item

3

At the bottom, click Advanced

4

Under Privacy and security, click Site settings

5

Click JavaScript

6

Turn on Allowed (recommended)

1

Click the Safari menu

2

Click the Preference menu item

3

Click on the Security tab

4

Click the Enable Javascript checkbox

5

Close the Preferences window. JavaScript is now enabled

1

Open the "Easy Setup" menu In the top right corner of the Opera window

2

At the very bottom, click Go to browser settings

3

Search for Javascript

4

Click Site settings

5

Click JavaScript

6

Choose your JavaScript settings

1

Click into the Address Bar, type in about:config and press enter

2

Accept the warning about changing advanced settings

3

Type javascript into the search field

4

Find the javascript:enabled preference

5

Reset the JavaScript preference to default (enabled)

1

Select the Tools menu

2

Select Internet Options

3

Select the Security tab

4

Click the Custom level... button

5

Scroll down to the sub-section Active scripting under Scripting section, click Enable

6

Confirm the change

Examples and tutorials

Historical data

Request a large number of symbols

Programmatic batch downloads

Best bid, best offer, and midprice

Custom OHLCV bars from trades

Join schemas on instrument ID

Plot a candlestick chart

Calculate VWAP and RSI

End-of-day pricing and portfolio valuation

Benchmark portfolio performance

Market halts, volatility interrupts, and price bands

Resample OHLCV from 1-minute to 5-minute

Instrument definitions

Algorithmic trading

Corporate actions

Adjustment factors

Security master

Schemas and data formats

Standards and conventions

Venues and datasets

End-of-day pricing and portfolio valuation

Overview

This example shows how to use the Historical client to calculate the end-of-day (EOD) value of a hypothetical portfolio. To do this we will request the closing price for each symbol on a given date and use this price to determine the value of our portfolio.

OHLCV-1d schema

We'll demonstrate this example using the OHLCV-1d schema. The OHLCV family of schemas contain the opening, high, low and closing prices as well as the aggregated volume of trades within a time interval. Since we are interested in end-of-day evaluation, we'll use an interval of one day, which is specified by the suffix -1d.

Many users will prefer to use the official daily settlement prices found in the statistics schema for this purpose.

Example

PythonC++Rust

      
    
import databento as db

# A hypothetical portfolio mapping symbols to a quantity of shares
portfolio = {
    "AAPL": 200,
    "AMZN": 200,
    "GOOG": 100,
    "META": 100,
    "NFLX": 114,
}

# Create a historical client
client = db.Historical("YOUR_API_KEY")

# Request OHLCV-1d data
data = client.timeseries.get_range(
    dataset="XNAS.ITCH",
    start="2022-09-19",
    symbols=list(portfolio.keys()),
    stype_in="raw_symbol",
    schema="ohlcv-1d",
)

# Convert to DataFrame
eod_data = data.to_df()
eod_data = eod_data.set_index("symbol")

# Sum the products of the close prices and portfolio quantities
eod_evaluation = sum(
    eod_data.at[symbol, "close"] * quantity for symbol, quantity in portfolio.items()
)
print(f"${eod_evaluation:,.2f}")

Result

PythonC++Rust

$109,235.90