This is an R Markdown Notebook. Demonstrating some of fundManageR’s ADV data acquisition functions.
packages <- c('fundManageR', 'dplyr', 'tidyr', 'purrr', 'formattable', 'stringr')
lapply(packages, library, character.only = T)Here will use the get_data_adv_managers_current_period_summary function to do some quick explorations of ADV filing investment managers.
most_recent_data <-
get_data_adv_managers_current_period_summary(file_directory = 'Desktop/adv_test')most_recent_data %>%
head %>%
formattable()most_recent_data %>%
group_by(stateOfficePrimary) %>%
summarise(
amountAUMTotal = sum(amountAUMTotal, na.rm = T) %>% currency(digits = 0),
countEmployeesTotal = sum(countEmployeesTotal, na.rm = T) %>% comma(digits = 0),
countCompanies = n() %>% comma(digits = 0)
) %>%
ungroup %>%
arrange(desc(amountAUMTotal)) %>%
formattable()For this example we will try to find out information about entities related to The Blackstone Group, we can expand this search for entities that MAY be related to Blackstone by taking advantage of the fact we know Blackstone’s office is located at 345 Park Avenue in New York.
possible_bx_companies <-
most_recent_data %>%
dplyr::filter(
nameEntityManager %>% str_detect("BLACKSTONE REAL|BREP|GSO") |
locationOfficePrimary %>% str_detect("^345 PARK AVENUE") |
urlManager %>% str_detect('blackstone.com')
) %>%
dplyr::select(
idCRD,
nameEntityManager,
urlManager,
locationOfficePrimary,
urlManager,
amountAUMTotal
)possible_bx_companies %>%
formattable()Some of these entities we know are not related to Blackstone so let’s exclude them, others have no stated AUM so we can exclude those as well.
possible_bx_companies <-
possible_bx_companies %>%
dplyr::filter(!nameEntityManager %>% str_detect('LADDER CAPITAL ASSET MANAGEMENT LLC|DEUTSCHE|DBX|WAFRA|DB ')) %>%
dplyr::filter(amountAUMTotal > 0)possible_bx_companies %>%
formattable()Before diving into how to use these functions lets whittle down our data to a vector of CRDs we can feed into our functions.
blackstone_crds <-
possible_bx_companies$idCRDNow that we have this let’s pull in all the manager brochure data. That will allow us to perform all sorts of interesting types NLP, sentiment, and text analysis.
blackstone_brochure_data <-
get_data_adv_managers_brochures(search_names = NULL, crd_ids = blackstone_crds, split_pages = T)
If you look at the table from before there is one name that sticks out as a possible difficult to resolve possible Blackstone entity, CT INVESTMENT MANAGEMENT CO., LLC. There a bunch of ways to try to resolve this possible relationship; fundManageR affords us a bunch of possible data driven ways to do this.
One cool feature of the pdftools package is we can extract a PDF file’s metadata, this package takes advantage of that functionality. In this example we will take advantage of the PDF file’s author metadata to see if the author of CT Investment Management’s filing appears in any the entities we know with absolute certainty are Blackstone entities.
ct_validation_test <-
blackstone_brochure_data %>%
dplyr::select(idCRD, nameEntityManager, nameAuthor) %>%
distinct() %>%
dplyr::filter(nameAuthor %>% str_detect('buergerm'))ct_validation_test %>%
format_table()| idCRD | nameEntityManager | nameAuthor |
|---|---|---|
| 135952 | BLACKSTONE REAL ESTATE ADVISORS EUROPE L.P. | buergerm |
| 226598 | BLACKSTONE PROPERTY ADVISORS L.P. | buergerm |
| 138208 | BLACKSTONE REAL ESTATE ADVISORS V L.P. | buergerm |
| 120936 | BLACKSTONE REAL ESTATE ADVISORS IV L.L.C. | buergerm |
| 160080 | CT INVESTMENT MANAGEMENT CO., LLC | buergerm |
| 111871 | BLACKSTONE REAL ESTATE ADVISORS INTERNATIONAL L.L.C. | buergerm |
Well well well, looks like buergerm has authored some of the PDFs that we KNOW are related to Blackstone, there for it is safe to say CT Investment Management is indeed a related party to Blackstone. Entity resolved!
Next let’s see if we can try to figure out the tier’s of management fees Blackstone charges its investors. To do this you will need the fantastic tidytext package developed by Julia Silge and David Robinson. If you don’t have the package you can install it from CRAN or via github.
The first step to achieving our stated goal is to tokenize each brochure’s sentences. We want to to try to determine whether a stated sentence may contain a reference to a management fee. We can use that using stringr and it’s str_detect function with a list of management fee hit words, the most important of which being a % sign. Once completed we will take those sentence, tokenize down to words and look for a number less than 5 knowing management fees are generally between 1% and 5%. After we do that we can look at identified sentences and see how we did!
library(tidytext) ## devtools::install_github(juliasilge/tidytext)sentence_data <-
blackstone_brochure_data %>%
dplyr::select(idCRD, nameEntityManager, textBrochure) %>%
unnest_tokens(sentence, textBrochure, token = "sentences") %>%
mutate(idSentence = 1:n()) %>%
mutate(
hasMGMTFeeReference = sentence %>% str_detect('[1-99]%')
)
possible_fees <-
sentence_data %>%
dplyr::filter(hasMGMTFeeReference == T) %>%
dplyr::select(idCRD, nameEntityManager, sentence, idSentence) %>%
unnest_tokens(word, sentence, token = 'words') %>%
dplyr::filter(word %>% str_detect("^[1-9]")) %>%
mutate(word = word %>% as.numeric) %>%
dplyr::filter(word <= 5)possible_fees %>%
formattablepossible_fees$idSentence %>%
unique() %>%
map_chr(function(x) {
setence_df <-
sentence_data %>%
dplyr::filter(idSentence == x)
fee_text <-
setence_df %>%
.$sentence %>% paste0('\n', ., '\n')
setence_df$nameEntityManager %>% paste0('Manager: ',., '\n', fee_text)
}) %>%
paste0(collapse = '\n') %>%
messageManager: BLACKSTONE ALTERNATIVE ASSET MANAGEMENT LP
item 5 - fees and compensation item 5 - fees and compensation asset-based advisory fees in general, baam charges an asset-based advisory fee of up to 2% of assets under management.
Manager: BLACKSTONE MEZZANINE ADVISORS LP
item 5: fees and compensation for its investment advisory services provided to funds, bx mezzanine or an affiliated entity may receive a management fee at an annual rate of up to 2% of either the net assets or invested capital, which may include capital borrowed from leverage providers, pursuant to the offering and/or governing documents, which are provided to prospective investors.
Manager: BLACKSTONE DEBT ADVISORS L.P.
item 5: fees and compensation for its investment advisory services provided to funds, bda or an affiliated entity may receive a management fee at an annual rate of up to 2% of either the net assets or invested capital, which may include capital borrowed from leverage providers, pursuant to the offering and/or governing documents, which are provided to prospective investors.
Manager: STRATEGIC PARTNERS FUND SOLUTIONS ADVISORS L.P.
management fees for its investment advisory services with respect to the funds, the registrant or an affiliated entity generally receives a management fee at an annual rate of up to 1.5% of the capital commitments or invested capital, as the case may be.
Manager: STRATEGIC PARTNERS FUND SOLUTIONS ADVISORS L.P.
performance-based allocations in addition to the management fees and other fees described in item 5 above, the registrant or one of the general partners generally receives a performance-based allocation of up to 12.5% (or up to 15% for investors that commit to a fund through a feeder vehicle established by a private bank to invest in the fund (a "private bank feeder fund")) of each fund's cumulative net profits, subject to a preferred return and customary clawback provisions.
Manager: BLACKSTONE REAL ESTATE ADVISORS EUROPE L.P.
dollars ("dollar partner"), and (b) 1.25% per annum if such investor has aggregate capital commitments equal to or greater than €100 million, in the case of a euro partner, and $100 million in the case of a dollar partner.
Manager: BLACKSTONE REAL ESTATE ADVISORS EUROPE L.P.
the management fee payable by a brep europe iii investor is: (a) 1.50% per annum if such investor has aggregate capital commitments of less than €200 million, in the case of a euro partner, and $200 million in the case of a dollar partner, (b) 1.25% per annum if such investor has aggregate capital commitments equal to or greater than €200 million, in the case of a euro partner, and $200 million in the case of a dollar partner, and (c) 1.25% per annum for investors with capital commitments to brep europe iii and blackstone real estate partners vi l.p. in excess of $950 million.
Manager: BLACKSTONE REAL ESTATE ADVISORS EUROPE L.P.
the management fee payable by a brep europe iv investor is: (a) 1.5% per annum if such investor has aggregate capital commitments of less than €200 million, in the case of a euro partner, and $250 million in the case of a dollar partner, (b) 1.25% per annum if such investor has aggregate capital commitments equal to or greater than €200 million, in the case of a euro partner, and $250 million in the case of a dollar partner and (c) 1.1% per annum if such investor has aggregate capital commitments equal to or greater than the euro equivalent of $500 million (as converted at the prevailing rate of exchange as of the date prior to such investor's admission date or as otherwise agreed to between such investor and the general partner), in the case of a euro partner, and $500 million in the case of a dollar partner.
Manager: BLACKSTONE REAL ESTATE ADVISORS EUROPE L.P.
irrespective of the capital commitment of such investor, the management fee with respect to a brep europe iv investor that is itself an investment vehicle formed for the purpose of aggregating unaffiliated investors for purposes of investing in brep europe iv is 1.5% per annum.
Manager: GSO CAPITAL PARTNERS LP
item 5: fees and compensation for its investment advisory services provided to funds, gso or an affiliated entity may receive a management fee at an annual rate of up to 2% of either the net assets or invested capital, which may include capital borrowed from leverage providers, pursuant to the offering and/or governing documents, which are provided to prospective investors.
Manager: BLACKSTONE REAL ESTATE ADVISORS V L.P.
in no event, however, will the management fee exceed 1.5% of such capital commitments or 1.5% of invested capital, as the case may be, of the fund.
Manager: BLACKSTONE STRATEGIC ALLIANCE ADVISORS L.L.C.
item 5 - fees and compensation item 5 - fees and compensation asset-based advisory fees in general, bsaa charges an asset-based advisory fee to the bsaa funds of up to 1% of assets under management, which fees scale-down to as low as 0.8% of assets under management based on the amount of capital committed to the bsaa funds by an investor.
Manager: BLACKSTONE STRATEGIC ALLIANCE ADVISORS L.L.C.
item 6 - performance-based fees item 6 - performance-based fees in addition to the asset-based advisory fees disclosed in item 5 - fees and compensation above, bsaa funds also pay (a) a performance fee up to 10% of the increase in net asset value of the investment in underlying managers and co-investments, subject to a loss carryforward provision (which fee may scale-down to as low as 8% based on the amount of capital committed to the bsaa funds by an underlying investor) and (b) up to 20% of the proceeds with respect to manager profit interests and manager buyout interests (which fee may scale- down to as low as 16% based on the amount of capital committed to the bsaa funds by an underlying investor, subject to a high water mark.
Manager: BLACKSTONE REAL ESTATE ADVISORS L.P.
the management fee payable by a brep vi investor is: (a) 1.50% per annum if such investor has aggregate capital commitments of less than $300 million and (b) 1.25% per annum if such investor has aggregate capital commitments equal to or greater than $300 million.
Manager: BLACKSTONE REAL ESTATE ADVISORS L.P.
the management fee payable by a brep vii investor is: (a) 1.50% per annum if such investor has aggregate capital commitments of less than $300 million, (b) 1.25% per annum if such investor has aggregate capital commitments equal to or greater than $300 million but less than $500 million, (c) 1.15% per annum if such investor has aggregate capital commitments equal to or greater than $500 million but less than $800 million and (d) 1.10% per annum if such investor has aggregate capital commitments equal to or greater than $800 million.
Manager: BLACKSTONE REAL ESTATE ADVISORS L.P.
the management fee payable by a brep viii investor is: (a) 1.50% per annum if such investor has aggregate capital commitments of less than $300 million, (b) 1.25% per annum if such investor has aggregate capital commitments equal to or greater than $300 million but less than $500 million and (c) 1.15% per annum if such investor has aggregate capital commitments equal to or greater than $500 million.
Manager: BLACKSTONE REAL ESTATE ADVISORS L.P.
the management fee payable by a brep asia investor is: (a) 1.50% per annum if such investor has aggregate capital commitments of less than $200 million, (b) 1.25% per annum if such investor has aggregate capital commitments equal to or greater than $200 million but less than $500 million and (c) 1.00% per annum if such investor has aggregate capital commitments equal to or greater than $500 million.
Manager: BLACKSTONE REAL ESTATE ADVISORS L.P.
the management fee payable by a brep europe v investor is: (a) 1.5% per annum if such investor has aggregate capital commitments of less than €280 million (or $300 million in the case of an investor making its capital commitment in u.s. dollars), and (b) 1.25% per annum if such investor has aggregate capital commitments equal to or greater than €280 million (or $300 million in the case of an investor making its capital commitment in u.s. dollars).
Manager: GSO / BLACKSTONE DEBT FUNDS MANAGEMENT LLC
item 5: fees and compensation for its investment advisory services provided to funds, dfm or an affiliated entity may receive a management fee at an annual rate of up to 2% of either the net assets or invested capital, which may include capital borrowed from leverage providers, pursuant to the offering and/or governing documents, which are provided to prospective investors.
Manager: BLACKSTONE REAL ESTATE SPECIAL SITUATIONS ADVISORS L.L.C.
item 5: fees and compensation management fees and performance fees pursuant to bressa's advisory agreements with each of the funds, bressa is entitled to compensation for its services in the form of an annual management fee (the "bressa management fee"), payable quarterly at a rate up to 1.5% per annum (varying between funds) of the fund's (i) net asset value, in the case of the funds that are structured as "hedge funds", or (ii) total invested capital, in the case of the funds that are structured as "private equity funds", determined and payable as of the first business day of each calendar quarter for the funds paying in advance.
Manager: BLACKSTONE CLEAN TECHNOLOGY ADVISORS L.L.C.
in no event, however, will the management fee exceed 1.75% per annum of such capital commitments or 1.75% per annum of invested capital, as the case may be, of the fund.
Manager: BLACKSTONE CLEAN TECHNOLOGY ADVISORS L.L.C.
bcta will credit against future management fees 66 2/3% of the management fees charged to date and only charge management fees on invested capital going forward.
Manager: GSO CAPITAL ADVISORS LLC
item 5: fees and compensation for its investment advisory services provided to funds, capital advisors or an affiliated entity may receive a management fee at an annual rate of up to 2% of either the net assets or invested capital, which may include capital borrowed from leverage providers, pursuant to the offering and/or governing documents, which are provided to prospective investors.
Manager: BLACKSTONE ALTERNATIVE SOLUTIONS L.L.C.
item 5 - fees and compensation item 5 - fees and compensation asset-based advisory fees in general, bas charges an asset-based advisory fee of up to 1.5% of assets under management.
Manager: BLACKSTONE ALTERNATIVE SOLUTIONS L.L.C.
item 6 - performance-based fees item 6 - performance-based fees in addition to the asset-based advisory fees disclosed in item 5 - fees and compensation above, bas funds generally will be charged a performance-based fee generally equal to 25% of net profits, inclusive of the underlying manager fee, subject to loss carryforward provisions bas's fees will be reduced by the full amount of any fees paid to bas underlying managers.
Manager: BLACKSTONE ALTERNATIVE INVESTMENT ADVISORS LLC
blackstone alternative investment advisors llc item 5 - fees and compensation item 5 -fees and compensation asset-based advisory fees in general, baia charges an asset-based advisory fee of up to 2% of assets under management.
Manager: BLACKSTONE ALTERNATIVE INVESTMENT ADVISORS LLC
blackstone alternative investment advisors llc item 6 - performance-based fees tem 6 - performance-based fees in addition to the asset-based advisory fees disclosed in item 5 - fees and compensation above, certain baia funds charge a performance-based fee of up to 15% of the positive performance of such baia funds, subject to a loss carryforward provision.
Manager: BLACKSTONE STRATEGIC CAPITAL ADVISORS, L.LC.
item 6 - performance-based fees item 6 - performance-based fees in addition to the asset-based advisory fees disclosed in item 5 - fees and compensation above, the general partner receives a carried interest distribution of up to 20% of the profits realized in respect of each bsca manager interest (or other permitted investment), after the bsca fund first makes distributions to investors in an amount equal to the investors' capital contributions in respect of each bsca manager interest together with an 8% preferred return on such amounts.
Manager: BLACKSTONE MULTI-ASSET ADVISORS L.L.C.
with respect to harrington reinsurance, pursuant to the harrington constituent documents, bmaa is entitled to compensation for its services to harrington partners in the form of an annual management fee, calculated and payable quarterly in arrears as of the last business day of each fiscal quarter, at a rate equal to 1.5% per annum of the net asset value of harrington partners.
Manager: BLACKSTONE SENFINA ADVISORS L.L.C.
item 5 - fees and compensation item 5 - fees and compensation asset-based advisory fees in general, bsa charges an asset-based advisory fee up to 2% per annum based on average assets under management.
Manager: BLACKSTONE PROPERTY ADVISORS L.P.
the bpa management fee payable by a bpp investor (a) with an aggregate capital commitment of less than $300 million, is 1.0% per annum of such investor's proportionate share of the net asset value of bpp, or (b) with an aggregate capital commitment equal to at least $300 million, is 0.85% per annum of such investor's proportionate share of the net asset value of bpp.
Manager: BLACKSTONE PROPERTY ADVISORS L.P.
the bpa management fee payable by a bapp investor is (a) 1.0% per annum of such investor's invested capital and (b) 0.5% per annum of such investor's unpaid capital commitments.
Manager: BLACKSTONE PROPERTY ADVISORS L.P.
the bpa management fee payable by a bppi investor (a) with an aggregate capital commitment of less than $500 million, is 1.0% per annum of such investor's proportionate share of the net asset value of bppi, or (b) with an aggregate capital commitment equal to at least $500 million, is 0.85% per annum of such investor's proportionate share of the net asset value of bppi.
Manager: BLACKSTONE PROPERTY ADVISORS L.P.
however, bpa management fees paid by an investor in the other core+ vehicles are generally determined based on a percentage ranging from 0.5% to 1% per annum of either an investor's invested capital or share of the net asset value of the relevant other core+ vehicle.
Manager: BLACKSTONE PROPERTY ADVISORS L.P.
management fees and performance fees payable to bx reit advisors pursuant to the breit advisory agreement, bx reit advisors is entitled to compensation for its services in the form of a management fee (the "breit management fee" and, together with the bpa management fee, the "management fee") of 1.25% of breit's net asset value per annum payable monthly.
Manager: BLACKSTONE PROPERTY ADVISORS L.P.
in addition to the breit management fees and other fees described in item 5 that are received by bx reit advisors, so long as the breit advisory agreement has not been terminated (including by means of non-renewal), the breit special limited partner will receive performance-based compensation equal to 12.5% of breit's total return (which for any period shall equal the sum of (i) all distributions accrued or paid (without duplication) on the breit operating partnership units outstanding at the end of the period since the beginning of the then- current calendar year plus (ii) the change in aggregate net asset value of such units since the beginning of the then-current calendar year, before giving effect to (x) changes resulting solely from the proceeds of issuances of breit operating partnership units, (y) any allocation/accrual to the performance participation interest and (z) applicable stockholder servicing fee expenses), subject to (a) a hurdle amount of 5% annualized internal rate of return on the net asset value of the breit operating partnership units, and (b) a "high water mark" so that the recoupment of past annual total return losses will offset the positive annual total return for purposes of the calculation of the breit special limited partner's performance participation.This incredibly basic workflow looks like it produced a solid method for identifying and potentially extracting those management fees! There is so much more we could do with this, some of which I will explore in a blog post in the near future but from here let’s dig a little bit deeper into each of this entities using fundManageR's get_data_adv_managers_filings function.
The most difficult feature to build was fundManageR to parse the SEC’s absolutely HORRENDUS online ADV forms. Fortunately this task, though extremely difficult, was doable. Parsing an ADV form, especially if you select a manager with a large amount of assets under management can be a little time consuming considering the size of the data being processed so please, be patient.
Instead of selecting all possible sections you can specify the specific sections you want the function to pull in, to see your options you can call the get_data_sec_adv_manager_sitemap function.
get_data_sec_adv_manager_sitemap() %>%
formattable()In our Blackstone example the majority of our selected entites have billions of dollars in assets under mangement so acquiring data for every section and each entity will take some time, you can follow the functions progress in the messages. The get_data_adv_managers_filings returns a list of nested data frames by entity manager and section; to make the data easier to explore upon scraping the default action is to save each section into the user’s environment and we combine the brochure sections with a unique list of values describing the manager into a single data frame assigned to the environment as managerDescription, you can override this by setting flatten_tables to FALSE.
blackstone_entity_df <-
get_data_adv_managers_filings(
search_names = NULL,
crd_ids = blackstone_crds,
all_sections = T,
assign_to_enviornment = T
)idCRD: 136979 - Registration
idCRD: 136979 - DRPs
idCRD: 136979 - Identifying Information
idCRD: 136979 - SEC Reporting
idCRD: 136979 - Organization
idCRD: 136979 - Successions
idCRD: 136979 - Advisory Business Information
idCRD: 136979 - Other Business Activities
idCRD: 136979 - Financial Industry Affiliations
idCRD: 136979 - Private Fund Reporting
Parsed BLACKSTONE MANAGEMENT PARTNERS L.L.C. they have 10 fund vehicles and $56,528,584,012.00 in private fund AUM
idCRD: 136979 - Participation or Interest in Client Transactions
idCRD: 136979 - Custody
idCRD: 136979 - Control Persons
idCRD: 136979 - Disclosure Information
idCRD: 136979 - Direct Manager Owners
idCRD: 136979 - Indirect Manager Owners
idCRD: 136979 - Other Manager Information
idCRD: 136979 - Manager Signatories
Parsed BLACKSTONE MANAGEMENT PARTNERS L.L.C.
They have $62,950,761,426 in Total Assets Under Management
idCRD: 107580 - Registration
idCRD: 107580 - DRPs
idCRD: 107580 - Identifying Information
idCRD: 107580 - SEC Reporting
idCRD: 107580 - Organization
idCRD: 107580 - Successions
idCRD: 107580 - Advisory Business Information
idCRD: 107580 - Other Business Activities
idCRD: 107580 - Financial Industry Affiliations
idCRD: 107580 - Private Fund Reporting
Parsed BLACKSTONE ALTERNATIVE ASSET MANAGEMENT LP they have 141 fund vehicles and $53,007,930,592.00 in private fund AUM
idCRD: 107580 - Participation or Interest in Client Transactions
idCRD: 107580 - Custody
idCRD: 107580 - Control Persons
idCRD: 107580 - Disclosure Information
idCRD: 107580 - Direct Manager Owners
idCRD: 107580 - Indirect Manager Owners
idCRD: 107580 - Other Manager Information
idCRD: 107580 - Manager Signatories
Parsed BLACKSTONE ALTERNATIVE ASSET MANAGEMENT LP
They have $59,349,863,824 in Total Assets Under Management
idCRD: 142979 - Registration
idCRD: 142979 - DRPs
idCRD: 142979 - Identifying Information
idCRD: 142979 - SEC Reporting
idCRD: 142979 - Organization
idCRD: 142979 - Successions
idCRD: 142979 - Advisory Business Information
idCRD: 142979 - Other Business Activities
idCRD: 142979 - Financial Industry Affiliations
idCRD: 142979 - Private Fund Reporting
Parsed BLACKSTONE REAL ESTATE ADVISORS L.P. they have 33 fund vehicles and $15,746,255,200.00 in private fund AUM
idCRD: 142979 - Participation or Interest in Client Transactions
idCRD: 142979 - Custody
idCRD: 142979 - Control Persons
idCRD: 142979 - Disclosure Information
idCRD: 142979 - Direct Manager Owners
idCRD: 142979 - Indirect Manager Owners
idCRD: 142979 - Other Manager Information
idCRD: 142979 - Manager Signatories
Parsed BLACKSTONE REAL ESTATE ADVISORS L.P.
They have $56,404,540,029 in Total Assets Under Management
idCRD: 137519 - Registration
idCRD: 137519 - DRPs
idCRD: 137519 - Identifying Information
idCRD: 137519 - SEC Reporting
idCRD: 137519 - Organization
idCRD: 137519 - Successions
idCRD: 137519 - Advisory Business Information
idCRD: 137519 - Other Business Activities
idCRD: 137519 - Financial Industry Affiliations
idCRD: 137519 - Private Fund Reporting
Parsed GSO CAPITAL PARTNERS LP they have 46 fund vehicles and $33,210,412,218.00 in private fund AUM
idCRD: 137519 - Participation or Interest in Client Transactions
idCRD: 137519 - Custody
idCRD: 137519 - Control Persons
idCRD: 137519 - Disclosure Information
idCRD: 137519 - Direct Manager Owners
idCRD: 137519 - Indirect Manager Owners
idCRD: 137519 - Other Manager Information
idCRD: 137519 - Manager Signatories
Parsed GSO CAPITAL PARTNERS LP
They have $38,332,219,304 in Total Assets Under Management
idCRD: 144537 - Registration
idCRD: 144537 - DRPs
idCRD: 144537 - Identifying Information
idCRD: 144537 - SEC Reporting
idCRD: 144537 - Organization
idCRD: 144537 - Successions
idCRD: 144537 - Advisory Business Information
idCRD: 144537 - Other Business Activities
idCRD: 144537 - Financial Industry Affiliations
idCRD: 144537 - Private Fund Reporting
Parsed GSO / BLACKSTONE DEBT FUNDS MANAGEMENT LLC they have 66 fund vehicles and $23,178,956,912.00 in private fund AUM
idCRD: 144537 - Participation or Interest in Client Transactions
idCRD: 144537 - Custody
idCRD: 144537 - Control Persons
idCRD: 144537 - Disclosure Information
idCRD: 144537 - Direct Manager Owners
idCRD: 144537 - Indirect Manager Owners
idCRD: 144537 - Other Manager InformationContains general information about the manager from all sections with distinct data.
managerDescription # General InformationContains information about any violations by the manager or it’s employees. These includes any violation levied by a government or self-policing regulatory body.
managerRegulatoryCRDThis section discloses the where the manager stores its books and records.
managerRecordLocationsThis section discloses any other relevent information the manager wishes to communicate to the SEC including certain details regarding data in the filing.
managerOtherDisclosuresThis section includes information about the underlying fund vehicles of a registered manager. This may include information about the fund size, number of invesors, types of investors, distribution of ownership, details about third parties that service the fund [accountants, marketing agents, custodians, prime brokers, ect..] and any information about related parties to the fund [General Partner, Managing Member, ect..]
section7BPrivateFundReporting # General InformationThe private fund section is chocked full of great visualizable data, and to demonstrate we are going to crate a treemap visualization care of Kenton Russell’s fantistic d3treeR package that will explore Blackstone’s assets under management by fund type, fund manager, fund vehicle name, and number of fund investors.
library(treemap) # install.packages('treemap')
library(d3treeR) # devtools::install_github("timelyportfolio/d3treeR")
section7BPrivateFundReporting %>%
mutate(nameFund = nameFund %>% str_replace_all('\\ ','\n')) %>%
treemap(
index = c("typeFund",'nameEntityManager', "nameFund"),
vSize = "amountFundGrossAUM",
vColor = "countFundOwners",
palette="RdYlGn",
fontsize.labels = 8,
type = "value"
) %>%
d3tree2(rootname = "Blackstone Vehicles")This section includes information about the individuals and entities that own the registering entity, this includes ranged disclosures on percentage of ownership. This information, along with Schedule B, are ideal uses for Network Analysis
This section includes information on the owners of any Schedule A owner that is an entity
sectionScheduleB # Indirect OwnersThis section includes information on all secondary offices, when applicable, related to the filing manager.
This section includes information on control entities for a filing manager, this essentially means is the manager controlled by a public entity, a good example being Blackstone which is a public company.
managerWebsite # WebsitesThis section includes information on control persons for any filing manager that is related to a public entitiy.
managerControlPersons # WebsitesThis section includes any website relatd to the filing manager.
managerWebsite # Websites