ESBD_File_255490_Other Feeds and Transmissions - TRS Custodian Data Feeds.xlsx

XLSX spreadsheet 21 KB Posted

Attached to
Master Custodian and Securities Lending Services
Solicitation number
CC-2200001
Issued by
Texas

About this file

The file is an Excel spreadsheet detailing data feed delivery specifications for a custodian Request for Proposal (RFP), primarily involving Texas Retirement System (TRS) and multiple financial data providers. The document comprehensively outlines a complex series of daily, weekly, monthly, and quarterly data feed requirements across various financial reporting categories, including benchmark returns, custody trades, performance metrics, cash flows, holdings, compliance tests, and investment performance data. Feeds are to be delivered through SFTP protocols in CSV or ZIP formats from providers like TRS, FactSet, Blackrock, EzeSoft, and others, with most feeds occurring on weekdays at specific times such as start of day, midday, or close of business.

The data feeds cover an extensive range of financial reporting needs, including security lending, asset allocation, fund performance, exchange rates, collateral details, risk reports, and transaction summaries. Delivery periods vary from daily updates to quarterly reports, with some feeds maintaining historical data up to 18 months. Many feeds include options to exclude holidays and have specific processing timelines, such as being available 30-60 days after the reporting period. The document suggests a comprehensive financial data management system with multiple touch points for tracking investments, compliance, performance, and operational metrics across various investment categories including public funds, private equity, real estate, and hedge funds.

View the file

Other files

Show all 17

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Sheet1

FOR DISTRIBUTION TO CUSTODIAN RFP
Data FeedDeliveryPeriodExclude holiday?FormatTarget
Aggregate compositionDaily, start of dayAll timeFlat file (CSV)TRS SFTP
Benchmark returns (final)Weekdays, midday45 DayYesFlat file (CSV)TRS SFTP
Benchmark returns (preliminary)Weekdays, start of day45 DayYesFlat file (CSV)TRS SFTP
Borrow summaryWeekdays, close of businessDayYesFlat file (CSV)TRS SFTP
Borrowing fee rebateWeekdays, close of businessDayYesFlat file (CSV)TRS SFTP
Borrowing SFP availabilityWeekdays, middayDayFlat file (CSV)TRS SFTP
Breakout and aggregate net and invested performance (final)Weekdays, midday60 DayYesFlat file (CSV)TRS SFTP
Breakout and aggregate net and invested performance (preliminary)Weekdays, start of day60 DayFlat file (CSV)TRS SFTP
Cash summary and short term investment balancesWeekdays, close of businessDayYesFlat file (CSV)TRS SFTP
Collateral agreement detailsWeekdays, middayDayFlat file (CSV)TRS SFTP
Collateral callsWeekdays, middayDayFlat file (CSV)TRS SFTP
Collateral positionsWeekdays, middayDayFlat file (CSV)TRS SFTP
Compiled documents list (PE, RE, HF)Weekly, start of FridayWeekFlat file (CSV)TRS SFTP
Compiled Hedge Fund documentsWeekly, start of FridayWeekZIP (PDF, etc)TRS SFTP
Compiled Private Equity documentsWeekly, start of FridayWeekZIP (PDF, etc)TRS SFTP
Compiled Real Estate documentsWeekly, start of FridayWeekZIP (PDF, etc)TRS SFTP
Compliance test account asset groupingMonthly, close of 1st business dayMonthFlat file (CSV)TRS SFTP
Compliance test account invested to totalMonthly, close of 1st business dayMonthFlat file (CSV)TRS SFTP
Compliance test account notional reallocationMonthly, close of 1st business dayMonthFlat file (CSV)TRS SFTP
Compliance test account repo reallocationMonthly, close of 1st business dayMonthFlat file (CSV)TRS SFTP
Corporate Action event detailsWeekdays, start of dayDayFlat file (CSV)TRS SFTP
Counterparty compliance testWeekdays, close of businessDayFlat file (CSV)TRS SFTP
Currency-counterparty overlay compliance testWeekdays, middayDayFlat file (CSV)TRS SFTP
Custody Cash SettlementsWeekdays, start of dayDayFlat file (CSV)TRS SFTP
Custody Failed TradesWeekdays, start of dayDayFlat file (CSV)TRS SFTP
Custody Matches TradesWeekdays, start of dayDayFlat file (CSV)TRS SFTP
Custody positionsWeekdays, overnightDayFlat file (CSV)TRS SFTP
Custody positionsWeekdays, close of businessDayFlat file (CSV)ISS Proxy SFTP
Custody Settled TradesWeekdays, start of dayDayFlat file (CSV)TRS SFTP
Custody Unmated TradesWeekdays, start of dayDayFlat file (CSV)TRS SFTP
Daily Summary Level Holdings (ST and FX at lot)Daily (except Sunday), overnightDayYesFlat file (CSV)FactSet SFTP
External manager fee accrual and paymentsMonthly, close of 8th business dayMonthFlat file (CSV)TRS SFTP
Fee transparency for private market managersQuarterly, ~4-month after quarter endQuarterYesFlat file (CSV)TRS SFTP
Fund headerWeekdays, overnightDayYesFlat file (CSV)TRS SFTP
Fund net, invested, & security performance (preliminary)Weekdays, start of day30 DayFlat file (CSV)TRS SFTP
Fund net, invested, and security performance (final)Weekdays, midday30 DayYesFlat file (CSV)TRS SFTP
Fund, breakout, and aggregate performance (total, net, net manager, invested level, etc)Monthly, close of 13th business day6 MonthFlat file (CSV)TRS SFTP
Fund, breakout, and aggregate performance (total, net, net manager, invested level, etc)Weekdays, start of day6 MonthFlat file (CSV)TRS SFTP
Fund, breakout, and aggregate total performance (final)Weekdays, midday45 DayYesFlat file (CSV)TRS SFTP
Fund, breakout, and aggregate total performance (preliminary)Weekdays, start of day45 DayYesFlat file (CSV)TRS SFTP
FX exchange ratesWeekdays, overnightDayYesFlat file (CSV)TRS SFTP
FX exchange ratesWeekdays, middayDayFlat file (CSV)EzeSoft SFTP
FX exchange ratesWeekdays, middayDayFlat file (CSV)TRS SFTP
General ledgerMonthly, morning of 8th business dayMonthFlat file (CSV)TRS Fiscal Accounting
General ledger balancesWeekdays, overnightDayYesFlat file (CSV)TRS SFTP
Gross and net leverage balancesMonthly, 3 weeks after month endAll timeYesFlat file (CSV)TRS SFTP
Incoming wire transfersWeekdays, close of businessDayYesFlat file (CSV)TRS SFTP
Interest yieldsWeekly, midday MondayWeekFlat file (CSV)TRS SFTP
IPMA report on Performance testing (error and volatility)Monthly, close of 10th business dayMonthFlat file (CSV)TRS SFTP
IPMA report on Performance testing (error and volatility)Weekdays, close of businessDayYesFlat file (CSV)TRS SFTP
Lendable shares and positions on loansWeekdays, start of dayDayYesFlat file (CSV)TRS SFTP
Leverage compliance testing: asset allocationMonthly, close of 10th business dayMonthFlat file (CSV)TRS SFTP
Leverage compliance testing: counter party exposuresWeekdays, middayDayFlat file (CSV)TRS SFTP
Leverage compliance testing: developed/emerging marketsWeekdays, middayDayFlat file (CSV)TRS SFTP
Loan balance by securityWeekdays, middayDayYesFlat file (CSV)TRS SFTP
Lot level holdings for SwapsWeekdays, overnightDayYesFlat file (CSV)TRS SFTP
Net cash collateral detailWeekdays, middayDayYesFlat file (CSV)TRS SFTP
Open payables and receivablesMonthly, morning of 8th business dayMonthFlat file (CSV)TRS SFTP
Open payables and receivablesWeekdays, overnightDayYesFlat file (CSV)TRS SFTP
Options trade activity reportQuaterly, close of 10th business dayQuarterFlat file (CSV)TRS SFTP
Outgoing wire transfersWeekdays, close of businessDayYesFlat file (CSV)TRS SFTP
Pledged collateralWeekdays, close of businessDayYesFlat file (CSV)TRS SFTP
Postions report with collateral pool characteristics (index, sector, maturity date, WAM, yield, etc)Weekdays, start of dayDayYesFlat file (CSV)TRS SFTP
Private Equity and ENRI Cash FlowsMonthly, close of 5th business dayMonthFlat file (CSV)TRS SFTP
Private Equity index quarterly reportsQuarterly, ~4-month after quarter endQuarterFlat file (CSV)TRS SFTP
Public aggregate level returns & market valuesMonthly, close of 10th business day12 monthYesFlat file (CSV)FactSet SFTP
Public fund level returns & market valuesMonthly, close of 10th business day12 monthYesFlat file (CSV)FactSet SFTP
Real Asset Cash FlowsMonthly, close of 5th business dayMonthFlat file (CSV)TRS SFTP
Restricted securities listWeekdays, middayDayYesFlat file (CSV)TRS SFTP
Risk parity and SPN asset allocation compliance supplementalWeekdays, middayDayFlat file (CSV)TRS SFTP
Risk parity and SPN asset allocation compliance testWeekdays, middayDayFlat file (CSV)TRS SFTP
Risk reportsWeekday, start of day (2 day lag)DayFlat file (CSV)TRS SFTP
Rolling 18-month benchmark returns (1 month, 1 year, 3 year, 5 year, 10 year & 15 year)Weekdays, midday18 monthsYesFlat file (CSV)TRS SFTP
Sec Lending borrower credit limitsMonthly, 3 weeks after month endMonthYesFlat file (CSV)TRS SFTP
Sec Lending holdingsWeekly, close of 1st business dayWeekYesFlat file (CSV)TRS SFTP
Sec Lending performanceMonthly, 3 weeks after month endMonthYesFlat file (CSV)TRS SFTP
Sec Lending security level holdingsWeekdays, middayDayYesFlat file (CSV)TRS SFTP
Security masterWeekdays, overnightDayYesFlat file (CSV)TRS SFTP
Special Opportunities Cash FlowsMonthly, close of 5th business dayMonthFlat file (CSV)TRS SFTP
SPN account NAVWeekdays, overnightDayYesFlat file (CSV)Blackrock
SPN accounts holdingsWeekdays, overnightDayYesFlat file (CSV)Blackrock
SPN acount securitiesWeekdays, overnightDayYesFlat file (CSV)Blackrock
SPN leverage compliance testWeekdays, middayDayFlat file (CSV)TRS SFTP
SPN open FX and tradesWeekdays, overnightDayYesFlat file (CSV)Blackrock
Summary level HoldingsMonthly, morning of 8th business dayMonthFlat file (CSV)TRS SFTP
Summary level HoldingsWeekdays, overnightDayYesFlat file (CSV)TRS SFTP
Swap commission and feesQuaterly, close of 10th business dayQuarterFlat file (CSV)TRS SFTP
Swap trade activity reportQuaterly, close of 10th business dayQuarterFlat file (CSV)TRS SFTP
Total plan asset allocation reportMonthly, close of 10th business dayMonthFlat file (CSV)TRS SFTP
TransactionsWeekdays, overnightDayYesFlat file (CSV)TRS SFTP
TransactionsWeekdays, overnightDayYesFlat file (CSV)Blackrock
Transparency report on Real Estate feesQuarterly, ~4-month after quarter end5 QuartersYesFlat file (CSV)TRS SFTP
Underlying positions for Commingled HoldingsWeekdays, start of dayDayYesFlat file (CSV)IFS (IMSI) SFTP
Underlying positions for Commingled HoldingsWeekdays, start of dayDayYesFlat file (CSV)FactSet SFTP
Underlying positions for Commingled HoldingsWeekdays, start of dayDayYesFlat file (CSV)TRS SFTP
Upcoming cash flowsWeekdays, close of businessAll timeYesFlat file (CSV)TRS SFTP

File details come from the government source that posted it. Updated .