Data Sets#
- morningstar_data.direct.user_items.get_data_set_details(
- data_set_id: str,
Returns all of the data points for a given saved data set.
- Parameters:
data_set_id (
str
) – The unique identifier of a Morningstar data set or user created data set saved in Morningstar Direct. The id string is numeric. For example: “6102286”.- Returns:
A DataFrame object with data set data points data. The DataFrame columns include:
datapointId
alias
type
universe
datapointName
isTsdp
isFilterable
isEpdp
isClientCustom
isCustomCalc
isPortfolioCalc
mstarIpType
displayName
decimalPlaces
preEuroConversion
sourceId
calculationId
windowType
requireContinueData
scalValue
scalPercentValue
align
width
cellType
sortLocal
displayType
percentileRank
hide
custom
scale
reverseSign
currency
displayOptions
frequency
startDate
endDate
floatStart
floatEnd
startDelay
endDelay
diffStart
diffEnd
compounding
annualized
annualDays
benchmark
riskfree
fit
scalType
timehorizon
generalFrequency
calcCurType
calcSdType
calcUse5Days
calcS1
calcS2
calcBestReturnNum
calcWorstReturnNum
calcRollingTimePeriod
calcReinvestDateType
calcReinvestSource
calcAdditionalSource
calcIsApplyIsraelsenModification
- Return type:
DataFrame
- Raises:
BadRequestException – The exception is raised when a invalid value is passed to parameter data_set_id.
Examples
Get data points in the data set with data set id “0218-0450”.
import morningstar_data as md df = md.direct.user_items.get_data_set_details(data_set_id="0218-0450") df
- Output:
datapointId
alias
type
universe
datapointName
…
calcIsApplyIsraelsenModification
OS01W
Z0
text
Name
…
NaN
…
- morningstar_data.direct.user_items.get_data_sets() DataFrame #
Returns all data sets saved by or shared to a user in Morningstar Direct.
- Returns:
A DataFrame object with all user data sets data. The DataFrame columns include:
datasetId
name
source
shared
- Return type:
DataFrame
- Examples:
import morningstar_data as md df = md.direct.user_items.get_data_sets() df
- Output:
datasetId
name
source
shared
5447361
alpha
DESKTOP
False
5386429
Michael’s Search Ds
DESKTOP
False
…
- morningstar_data.direct.get_morningstar_data_sets(
- universe: str | None = None,
Returns all Morningstar predefined data sets.
- Parameters:
universe (
str
, optional) – The Morningstar code for an investment universe.- Returns:
A DataFrame object with Morningstar data sets data. The DataFrame columns include:
id
name
- Return type:
DataFrame
Examples
Retrieve the Morningstar data set for the open-end fund universe.
import morningstar_data as md df = md.direct.lookup.get_morningstar_data_sets(universe="FO") df
- Output:
id
name
0026-0020
Snapshot
0026-0447
Sustainability: ESG Risk (Fund)
…