Preparing for your next Quant Interview?
Practice Here!
OpenQuant
All Questions
Next Question
Growing Fund
00:00:00
4/10
Data Wrangling
Parts
Part 1

A multi-billion dollar hedge fund has many subsidiary funds that each have their own investment thesis. Certain investors like to allocate their capital to specific funds based on their opinion on the efficacy of the fund's investment thesis.

Using the tables below, for each fund find the largest percent change in the month over month number of investors that the fund acquired in 2023. Output the fund's name, month with the largest percent increase, previous month's number of investors, current month's number of investors, and the percent change. Order the resulting data by the percent change in investors in descending order and then the fund's name in ascending order.

Guidelines

  1. For January, the percent change in how many investors the fund acquired should be null.
  2. If a fund has two months with an identical percent change in the number of investors, choose the percent increase that corresponds to the earlier month.
  3. Round the percent change to two decimals.

Example Output

fund_namemonthcurr_mon_investor_cntprev_mon_investor_cntperc_change
Alpha FundFeb134225%
Beta FundMar736217.74%
Delta FundDec44424.76%

Input Tables

funds

Column NameData Type
fund_idbigint
fund_nametext
fund_manager_nametext
fund_established_dtdatetime

fund_investors

Column NameData Type
investor_idbigint
fund_idbigint
initial_investment_amtfloat
initial_investment_dtdatetime