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 Feed | Delivery | Period | Exclude holiday? | Format | Target |
| Aggregate composition | Daily, start of day | All time | Flat file (CSV) | TRS SFTP | |
| Benchmark returns (final) | Weekdays, midday | 45 Day | Yes | Flat file (CSV) | TRS SFTP |
| Benchmark returns (preliminary) | Weekdays, start of day | 45 Day | Yes | Flat file (CSV) | TRS SFTP |
| Borrow summary | Weekdays, close of business | Day | Yes | Flat file (CSV) | TRS SFTP |
| Borrowing fee rebate | Weekdays, close of business | Day | Yes | Flat file (CSV) | TRS SFTP |
| Borrowing SFP availability | Weekdays, midday | Day | Flat file (CSV) | TRS SFTP | |
| Breakout and aggregate net and invested performance (final) | Weekdays, midday | 60 Day | Yes | Flat file (CSV) | TRS SFTP |
| Breakout and aggregate net and invested performance (preliminary) | Weekdays, start of day | 60 Day | Flat file (CSV) | TRS SFTP | |
| Cash summary and short term investment balances | Weekdays, close of business | Day | Yes | Flat file (CSV) | TRS SFTP |
| Collateral agreement details | Weekdays, midday | Day | Flat file (CSV) | TRS SFTP | |
| Collateral calls | Weekdays, midday | Day | Flat file (CSV) | TRS SFTP | |
| Collateral positions | Weekdays, midday | Day | Flat file (CSV) | TRS SFTP | |
| Compiled documents list (PE, RE, HF) | Weekly, start of Friday | Week | Flat file (CSV) | TRS SFTP | |
| Compiled Hedge Fund documents | Weekly, start of Friday | Week | ZIP (PDF, etc) | TRS SFTP | |
| Compiled Private Equity documents | Weekly, start of Friday | Week | ZIP (PDF, etc) | TRS SFTP | |
| Compiled Real Estate documents | Weekly, start of Friday | Week | ZIP (PDF, etc) | TRS SFTP | |
| Compliance test account asset grouping | Monthly, close of 1st business day | Month | Flat file (CSV) | TRS SFTP | |
| Compliance test account invested to total | Monthly, close of 1st business day | Month | Flat file (CSV) | TRS SFTP | |
| Compliance test account notional reallocation | Monthly, close of 1st business day | Month | Flat file (CSV) | TRS SFTP | |
| Compliance test account repo reallocation | Monthly, close of 1st business day | Month | Flat file (CSV) | TRS SFTP | |
| Corporate Action event details | Weekdays, start of day | Day | Flat file (CSV) | TRS SFTP | |
| Counterparty compliance test | Weekdays, close of business | Day | Flat file (CSV) | TRS SFTP | |
| Currency-counterparty overlay compliance test | Weekdays, midday | Day | Flat file (CSV) | TRS SFTP | |
| Custody Cash Settlements | Weekdays, start of day | Day | Flat file (CSV) | TRS SFTP | |
| Custody Failed Trades | Weekdays, start of day | Day | Flat file (CSV) | TRS SFTP | |
| Custody Matches Trades | Weekdays, start of day | Day | Flat file (CSV) | TRS SFTP | |
| Custody positions | Weekdays, overnight | Day | Flat file (CSV) | TRS SFTP | |
| Custody positions | Weekdays, close of business | Day | Flat file (CSV) | ISS Proxy SFTP | |
| Custody Settled Trades | Weekdays, start of day | Day | Flat file (CSV) | TRS SFTP | |
| Custody Unmated Trades | Weekdays, start of day | Day | Flat file (CSV) | TRS SFTP | |
| Daily Summary Level Holdings (ST and FX at lot) | Daily (except Sunday), overnight | Day | Yes | Flat file (CSV) | FactSet SFTP |
| External manager fee accrual and payments | Monthly, close of 8th business day | Month | Flat file (CSV) | TRS SFTP | |
| Fee transparency for private market managers | Quarterly, ~4-month after quarter end | Quarter | Yes | Flat file (CSV) | TRS SFTP |
| Fund header | Weekdays, overnight | Day | Yes | Flat file (CSV) | TRS SFTP |
| Fund net, invested, & security performance (preliminary) | Weekdays, start of day | 30 Day | Flat file (CSV) | TRS SFTP | |
| Fund net, invested, and security performance (final) | Weekdays, midday | 30 Day | Yes | Flat file (CSV) | TRS SFTP |
| Fund, breakout, and aggregate performance (total, net, net manager, invested level, etc) | Monthly, close of 13th business day | 6 Month | Flat file (CSV) | TRS SFTP | |
| Fund, breakout, and aggregate performance (total, net, net manager, invested level, etc) | Weekdays, start of day | 6 Month | Flat file (CSV) | TRS SFTP | |
| Fund, breakout, and aggregate total performance (final) | Weekdays, midday | 45 Day | Yes | Flat file (CSV) | TRS SFTP |
| Fund, breakout, and aggregate total performance (preliminary) | Weekdays, start of day | 45 Day | Yes | Flat file (CSV) | TRS SFTP |
| FX exchange rates | Weekdays, overnight | Day | Yes | Flat file (CSV) | TRS SFTP |
| FX exchange rates | Weekdays, midday | Day | Flat file (CSV) | EzeSoft SFTP | |
| FX exchange rates | Weekdays, midday | Day | Flat file (CSV) | TRS SFTP | |
| General ledger | Monthly, morning of 8th business day | Month | Flat file (CSV) | TRS Fiscal Accounting | |
| General ledger balances | Weekdays, overnight | Day | Yes | Flat file (CSV) | TRS SFTP |
| Gross and net leverage balances | Monthly, 3 weeks after month end | All time | Yes | Flat file (CSV) | TRS SFTP |
| Incoming wire transfers | Weekdays, close of business | Day | Yes | Flat file (CSV) | TRS SFTP |
| Interest yields | Weekly, midday Monday | Week | Flat file (CSV) | TRS SFTP | |
| IPMA report on Performance testing (error and volatility) | Monthly, close of 10th business day | Month | Flat file (CSV) | TRS SFTP | |
| IPMA report on Performance testing (error and volatility) | Weekdays, close of business | Day | Yes | Flat file (CSV) | TRS SFTP |
| Lendable shares and positions on loans | Weekdays, start of day | Day | Yes | Flat file (CSV) | TRS SFTP |
| Leverage compliance testing: asset allocation | Monthly, close of 10th business day | Month | Flat file (CSV) | TRS SFTP | |
| Leverage compliance testing: counter party exposures | Weekdays, midday | Day | Flat file (CSV) | TRS SFTP | |
| Leverage compliance testing: developed/emerging markets | Weekdays, midday | Day | Flat file (CSV) | TRS SFTP | |
| Loan balance by security | Weekdays, midday | Day | Yes | Flat file (CSV) | TRS SFTP |
| Lot level holdings for Swaps | Weekdays, overnight | Day | Yes | Flat file (CSV) | TRS SFTP |
| Net cash collateral detail | Weekdays, midday | Day | Yes | Flat file (CSV) | TRS SFTP |
| Open payables and receivables | Monthly, morning of 8th business day | Month | Flat file (CSV) | TRS SFTP | |
| Open payables and receivables | Weekdays, overnight | Day | Yes | Flat file (CSV) | TRS SFTP |
| Options trade activity report | Quaterly, close of 10th business day | Quarter | Flat file (CSV) | TRS SFTP | |
| Outgoing wire transfers | Weekdays, close of business | Day | Yes | Flat file (CSV) | TRS SFTP |
| Pledged collateral | Weekdays, close of business | Day | Yes | Flat file (CSV) | TRS SFTP |
| Postions report with collateral pool characteristics (index, sector, maturity date, WAM, yield, etc) | Weekdays, start of day | Day | Yes | Flat file (CSV) | TRS SFTP |
| Private Equity and ENRI Cash Flows | Monthly, close of 5th business day | Month | Flat file (CSV) | TRS SFTP | |
| Private Equity index quarterly reports | Quarterly, ~4-month after quarter end | Quarter | Flat file (CSV) | TRS SFTP | |
| Public aggregate level returns & market values | Monthly, close of 10th business day | 12 month | Yes | Flat file (CSV) | FactSet SFTP |
| Public fund level returns & market values | Monthly, close of 10th business day | 12 month | Yes | Flat file (CSV) | FactSet SFTP |
| Real Asset Cash Flows | Monthly, close of 5th business day | Month | Flat file (CSV) | TRS SFTP | |
| Restricted securities list | Weekdays, midday | Day | Yes | Flat file (CSV) | TRS SFTP |
| Risk parity and SPN asset allocation compliance supplemental | Weekdays, midday | Day | Flat file (CSV) | TRS SFTP | |
| Risk parity and SPN asset allocation compliance test | Weekdays, midday | Day | Flat file (CSV) | TRS SFTP | |
| Risk reports | Weekday, start of day (2 day lag) | Day | Flat file (CSV) | TRS SFTP | |
| Rolling 18-month benchmark returns (1 month, 1 year, 3 year, 5 year, 10 year & 15 year) | Weekdays, midday | 18 months | Yes | Flat file (CSV) | TRS SFTP |
| Sec Lending borrower credit limits | Monthly, 3 weeks after month end | Month | Yes | Flat file (CSV) | TRS SFTP |
| Sec Lending holdings | Weekly, close of 1st business day | Week | Yes | Flat file (CSV) | TRS SFTP |
| Sec Lending performance | Monthly, 3 weeks after month end | Month | Yes | Flat file (CSV) | TRS SFTP |
| Sec Lending security level holdings | Weekdays, midday | Day | Yes | Flat file (CSV) | TRS SFTP |
| Security master | Weekdays, overnight | Day | Yes | Flat file (CSV) | TRS SFTP |
| Special Opportunities Cash Flows | Monthly, close of 5th business day | Month | Flat file (CSV) | TRS SFTP | |
| SPN account NAV | Weekdays, overnight | Day | Yes | Flat file (CSV) | Blackrock |
| SPN accounts holdings | Weekdays, overnight | Day | Yes | Flat file (CSV) | Blackrock |
| SPN acount securities | Weekdays, overnight | Day | Yes | Flat file (CSV) | Blackrock |
| SPN leverage compliance test | Weekdays, midday | Day | Flat file (CSV) | TRS SFTP | |
| SPN open FX and trades | Weekdays, overnight | Day | Yes | Flat file (CSV) | Blackrock |
| Summary level Holdings | Monthly, morning of 8th business day | Month | Flat file (CSV) | TRS SFTP | |
| Summary level Holdings | Weekdays, overnight | Day | Yes | Flat file (CSV) | TRS SFTP |
| Swap commission and fees | Quaterly, close of 10th business day | Quarter | Flat file (CSV) | TRS SFTP | |
| Swap trade activity report | Quaterly, close of 10th business day | Quarter | Flat file (CSV) | TRS SFTP | |
| Total plan asset allocation report | Monthly, close of 10th business day | Month | Flat file (CSV) | TRS SFTP | |
| Transactions | Weekdays, overnight | Day | Yes | Flat file (CSV) | TRS SFTP |
| Transactions | Weekdays, overnight | Day | Yes | Flat file (CSV) | Blackrock |
| Transparency report on Real Estate fees | Quarterly, ~4-month after quarter end | 5 Quarters | Yes | Flat file (CSV) | TRS SFTP |
| Underlying positions for Commingled Holdings | Weekdays, start of day | Day | Yes | Flat file (CSV) | IFS (IMSI) SFTP |
| Underlying positions for Commingled Holdings | Weekdays, start of day | Day | Yes | Flat file (CSV) | FactSet SFTP |
| Underlying positions for Commingled Holdings | Weekdays, start of day | Day | Yes | Flat file (CSV) | TRS SFTP |
| Upcoming cash flows | Weekdays, close of business | All time | Yes | Flat file (CSV) | TRS SFTP |
File details come from the government source that posted it. Updated .