menu
Data

Data Coordinates

DataCoordinate is an object which uses a coordinate system for creating a reference to a data series. The object is immutable and hashable, so they can be applied in caching, streaming, and other applications where mapping the coordinates may be important. DataCoordinates can also be utilized to fetch the series defined by the coordinate.

DataCoordinate Class

Below is an example of fetching implied volatility for AAPL UW using the Marquee assetId.

info

Note

Examples require an initialized GsSession and relevant identifier licenses. Please refer to Sessions for details.

import datetime as dt

from gs_quant.data import DataDimension, DataCoordinate, DataMeasure, DataFrequency

dimensions = {
    'assetId': 'MA4B66MW5E27U9VBB94',  # AAPL UW
    DataDimension.TENOR: '1m',
    DataDimension.STRIKE_REFERENCE: 'spot',
    DataDimension.RELATIVE_STRIKE: .8
}

coordinate = DataCoordinate(measure=DataMeasure.IMPLIED_VOLATILITY,
                            dataset_id='EDRVOL_PERCENT_STOCK_STANDARD',
                            dimensions=dimensions)

coordinate.get_series(start=dt.date(2020, 1, 2), end=dt.date(2020, 1, 8))

Output:

2020-01-02    0.399873
2020-01-03    0.402368
2020-01-06    0.394695
2020-01-07    0.392863
2020-01-08    0.372748
dtype: float64

Get a DataCoordinate from an Entity

Using an Entity object, such as an Asset object, you can get a DataCoordinate using the get_data_coordinate method. With this DataCoordinate, a series can be fetched without explicitly specifying the dataset ID. You can get the mapped dataset via the dataset_id property on the resolved coordinate.

import datetime as dt

from gs_quant.data import DataDimension, DataCoordinate, DataMeasure, DataFrequency
from gs_quant.markets.securities import SecurityMaster, AssetIdentifier

dimensions = {
    DataDimension.TENOR: '1m',
    DataDimension.STRIKE_REFERENCE: 'spot',
    DataDimension.RELATIVE_STRIKE: .8
}

spx = SecurityMaster.get_asset('SPX', AssetIdentifier.BLOOMBERG_ID)
coordinate: DataCoordinate = spx.get_data_coordinate(measure=DataMeasure.IMPLIED_VOLATILITY,
                                                     dimensions=dimensions,
                                                     frequency=DataFrequency.DAILY)

print(f'Dataset ID: {coordinate.dataset_id}')

coordinate.get_series(start=dt.date(2020, 1, 1), end=dt.date(2020, 1, 8))

Output:

Dataset ID: EDRVOL_PERCENT_V1_STANDARD

2020-01-02    0.300644
2020-01-03    0.315498
2020-01-06    0.311003
2020-01-07    0.306926
2020-01-08    0.308256
dtype: float64

Comparable and Hashable

DataCoordinates are comparable and hashable objects which allow them to be conveniently compared for equality and mapped for caching and streaming purposes.

dimensions_a = {
    DataDimension.TENOR: '1m',
    DataDimension.STRIKE_REFERENCE: 'spot',
    DataDimension.RELATIVE_STRIKE: .8
}

# Same dimensions but different order
dimensions_b = {
    DataDimension.RELATIVE_STRIKE: .8,
    DataDimension.STRIKE_REFERENCE: 'spot',
    DataDimension.TENOR: '1m'
}

coord_a = DataCoordinate('EDRVOL_PERCENT_STOCK_STANDARD',
                         DataMeasure.IMPLIED_VOLATILITY,
                         dimensions_a)

coord_b = DataCoordinate('EDRVOL_PERCENT_STOCK_STANDARD',
                         DataMeasure.IMPLIED_VOLATILITY,
                         dimensions_b)

assert coord_a == coord_b # True
assert hash(coord_a) == hash(coord_b) # True

Related Content


Certain solutions and Institutional Services described herein are provided via our Marquee platform. The Marquee platform is for institutional and professional clients only. This site is for informational purposes only and does not constitute an offer to provide the Marquee platform services described, nor an offer to sell, or the solicitation of an offer to buy, any security. Some of the services and products described herein may not be available in certain jurisdictions or to certain types of clients. Please contact your Goldman Sachs sales representative with any questions. Any data or market information presented on the site is solely for illustrative purposes. There is no representation that any transaction can or could have been effected on such terms or at such prices. Please see https://www.goldmansachs.com/disclaimer/sec-div-disclaimers-for-electronic-comms.html for additional information.
Transaction Banking services are offered by Goldman Sachs Bank USA (“GS Bank”). GS Bank is a New York State chartered bank, a member of the Federal Reserve System and a Member FDIC.
GS DAP™ is owned and operated by Goldman Sachs. This site is for informational purposes only and does not constitute an offer to provide, or the solicitation of an offer to provide access to or use of GS DAP™. Any subsequent commitment by Goldman Sachs to provide access to and / or use of GS DAP™ would be subject to various conditions, including, amongst others, (i) satisfactory determination and legal review of the structure of any potential product or activity, (ii) receipt of all internal and external approvals (including potentially regulatory approvals); (iii) execution of any relevant documentation in a form satisfactory to Goldman Sachs; and (iv) completion of any relevant system / technology / platform build or adaptation required or desired to support the structure of any potential product or activity.
Mosaic is a service mark of Goldman Sachs & Co. LLC. This service is made available in the United States by Goldman Sachs & Co. LLC and outside of the United States by Goldman Sachs International, or its local affiliates in accordance with applicable law and regulations. Goldman Sachs International and Goldman Sachs & Co. LLC are the distributors of the Goldman Sachs Funds. Depending upon the jurisdiction in which you are located, transactions in non-Goldman Sachs money market funds are affected by either Goldman Sachs & Co. LLC, a member of FINRA, SIPC and NYSE, or Goldman Sachs International. For additional information contact your Goldman Sachs representative. Goldman Sachs & Co. LLC, Goldman Sachs International, Goldman Sachs Liquidity Solutions, Goldman Sachs Asset Management, L.P., and the Goldman Sachs funds available through Goldman Sachs Liquidity Solutions and other affiliated entities, are under the common control of the Goldman Sachs Group, Inc.
© 2024 Goldman Sachs. All rights reserved.