2013年1月12日 星期六

近一個月營收創新高公司的預期報酬率 Kn


Postgres 的 script 放在 stocktotal / db / postgres / stock_selector / expected_roe_over_latest_max_income.sql

因為加兩個 functions，所以 stocktotal / db / postgres / pg_dump.sql 也要更新一下


以上是 SQL script，以下是 query 結果 (按股號排序)
"1210";0.0605627453033925
"1215";0.0800776004952533
"1507";0.0663508481500958
"1536";0.103687799545484
"1565";0.0511535448465225
"1722";0.0343416735945364
"1788";0.0510050206123058
"1806";-0.0520584916456912
"2013";0.0818022916666667
"2317";0.0665286752828048
"2385";0.0686123616149282
"2412";0.057195418155567
"2505";0.0174775176336624
"2547";0.00721560929724184
"2640";0.0596053286770349
"2913";0.0448573332963362
"3004";0.095688205633275
"3008";0.0368762951546661
"3029";0.0640376930725047
"3045";0.0406168188699766
"3064";-0.0112086480042224
"3115";0.00159786501649073
"3205";0.00456786019328507
"3498";-0.0875314420461447
"3508";0.0412508816188126
"3587";0.0774725891297323
"3662";0.0117171687105931
"3680";0.0399297146177326
"4114";0.0237935868253256
"4123";-0.00576687276900821
"4432";0.0880231559290383
"4703";0.150930603929043
"4801";0.0937325332258138
"4904";0.0459674562753729
"4927";0.169793914973342
"4938";0.069445911631009
"5309";-0.0405454166222402
"5355";0.0434891676145268
"5534";0.157399415495708
"5536";0.050054232201346
"5703";0.0244453153662799
"6177";0.111035056202138
"6245";0.0916793253700497
"8416";0.0820323372290338
"9908";0.0597673801470013
"9911";0.0490525797713844
"9917";0.065048305158048
"9926";0.0496043187180656

按Kn排:
"4927";0.169793914973342
"5534";0.157399415495708
"4703";0.150930603929043
"6177";0.111035056202138
"1536";0.103687799545484
"3004";0.095688205633275
"4801";0.0937325332258138
"6245";0.0916793253700497
"4432";0.0880231559290383
"8416";0.0820323372290338
"2013";0.0818022916666667
"1215";0.0800776004952533
"3587";0.0774725891297323
"4938";0.069445911631009
"2385";0.0686123616149282
"2317";0.0665286752828048
"1507";0.0663508481500958
"9917";0.065048305158048
"3029";0.0640376930725047
"1210";0.0605627453033925
"9908";0.0597673801470013
"2640";0.0596053286770349
"2412";0.057195418155567
"1565";0.0511535448465225
"1788";0.0510050206123058
"5536";0.050054232201346
"9926";0.0496043187180656
"9911";0.0490525797713844
"4904";0.0459674562753729
"2913";0.0448573332963362
"5355";0.0434891676145268
"3508";0.0412508816188126
"3045";0.0406168188699766
"3680";0.0399297146177326
"3008";0.0368762951546661
"1722";0.0343416735945364
"5703";0.0244453153662799
"4114";0.0237935868253256
"2505";0.0174775176336624
"3662";0.0117171687105931
"2547";0.00721560929724184
"3205";0.00456786019328507
"3115";0.00159786501649073
"4123";-0.00576687276900821
"3064";-0.0112086480042224
"5309";-0.0405454166222402
"1806";-0.0520584916456912
"3498";-0.0875314420461447

張貼者： 於

沒有留言:

張貼留言

訂閱： 張貼留言 (Atom)