new_adrs_0322_0670|MPTYY|Short Name|0|0|total_current_assets|cash_on_hand|inventories_net|net_ppe|goodwill_and_intangible|liabilities|total_current_liabilities|total_long_term_liab|total_deposits|book_value_of_equity|retained_earnings|treasury_stock|ev_revenues|ev_earnings|ev_free_cash_flow|ev_assets|ps_ratio|pe_ratio|price_to_book_value|peg_ratio|debt_equity_ratio|dividend_yield|shareholder_yield_ttm|percent_of_shares_outstanding|receivables|payables|capital_stock|return_on_invested_capital|quality_ratio_fractile|momentum_fractile|market_beta_12_month|sustainable_growth_rate|institutional_investor_ownership_percentage|average_shares_outs_diluted|total_employee_number|eps|shares_outstanding|repurchase_of_capital_stock|ordinary_shares_number|payout_ratio|quick_ratio|normalized_eps|stock_buyback|effective_tax_rate|return_on_equity|net_income_ttm|revenues_ttm|dividend_per_share|revenues|gross_profit|sga_expense|pre_tax_income|net_income|interest_income|price|total_return_price|enterprise_value|average_volume_30|one_year_return
new_adrs_0322_0670|MPTYY|Long Name|1|1|Merlin Properties SOCIMI SA Total Current Assets (Quarterly) (USD)|Merlin Properties SOCIMI SA Cash and Short Term Investments (Quarterly) (USD)|Merlin Properties SOCIMI SA Inventories (Quarterly) (USD)|Merlin Properties SOCIMI SA Net PP&E (Quarterly) (USD)|Merlin Properties SOCIMI SA Goodwill and Intangibles (Quarterly) (USD)|Merlin Properties SOCIMI SA Total Liabilities (Quarterly) (USD)|Merlin Properties SOCIMI SA Total Current Liabilities (Quarterly) (USD)|Merlin Properties SOCIMI SA Total Long Term Liabilities (Quarterly) (USD)|Merlin Properties SOCIMI SA Total Deposits (Quarterly) (USD)|Merlin Properties SOCIMI SA Book Value (Quarterly) (USD)|Merlin Properties SOCIMI SA Retained Earnings (Quarterly) (USD)|Merlin Properties SOCIMI SA Treasury Stock (Quarterly) (USD)|Merlin Properties SOCIMI SA EV to Revenues|Merlin Properties SOCIMI SA EV to Earnings|Merlin Properties SOCIMI SA EV to Free Cash Flow|Merlin Properties SOCIMI SA EV to Assets (Quarterly)|Merlin Properties SOCIMI SA PS Ratio|Merlin Properties SOCIMI SA PE Ratio|Merlin Properties SOCIMI SA Price to Book Value|Merlin Properties SOCIMI SA PEG Ratio|Merlin Properties SOCIMI SA Debt to Equity Ratio|Merlin Properties SOCIMI SA Dividend Yield|Merlin Properties SOCIMI SA Shareholder Yield (TTM)|Merlin Properties SOCIMI SA Percent of Shares Outstanding Short|Merlin Properties SOCIMI SA Total Receivables (Quarterly) (USD)|Merlin Properties SOCIMI SA Total Payables (Quarterly) (USD)|Merlin Properties SOCIMI SA Total Capital Stock (Quarterly) (USD)|Merlin Properties SOCIMI SA Return on Invested Capital|Merlin Properties SOCIMI SA Quality Ratio Score|Merlin Properties SOCIMI SA Momentum Score|Merlin Properties SOCIMI SA Beta (1Y)|Merlin Properties SOCIMI SA Sustainable Growth Rate (TTM)|Merlin Properties SOCIMI SA Institutional Investor Ownership Percentage|Merlin Properties SOCIMI SA Average Diluted Shares Outstanding (Quarterly)|Merlin Properties SOCIMI SA Total Employees (Annual)|Merlin Properties SOCIMI SA EPS Diluted (Quarterly) (USD)|Merlin Properties SOCIMI SA Shares Outstanding|Merlin Properties SOCIMI SA Repurchase of Capital Stock (Quarterly) (USD)|Merlin Properties SOCIMI SA Ordinary Shares Number (Quarterly)|Merlin Properties SOCIMI SA Payout Ratio|Merlin Properties SOCIMI SA Quick Ratio (Quarterly)|Merlin Properties SOCIMI SA Normalized Diluted EPS (Quarterly) (USD)|Merlin Properties SOCIMI SA Stock Buybacks (Quarterly) (USD)|Merlin Properties SOCIMI SA Effective Tax Rate (TTM)|Merlin Properties SOCIMI SA Return on Equity|Merlin Properties SOCIMI SA Net Income (TTM) (USD)|Merlin Properties SOCIMI SA Revenue (TTM) (USD)|Merlin Properties SOCIMI SA Dividend Per Share (Quarterly) (USD)|Merlin Properties SOCIMI SA Revenue (Quarterly) (USD)|Merlin Properties SOCIMI SA Gross Profit (Quarterly) (USD)|Merlin Properties SOCIMI SA SG&A Expense (Quarterly) (USD)|Merlin Properties SOCIMI SA Pre-Tax Income (Quarterly) (USD)|Merlin Properties SOCIMI SA Net Income (Quarterly) (USD)|Merlin Properties SOCIMI SA Net Interest Income (Quarterly) (USD)|Merlin Properties SOCIMI SA Price (USD)|Merlin Properties SOCIMI SA Total Return Price (USD)|Merlin Properties SOCIMI SA Enterprise Value (USD)|Merlin Properties SOCIMI SA 30-Day Average Daily Volume|Merlin Properties SOCIMI SA 1 Year Price Returns (Daily)
new_adrs_0322_0670|MPTYY|Unit|2|2|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|percent_USD_metric|percent_USD_metric|percent_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|percent_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_beta|percent_USD_metric|percent_USD_metric|mil_figure_USD_metric|figure_whole_USD_metric|figure_money_USD_per_share_metric|mil_figure_USD_metric|mil_figure_money_USD_metric|mil_figure_USD_metric|percent_USD_metric|figure_USD_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|percent_USD_metric|percent_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_money_USD_price|figure_money_USD_price|mil_figure_money_USD_metric|figure_USD_metric|percent_USD_metric
new_adrs_0322_0670|MPTYY||4|4|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|yearly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly
new_adrs_0322_0670|MPTYY||5|5|91.3333333333|91.3333333333|91.2727272727|91.3333333333|91.3333333333|91.3333333333|91.3333333333|91.3333333333|0|91.3333333333|91.3448275862|91.3043478261|0|0|0|0|0|0|0|0|91.3333333333|0|0|0|91.3333333333|91.3333333333|91.3448275862|91.2962962963|0|0|0|91.2962962963|0|91.3333333333|198|91.3333333333|128.7|365.25|91.3333333333|91.2962962963|91.3333333333|91.3333333333|91.3214285714|91.2962962963|91.2962962963|91.2962962963|91.36|0|91.3333333333|91.2962962963|91.2962962963|91.3333333333|91.3333333333|91.3333333333|0|0|0|0|0
new_adrs_0322_0670|MPTYY||6|6|30|30|22|30|30|30|30|30|0|30|29|23|0|0|0|0|0|0|0|0|30|0|0|0|30|30|29|27|0|0|0|27|0|30|13|30|20|4|30|27|30|30|28|27|27|27|25|0|30|27|27|30|30|30|0|0|0|0|0
new_adrs_0322_0670|MPTYY||7|7|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|quarterly|daily|quarterly|daily|daily|daily|daily|quarterly|daily|quarterly|daily|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|monthly|quarterly|monthly|quarterly|yearly|quarterly|daily|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|market_daily|market_daily|daily|market_daily|market_daily
new_adrs_0322_0670|MPTYY|201403|201403|201403|15.3142|15.0666||0.0316|0.088|1326.6873|44.8781|1281.8092||1034.0178|||||||||||1.1354||||0.2476|2.6406||||||||85.1457||0.0933|||170.2914||0.3412|0.0982|||||||31.3048|||8.6763|7.942|-7.694|||||
new_adrs_0322_0670|MPTYY|201406|201406|201406|1706.1936|1706.0831||0.0027||39.562|39.562|0||1666.6343|-0.0478||||||||||0||||0.1105|39.5606|170.6194|||||||70.9604|11|-0.0007|70.9604||141.9208||43.1271|-0.0007|-1674.7953|||||||||-0.048|-0.048||||||
new_adrs_0322_0670|MPTYY|201409|201409|201409|265.1316|262.51||0.9796|0.1967|1197.1437|53.7747|1143.369||1634.6693|36.8755||||||||||0.6407||||2.6215|10.2781|163.9571|||||||73.3163||0.5259|73.3163||146.6326||4.9304|0.5259|||||||34.288|||38.5871|38.5593|-10.3409|||||
new_adrs_0322_0670|MPTYY|201412|201412|201412|188.8516|184.6417||1.0871|0.1812|1347.5472|41.8481|1305.699||1591.3798|60.3997||||||||||0.7525||||4.0615|27.6547|157.1244|3.0899||||4.8723||73.3163|20|0.3511|73.3163||146.6326|0|4.5092|0.3511||2.7446|4.8723|72.1919|||38.3951|32.7088|0.0225|27.0138|25.7387|-12.8375|||||
new_adrs_0322_0670|MPTYY|201503|201503|201503|299.3851|296.9735||1.0483|0.1549|1397.6382|29.8626|1367.7756||1412.0107|21.2241||||||||||0.9625||||2.4117|14.4169|139.9263|3.5638||||5.8841||65.33||0.3385|73.3163||146.6326|0|10.0254|0.3391||4.7034|5.8841|86.3637|||36.3067|35.4954||25.0733|22.1137|-8.4623|||||
new_adrs_0322_0670|MPTYY|201506|201506|201506|455.0275|448.8419||1.0779|0.1537|1404.6279|33.1108|1371.5172||2290.2208|134.1232||||||||||0.5698||||6.1004|14.0929|217.3863|7.2905||||11.4544||109.9745|7|1.0047|109.9745||219.9489|0|13.74|1.1333|-658.8986|3.9493|11.4544|196.8998|145.3676||36.3778|35.4528||114.3216|110.4881|-7.3354|||||
new_adrs_0322_0670|MPTYY|201509|201509|201509|944.71|633.2232||1.0656|388.9591|4442.0814|1188.5589|3253.5226||3127.6273|-146.6372||||||||||1.1357||||18.1315|406.025|363.4734|-3.2237||||-5.9361||161.515||-1.7195|161.515||323.03|0|0.548|0.3356||-5.5715|-5.9361|-119.3856|193.6251||82.5456|77.24||-280.4622|-277.7261|-19.6451|||||
new_adrs_0322_0670|MPTYY|201512|201512|201512|974.1828|617.8271|0|1.1545|211.4847|4362.2747|2437.4074|1924.8673||3198.2731|53.657|0|||||||||1.0054||||26.659|388.866|353.1687|1.1497||||2.2015||161.515|20|1.2153|161.515||323.03|0|0.2644|-0.4403||15.291|2.2015|51.1603|237.3505||82.1205|77.8469||201.2825|196.2846|-23.8311|||||
new_adrs_0322_0670|MPTYY|201603|201603|201603|893.5559|520.594||0.51|300.1828|4570.8933|617.0381|3953.8552||3317.5085|51.2684||||||||||1.0969||||36.4184|397.9847|366.0996|1.4943||||2.9579||161.5607||0.3089|161.515||323.03|0|0.9027|0.3685||7.8702|2.9579|78.9507|285.7872||84.7433|79.4117||50.4127|49.9041|-13.7852|||||
new_adrs_0322_0670|MPTYY|201606|201606|201606|522.4372|162.2125||0.6496|88.084|4150.7279|255.0952|3895.6327||3386.5892|234.8628||||||||||0.9702||||22.2068|36.7829|359.3192|2.5709||||5.0202||161.515|118|1.1524|161.515|0|323.03|1.3327|0.7229|1.258|0|8.2128|5.088|155.8993|337.384||87.9746|83.6148||198.5028|187.4367|-28.563|||||
new_adrs_0322_0670|MPTYY|201609|201609|201609|768.5271|407.7843||0.6114|167.2072|4441.3311|295.5133|4145.8178||3448.8397|285.9874|1.5359|||||||||1.1123||||25.1324|42.2534|362.4009|7.0931||||14.5765||161.515||0.3025|161.515||323.03|0.4306|1.465|0.5916||3.0493|14.6395|482.4837|338.3769||83.5385|78.3306||48.4353|48.8583|-7.8664|||||
new_adrs_0322_0670|MPTYY|201612|201612|201612|887.6867|349.3332|3.1059|3.773|12.9238|6425.2187|220.1187|6205.1||5094.9382|615.949|0.111|||||||||1.043||||534.8109|146.941|496.6231|8.4707||||17.2848||235.7192|4|1.5053|234.8803||469.7605|0.3248|4.0167|0.8077||1.7078|17.3412|639.7554|387.9924||131.7361|124.8468||353.6642|353.5563|-48.2823|||||
new_adrs_0322_0670|MPTYY|201703|201703|201703|730.4456|667.1234||4.0372|274.4943|6463.0458|353.1287|6109.9171||5230.4493|71.1156|0.1122|||||||||1.0905||||62.6286|115.443|502.0067|7.8093||||16.0821||237.6821||0.2983|||469.7605|0.3144|2.0665|0.2858||1.708|16.1328|660.7466|426.0681||122.819|113.4883|2.7505|72.05|70.8953|-26.8972|||||
new_adrs_0322_0670|MPTYY|201706|201706|201706|610.9246|543.4024|3.9443|4.4534|1.6427|6944.4822|338.8488|6605.6335||5868.355|482.054|40.6076|||||||||0.9843||||59.478|126.3436|537.3898|9.185||||17.6229||233.2303|148|1.6724|233.2303|-38.9417|466.4605|6.0266|1.7792|1.6975|38.9417|1.4875|18.7531|863.7361|467.9954||129.9018|119.1731|2.1994|403.384|390.4262|-38.0285|||||
new_adrs_0322_0670|MPTYY|201709|201709|201709|973.669|847.81||20.3855|289.0784|7506.7835|333.9256|7172.8579||6106.7603|559.9956|41.8195|||||||||1.0876||||119.2559|74.2073|553.4278|8.2678||||16.044||236.9085||0.2586|||466.4605|5.9266|2.8961|0.3527||0.3565|17.0548|878.2993|524.2389||139.7819|129.3236||53.056|63.4215|-22.3169|||||
new_adrs_0322_0670|MPTYY|201712|201712|201712|737.3092|621.7505|2.3958|4.6536|0.7006|7535.6228|329.0381|7206.5847||6859.4755|1320.1715|29.8497|||||||||0.922||||102.0837|80.4447|563.5843|10.6812||||20.7266||233.7253|155|3.1494|233.7253||467.4505|4.1285|2.1998|3.0445||1.1199|21.6191|1260.8261|523.2595||130.7567|121.1498||746.6897|736.0831|-50.964|||||
new_adrs_0322_0670|MPTYY|201803|201803|201803|580.289|454.4371||4.5284|296.6567|7586.7414|189.6397|7397.1016||7185.4633|140.7331|15.1326|||||||||0.9286||||116.1392|73.7878|579.1807|10.649||||20.4494||237.8104||0.5897|||467.4505|3.9133|3.0087|0.3397||1.0435|21.2822|1330.1615|549.3221||148.8817|134.447|2.6191|140.8867|140.2307|-35.3276|||||
new_adrs_0322_0670|MPTYY|201806|201806|201806|368.5049|241.8757|2.302|4.0965|1.3308|7078.3407|161.5468|6916.7939||7009.3832|529.0921|14.1913|||||||||0.8671||||111.0147|62.0989|543.1539|10.6529||||20.6588||234.3131|168|1.8627|234.3131|0|468.6261|0.835|2.1844|2.2777|0|1.0577|20.8327|1376.1865|660.9449||241.5246|230.7449|0.9648|450.6147|436.4512|-44.0571|||||
new_adrs_0322_0670|MPTYY|201809|201809|201809|745.5148|298.4795||4.0217|275.846|7644.3855|191.1583|7453.2272||7093.2454|559.84|14.2624|||||||||0.9407||||66.105|67.5261|545.8739|10.061||||19.4217||239.3678||0.1163|||468.6261|0.8563|1.9072|0.097||1.9181|19.5894|1342.0458|576.3979||55.2349|39.962||30.6587|29.2808|-27.625|||||
new_adrs_0322_0670|MPTYY|201812|201812|201812|409.7816|195.8014|1.4711|3.7371|1.0764|7058.8479|201.9578|6856.8901||7323.0602|977.8949|78.1535|||||||||0.8113||||191.5815|96.8689|537.371|7.4812||||14.0091||231.8104|176|1.7228|231.8104||463.6207|1.1431|1.9181|2.0027||6.2477|14.1711|1005.3157|696.0336||250.3924|241.4519||450.1995|399.353|-29.1844|||||
new_adrs_0322_0670|MPTYY|201903|201903|201903|339.1314|205.4832||4.3224|1.0466|6997.4119|228.7304|6768.6815||7296.4409|-105.0252|63.1497|||||||||0.8315||||120.3845|97.6561|527.5528|6.9354||||12.8366||231.1423||0.2953|||463.6207|1.2312|1.4247|0.3228||6.8269|12.9966|933.3512|696.7669||149.615|135.5238|0|70.2564|68.2662|-34.6608|||||
new_adrs_0322_0670|MPTYY|201906|201906|201906|253.9558|105.9184|0.5708|10.5548|0.8221|7158.0938|188.8057|6969.2881||7370.7287|297.8997|64.6566|||||||||0.8033||||129.1496|104.2731|534.1296|5.424||||8.56||233.0733||0.9661|232.3466|-0.7111|464.6933|14.6211|1.245|1.0521|0.7111|8.3208|10.0258|723.723|593.0743||137.8319|124.1984||237.3369|226.823|-22.2051|||||
new_adrs_0322_0670|MPTYY|201909|201909|201909|300.5952|239.7239||10.5045|0.6871|6975.2923|188.6589|6786.6334||7137.7924|345.9796|62.2105|||||||||0.8458||||39.4981|92.4635|513.9765|5.6495||||8.9576||243.7463||0.2446|||464.6933|14.0204|1.48|0.2879||7.6451|10.4183|754.7282|694.0372||156.1978|144.7117||58.2501|60.286|-35.9183|||||
new_adrs_0322_0670|MPTYY|201912|201912|201912|350.3007|293.1922|0.2476|13.0869|0.8928|7389.7962|239.7197|7150.0765||7514.8845|631.3715|63.6929|||||||||0.8194||||33.8997|163.2984|526.2234|4.7181||||7.1437||232.3467|218|1.1791|232.3467||464.6934|16.8137|1.3645|1.1833||4.5744|8.5876|629.3459|576.4953||132.8506|118.5561||293.6711|273.9707|-36.5374|||||
new_adrs_0322_0670|MPTYY|202003|202003|202003|1230.9362|10.9125||13.125|0.9408|8191.0071|220.7667|7970.2404||7431.7719|42.6066|62.786|||||||||0.9773||||50.7033|113.8422|518.1292|4.4309||||6.7738||241.4375||0.1766|||464.6934|17.5277|0.2791|0.2961||4.6692|8.2134|603.7095|570.757||143.8767|132.0853|2.7655|44.0203|42.6299|-36.0472|||||
new_adrs_0322_0670|MPTYY|202006|202006|202006|1191.2741|1133.267|0.3138|21.822|0.9481|8383.4319|247.6343|8135.7975||7538.1547|79.7886|62.6295|||||||||0.9415||||40.0922|168.2596|528.3374|2.9687||||5.575||232.3984|221|0.1531|232.3984|-0.0441|464.7969|0|4.7383|0.2585|0.0441|3.8261|5.575|412.4746|535.9535||103.0285|91.1551|1.4934|32.9427|35.5881|-41.4471|||||
new_adrs_0322_0670|MPTYY|202009|202009|202009|420.0563|318.0396||22.8552|1.0109|7957.8353|191.5733|7766.2621||7922.8099|131.2294|65.2091|||||||||0.883||||48.6221|86.72|551.5346|2.8126||||5.326||233.8449||0.2055|||464.7969|0|1.914|0.4906||4.4766|5.326|399.9364|563.2955||183.5398|171.3277|5.4202|48.0448|47.7478|-32.6181|||||
new_adrs_0322_0670|MPTYY|202012|202012|202012|511.485|319.3222|41.1249|8.7401|1.182|8340.7831|220.4826|8120.3005||8236.1406|69.3181|66.6011|||||||||0.8489||||129.3118|138.3065|577.7995|0.4094||||0.7749||232.4671|218|-0.2862|232.4671||464.9342|0|2.0348|-0.5116||-1.3342|0.7749|59.8918|508.2463||77.8014|61.6516|-0.242|-65.9046|-66.0739|-57.3188|||||
new_adrs_0322_0670|MPTYY|202103|202103|202103|575.9812|462.5938||8.1603|1.2743|7927.7729|214.0484|7713.7245||7924.9078|65.3247|39.2213|||||||||0.8811||||38.2483|104.0443|550.7078|0.5674||||1.0807||232.1833||0.2892|||464.9342|0|2.3399|0.3356||-1.8884|1.0807|84.4104|514.4728||150.1031|136.3033|3.3933|67.763|67.1485|-38.4823|||||
new_adrs_0322_0670|MPTYY|202106|202106|202106|1114.4036|996.8167|43.8336|8.8217|1.2424|8598.5522|848.326|7750.2263||8043.8602|226.5055|38.4487|||||||||0.9148||||46.053|103.5493|559.0416|1.4053||||2.6604||233.7245|222|0.695|233.4424||466.8848|0|1.2293|0.5302|-0.006|-0.3393|2.6604|211.0542|529.2037||117.7594|105.9282|2.6225|160.4373|162.2318|-40.5869|||||
new_adrs_0322_0670|MPTYY|202109|202109|202109|1128.0155|1018.6277||9.2699|1.5508|8393.8576|847.249|7546.6087||7920.666|295.0217|37.4706|||||||||0.9419||||48.8422|102.9516|544.8874|1.5743||||2.9812||240.6227||0.3066|||466.8848|0|1.2599|0.4637||0.0774|2.9812|238.7837|526.2319||180.5679|163.3619|5.7326|76.6729|75.4774|-24.9701|||||