pinktest_usa_2417|MWTCY|Short Name|pe_ratio|enterprise_value|cash_on_hand|average_volume_30|price|ps_ratio|dividend_yield||||||price_next_month|price_second_month pinktest_usa_2417|MWTCY|Long Name|Manila Water Co Inc (MWTCY) PE Ratio|Manila Water Co Inc (MWTCY) Enterprise Value (USD)|Manila Water Co Inc (MWTCY) Cash and Short Term Investments (Quarterly) (USD)|Manila Water Co Inc (MWTCY) 30-Day Average Daily Volume|Manila Water Co Inc (MWTCY) Price (USD)|Manila Water Co Inc (MWTCY) PS Ratio|Manila Water Co Inc (MWTCY) Dividend Yield||||||| pinktest_usa_2417|MWTCY|Unit|figure_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_USD_metric|figure_money_USD_price|figure_USD_metric|percent_USD_metric||||||| pinktest_usa_2417|MWTCY|200912|||167.1215||||||||||| pinktest_usa_2417|MWTCY|201003|||167.5357||||||||||| pinktest_usa_2417|MWTCY|201006|||130.5357||||||||||| pinktest_usa_2417|MWTCY|201009|||117.7866||||||||||| pinktest_usa_2417|MWTCY|201012|||90.6273||||||||||| pinktest_usa_2417|MWTCY|201103|||147.7129||||||||||| pinktest_usa_2417|MWTCY|201106|||361.0223||||||||||| pinktest_usa_2417|MWTCY|201109|||363.1913||||||||||| pinktest_usa_2417|MWTCY|201112|||134.4226||||||||||| pinktest_usa_2417|MWTCY||||149.8701||||||||||8|8 pinktest_usa_2417|MWTCY|201206||1744.9928|171.0915|25.1667|14||0||||||14|14 pinktest_usa_2417|MWTCY|201209||1978.5838|138.8763|137.9667|16.12||0||||||16.8|16.8 pinktest_usa_2417|MWTCY|201212||2381.9971|135.4013|2005|19.78||0||||||19.8|19.8 pinktest_usa_2417|MWTCY|201303||2691.8204|154.7632|1817.2333|23.1||0||||||24.72|24.72 pinktest_usa_2417|MWTCY|201306||2078.4814|112.3444|83.3333|16.9||0||||||16.9|16.9 pinktest_usa_2417|MWTCY|201309||2034.9872|238.4335|29.8|16.32||0||||||16.29|16.29 pinktest_usa_2417|MWTCY|201312||1709.7578|154.874|93.1333|13.19||0||||||12.93|12.93 pinktest_usa_2417|MWTCY|201403||1755.118|173.2023|179.1667|13.42||1.6846||||||13.42|13.42 pinktest_usa_2417|MWTCY|201406||1889.414|169.4254|181.8|14.73||1.5348||||||14.73|14.73 pinktest_usa_2417|MWTCY|201409||2023.6589|181.927|50|16.49||1.371||||||16.49|16.49 pinktest_usa_2417|MWTCY||||144.0855||||||||||18|18 pinktest_usa_2417|MWTCY|201503||1956.7611|140.6139|39.8667|15.75||3.1938||||||15.4|15.4 pinktest_usa_2417|MWTCY|201506||1891.9933|132.3143|32.2667|15.08||3.3356||||||13.13|13.13 pinktest_usa_2417|MWTCY|201509|7.9816|1414.3438|158.9622|31.7|10.21|2.8473|7.0534||||||| pinktest_usa_2417|MWTCY|201512|||145.9726|||2.8336|||||||| pinktest_usa_2417|MWTCY|201603|||256.7807|||2.7349|||||||| pinktest_usa_2417|MWTCY||||154.0523|||2.7198|||||||14.36|14.36 pinktest_usa_2417|MWTCY|201609|11.6541|1997.4455|154.7214|84.1|15.65|4.2531|2.8207||||||15.65|15.65 pinktest_usa_2417|MWTCY|201612|9.9786|1776.6154|82.0052|30.3667|13.4|3.6416|3.2751||||||15.18|15.18 pinktest_usa_2417|MWTCY|201703|15.6846|1815.5273|79.4961|37.2333|15.95|4.0365|2.6679||||||15.95|15.95 pinktest_usa_2417|MWTCY|201706|15.2421|2026.5563|127.5429|50|15.5|3.9735|2.7454||||||15.95|15.95 pinktest_usa_2417|MWTCY|201709|15.2318|2039.1915|250.3148|8.7|15.43|3.9556|2.7578||||||14.45|14.45 pinktest_usa_2417|MWTCY|201712|12.5054|1934.4023|181.2267|16.8333|13.96|3.2561|2.9906||||||13.96|13.96 pinktest_usa_2417|MWTCY|201803|9.552|2110.2608|142.9869|23.3333|13.09|3.1594|3.1464||||||13.09|13.09 pinktest_usa_2417|MWTCY|201806|8.9756|2038.0765|148.081|26.6667|12.3|2.9687|3.3485||||||12.3|12.3 pinktest_usa_2417|MWTCY|201809|7.7788|1841.3701|216.3985|86.7333|10.67|2.5566|3.86||||||10.67|10.67 pinktest_usa_2417|MWTCY|201812|9.9953|1964.7408|178.7499|3.3333|12|3.1975|3.3885||||||12.97|12.97 pinktest_usa_2417|MWTCY|201903|9.9166|2060.9944|140.8051|23.3333|12.45|3.3129|3.3497||||||| pinktest_usa_2417|MWTCY||||123.3449|||3.2561|||||||12.1|12.1 pinktest_usa_2417|MWTCY||||114.3678|||3.0532|||||||9.905|9.905 pinktest_usa_2417|MWTCY|201912|3.083|1368.5801|178.494|27.2667|3.7|0.9336|11.8509||||||4.9|4.9 pinktest_usa_2417|MWTCY|202003|5.3187|1569.2362|253.4756|65.3333|6.14|1.324|7.1414||||||5.5|5.5 pinktest_usa_2417|MWTCY|202006|5.6949|1550.0854|358.6296|19.7667|6.16|1.3323|7.1182||||||6.16|6.16 pinktest_usa_2417|MWTCY|202009|6.4715|1731.4641|650.6836|13.3333|7|1.509|6.264||||||7.2|7.2 pinktest_usa_2417|MWTCY|202012|8.4671|1777.3738|434.2544|51.8333|7.55|1.6834|0||||||8.5|8.5 pinktest_usa_2417|MWTCY|202103|9.1256|1947.7745|373.0807|20.2|8.27|1.8439|0||||||7.61|7.61 pinktest_usa_2417|MWTCY|202106|8.1452|2095.1097|458.4562|12.8333|7.25|1.8366|0||||||9.0415|9.0415 pinktest_usa_2417|MWTCY|202109|9.2964|2207.5422|396.2351|13.3333|8.75|2.2166|0||||||8.75|8.75 pinktest_usa_2417|MWTCY|202112|18.754|2599.3036|264.8452|31.6667|11.87|3.3814|2.2359||||||11.87|11.87 pinktest_usa_2417|MWTCY||||163.4746|||3.5874|||||||9.05|9.05 pinktest_usa_2417|MWTCY|202206|13.5882|2201.1655|158.6732|7.5333|7.26|2.244|3.6557||||||7.26|7.26 pinktest_usa_2417|MWTCY||||175.5626|||1.8781|||||||8.83|8.83 pinktest_usa_2417|MWTCY|202212|13.4287|2408.8878|160.542|16.6667|8.82|2.4468|1.9385||||||8.82|8.82 pinktest_usa_2417|MWTCY|202303|10.917|2568.4894|170.5444|6.6667|8.95|2.4617|1.9103||||||8.95|8.95 pinktest_usa_2417|MWTCY|202306|8.7426|2478.0425|164.8432|115.3|8.11|1.9064|5.5485||||||8.11|8.11 pinktest_usa_2417|MWTCY|202309|8.2683|2420.2502|131.6027|10|7.67|1.803|5.8668||||||7.67|7.67 pinktest_usa_2417|MWTCY|202312|7.9988|2385.9349|193.9793|3.3333|8.114|1.9066|5.5458||||||8.1708|8.1708 pinktest_usa_2417|MWTCY|202403|14.4773|2690.3362|146.5743|23.3333|9|1.9627|8.6167||||||9|9 pinktest_usa_2417|MWTCY|202406|9.4852|2678.7113|136.8478|20|9|1.8395|8.6167||||||9|9 pinktest_usa_2417|MWTCY|202409|11.2093|3143.0424|152.2384|14|12.6|2.4192|6.1548||||||12.6|12.6 pinktest_usa_2417|MWTCY|202412|9.2538|3143.5278|127.4211|0|12|2.1526|6.4625||||||12|12 pinktest_usa_2417|MWTCY|202503|7.705|3156.6062|120.5754|0|12|2.0821|6.6755||||||12|12 pinktest_usa_2417|MWTCY|202506|8.7534|3512.2018||3.3333|14.05|2.4128|5.7015||||||14.05|14.05