Last active
February 12, 2020 11:44
-
-
Save tomcoakes/31fc325ae08a5d9c0979037bc8421baa to your computer and use it in GitHub Desktop.
Full aggregation query for deal count/averages/median summaries
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "aggs": { | |
| "valueIsDisclosed": { | |
| "terms": { | |
| "field": "computed.valueIsDisclosed" | |
| } | |
| }, | |
| "fitsMMCriteria": { | |
| "terms": { | |
| "field": "_computed.fitsMMCriteria" | |
| }, | |
| "aggs": { | |
| "dealValuesStatsAUD": { | |
| "stats": { | |
| "field": "_computed.dealValue.AUD" | |
| } | |
| }, | |
| "dealValuesMedianAUD": { | |
| "percentiles": { | |
| "field": "_computed.dealValue.AUD", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "dealValuesStatsCHF": { | |
| "stats": { | |
| "field": "_computed.dealValue.CHF" | |
| } | |
| }, | |
| "dealValuesMedianCHF": { | |
| "percentiles": { | |
| "field": "_computed.dealValue.CHF", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "dealValuesStatsCNY": { | |
| "stats": { | |
| "field": "_computed.dealValue.CNY" | |
| } | |
| }, | |
| "dealValuesMedianCNY": { | |
| "percentiles": { | |
| "field": "_computed.dealValue.CNY", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "dealValuesStatsEUR": { | |
| "stats": { | |
| "field": "_computed.dealValue.EUR" | |
| } | |
| }, | |
| "dealValuesMedianEUR": { | |
| "percentiles": { | |
| "field": "_computed.dealValue.EUR", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "dealValuesStatsGBP": { | |
| "stats": { | |
| "field": "_computed.dealValue.GBP" | |
| } | |
| }, | |
| "dealValuesMedianGBP": { | |
| "percentiles": { | |
| "field": "_computed.dealValue.GBP", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "dealValuesStatsHKD": { | |
| "stats": { | |
| "field": "_computed.dealValue.HKD" | |
| } | |
| }, | |
| "dealValuesMedianHKD": { | |
| "percentiles": { | |
| "field": "_computed.dealValue.HKD", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "dealValuesStatsINR": { | |
| "stats": { | |
| "field": "_computed.dealValue.INR" | |
| } | |
| }, | |
| "dealValuesMedianINR": { | |
| "percentiles": { | |
| "field": "_computed.dealValue.INR", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "dealValuesStatsJPY": { | |
| "stats": { | |
| "field": "_computed.dealValue.JPY" | |
| } | |
| }, | |
| "dealValuesMedianJPY": { | |
| "percentiles": { | |
| "field": "_computed.dealValue.JPY", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "dealValuesStatsUSD": { | |
| "stats": { | |
| "field": "_computed.dealValue.USD" | |
| } | |
| }, | |
| "dealValuesMedianUSD": { | |
| "percentiles": { | |
| "field": "_computed.dealValue.USD", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| } | |
| } | |
| }, | |
| "hasAtLeastOneExitMultiple": { | |
| "terms": { | |
| "field": "_computed.hasAtLeastOneExitMultiple" | |
| } | |
| }, | |
| "bookValueStats": { | |
| "stats": { | |
| "field": "_computed.bookValueExitMultiple" | |
| } | |
| }, | |
| "bookValueMedian": { | |
| "percentiles": { | |
| "field": "_computed.bookValueExitMultiple", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "dealValuesStatsAUD": { | |
| "stats": { | |
| "field": "_computed.dealValue.AUD" | |
| } | |
| }, | |
| "dealValuesMedianAUD": { | |
| "percentiles": { | |
| "field": "_computed.dealValue.AUD", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "dealValuesStatsCHF": { | |
| "stats": { | |
| "field": "_computed.dealValue.CHF" | |
| } | |
| }, | |
| "dealValuesMedianCHF": { | |
| "percentiles": { | |
| "field": "_computed.dealValue.CHF", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "dealValuesStatsCNY": { | |
| "stats": { | |
| "field": "_computed.dealValue.CNY" | |
| } | |
| }, | |
| "dealValuesMedianCNY": { | |
| "percentiles": { | |
| "field": "_computed.dealValue.CNY", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "dealValuesStatsEUR": { | |
| "stats": { | |
| "field": "_computed.dealValue.EUR" | |
| } | |
| }, | |
| "dealValuesMedianEUR": { | |
| "percentiles": { | |
| "field": "_computed.dealValue.EUR", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "dealValuesStatsGBP": { | |
| "stats": { | |
| "field": "_computed.dealValue.GBP" | |
| } | |
| }, | |
| "dealValuesMedianGBP": { | |
| "percentiles": { | |
| "field": "_computed.dealValue.GBP", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "dealValuesStatsHKD": { | |
| "stats": { | |
| "field": "_computed.dealValue.HKD" | |
| } | |
| }, | |
| "dealValuesMedianHKD": { | |
| "percentiles": { | |
| "field": "_computed.dealValue.HKD", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "dealValuesStatsINR": { | |
| "stats": { | |
| "field": "_computed.dealValue.INR" | |
| } | |
| }, | |
| "dealValuesMedianINR": { | |
| "percentiles": { | |
| "field": "_computed.dealValue.INR", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "dealValuesStatsJPY": { | |
| "stats": { | |
| "field": "_computed.dealValue.JPY" | |
| } | |
| }, | |
| "dealValuesMedianJPY": { | |
| "percentiles": { | |
| "field": "_computed.dealValue.JPY", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "dealValuesStatsUSD": { | |
| "stats": { | |
| "field": "_computed.dealValue.USD" | |
| } | |
| }, | |
| "dealValuesMedianUSD": { | |
| "percentiles": { | |
| "field": "_computed.dealValue.USD", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "ebitdaStats": { | |
| "stats": { | |
| "field": "targetFinancials.year1.exitMultiples.ebitda" | |
| } | |
| }, | |
| "ebitdaMedian": { | |
| "percentiles": { | |
| "field": "targetFinancials.year1.exitMultiples.ebitda", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "ebitStats": { | |
| "stats": { | |
| "field": "targetFinancials.year1.exitMultiples.ebit" | |
| } | |
| }, | |
| "ebitMedian": { | |
| "percentiles": { | |
| "field": "targetFinancials.year1.exitMultiples.ebit", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "turnoverStats": { | |
| "stats": { | |
| "field": "targetFinancials.year1.exitMultiples.turnover" | |
| } | |
| }, | |
| "turnoverMedian": { | |
| "percentiles": { | |
| "field": "targetFinancials.year1.exitMultiples.turnover", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "netIncomeStats": { | |
| "stats": { | |
| "field": "targetFinancials.year1.exitMultiples.netIncome" | |
| } | |
| }, | |
| "netIncomeMedian": { | |
| "percentiles": { | |
| "field": "targetFinancials.year1.exitMultiples.netIncome", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneDayBeforeStatsAUD": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneDayBefore.AUD" | |
| } | |
| }, | |
| "sharePriceOneDayBeforeMedianAUD": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneDayBefore.AUD", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneDayBeforeStatsCHF": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneDayBefore.CHF" | |
| } | |
| }, | |
| "sharePriceOneDayBeforeMedianCHF": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneDayBefore.CHF", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneDayBeforeStatsCNY": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneDayBefore.CNY" | |
| } | |
| }, | |
| "sharePriceOneDayBeforeMedianCNY": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneDayBefore.CNY", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneDayBeforeStatsEUR": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneDayBefore.EUR" | |
| } | |
| }, | |
| "sharePriceOneDayBeforeMedianEUR": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneDayBefore.EUR", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneDayBeforeStatsGBP": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneDayBefore.GBP" | |
| } | |
| }, | |
| "sharePriceOneDayBeforeMedianGBP": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneDayBefore.GBP", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneDayBeforeStatsHKD": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneDayBefore.HKD" | |
| } | |
| }, | |
| "sharePriceOneDayBeforeMedianHKD": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneDayBefore.HKD", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneDayBeforeStatsINR": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneDayBefore.INR" | |
| } | |
| }, | |
| "sharePriceOneDayBeforeMedianINR": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneDayBefore.INR", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneDayBeforeStatsJPY": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneDayBefore.JPY" | |
| } | |
| }, | |
| "sharePriceOneDayBeforeMedianJPY": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneDayBefore.JPY", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneDayBeforeStatsUSD": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneDayBefore.USD" | |
| } | |
| }, | |
| "sharePriceOneDayBeforeMedianUSD": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneDayBefore.USD", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneDayAfterStatsAUD": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneDayAfter.AUD" | |
| } | |
| }, | |
| "sharePriceOneDayAfterMedianAUD": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneDayAfter.AUD", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneDayAfterStatsCHF": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneDayAfter.CHF" | |
| } | |
| }, | |
| "sharePriceOneDayAfterMedianCHF": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneDayAfter.CHF", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneDayAfterStatsCNY": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneDayAfter.CNY" | |
| } | |
| }, | |
| "sharePriceOneDayAfterMedianCNY": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneDayAfter.CNY", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneDayAfterStatsEUR": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneDayAfter.EUR" | |
| } | |
| }, | |
| "sharePriceOneDayAfterMedianEUR": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneDayAfter.EUR", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneDayAfterStatsGBP": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneDayAfter.GBP" | |
| } | |
| }, | |
| "sharePriceOneDayAfterMedianGBP": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneDayAfter.GBP", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneDayAfterStatsHKD": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneDayAfter.HKD" | |
| } | |
| }, | |
| "sharePriceOneDayAfterMedianHKD": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneDayAfter.HKD", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneDayAfterStatsINR": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneDayAfter.INR" | |
| } | |
| }, | |
| "sharePriceOneDayAfterMedianINR": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneDayAfter.INR", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneDayAfterStatsJPY": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneDayAfter.JPY" | |
| } | |
| }, | |
| "sharePriceOneDayAfterMedianJPY": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneDayAfter.JPY", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneDayAfterStatsUSD": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneDayAfter.USD" | |
| } | |
| }, | |
| "sharePriceOneDayAfterMedianUSD": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneDayAfter.USD", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneMonthBeforeStatsAUD": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneMonthBefore.AUD" | |
| } | |
| }, | |
| "sharePriceOneMonthBeforeMedianAUD": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneMonthBefore.AUD", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneMonthBeforeStatsCHF": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneMonthBefore.CHF" | |
| } | |
| }, | |
| "sharePriceOneMonthBeforeMedianCHF": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneMonthBefore.CHF", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneMonthBeforeStatsCNY": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneMonthBefore.CNY" | |
| } | |
| }, | |
| "sharePriceOneMonthBeforeMedianCNY": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneMonthBefore.CNY", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneMonthBeforeStatsEUR": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneMonthBefore.EUR" | |
| } | |
| }, | |
| "sharePriceOneMonthBeforeMedianEUR": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneMonthBefore.EUR", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneMonthBeforeStatsGBP": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneMonthBefore.GBP" | |
| } | |
| }, | |
| "sharePriceOneMonthBeforeMedianGBP": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneMonthBefore.GBP", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneMonthBeforeStatsHKD": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneMonthBefore.HKD" | |
| } | |
| }, | |
| "sharePriceOneMonthBeforeMedianHKD": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneMonthBefore.HKD", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneMonthBeforeStatsINR": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneMonthBefore.INR" | |
| } | |
| }, | |
| "sharePriceOneMonthBeforeMedianINR": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneMonthBefore.INR", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneMonthBeforeStatsJPY": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneMonthBefore.JPY" | |
| } | |
| }, | |
| "sharePriceOneMonthBeforeMedianJPY": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneMonthBefore.JPY", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneMonthBeforeStatsUSD": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneMonthBefore.USD" | |
| } | |
| }, | |
| "sharePriceOneMonthBeforeMedianUSD": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneMonthBefore.USD", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneMonthAfterStatsAUD": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneMonthAfter.AUD" | |
| } | |
| }, | |
| "sharePriceOneMonthAfterMedianAUD": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneMonthAfter.AUD", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneMonthAfterStatsCHF": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneMonthAfter.CHF" | |
| } | |
| }, | |
| "sharePriceOneMonthAfterMedianCHF": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneMonthAfter.CHF", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneMonthAfterStatsCNY": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneMonthAfter.CNY" | |
| } | |
| }, | |
| "sharePriceOneMonthAfterMedianCNY": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneMonthAfter.CNY", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneMonthAfterStatsEUR": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneMonthAfter.EUR" | |
| } | |
| }, | |
| "sharePriceOneMonthAfterMedianEUR": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneMonthAfter.EUR", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneMonthAfterStatsGBP": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneMonthAfter.GBP" | |
| } | |
| }, | |
| "sharePriceOneMonthAfterMedianGBP": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneMonthAfter.GBP", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneMonthAfterStatsHKD": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneMonthAfter.HKD" | |
| } | |
| }, | |
| "sharePriceOneMonthAfterMedianHKD": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneMonthAfter.HKD", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneMonthAfterStatsINR": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneMonthAfter.INR" | |
| } | |
| }, | |
| "sharePriceOneMonthAfterMedianINR": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneMonthAfter.INR", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneMonthAfterStatsJPY": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneMonthAfter.JPY" | |
| } | |
| }, | |
| "sharePriceOneMonthAfterMedianJPY": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneMonthAfter.JPY", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| }, | |
| "sharePriceOneMonthAfterStatsUSD": { | |
| "stats": { | |
| "field": "_computed.sharePriceOneMonthAfter.USD" | |
| } | |
| }, | |
| "sharePriceOneMonthAfterMedianUSD": { | |
| "percentiles": { | |
| "field": "_computed.sharePriceOneMonthAfter.USD", | |
| "percents": [ | |
| 50 | |
| ] | |
| } | |
| } | |
| }, | |
| "size": 0 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment