dp7db
1. industry33 select_industry33
2. industry17 (deprecated)
3. market select_market
4. meigara select_meigara,
select_company
[mupdate_meigara.s (download_meigara, reinsert_meigara) |
AM dupdate_company.s (scrape_meigara_company, update_meigara_company, update_meigara_company_industry33)]
5. meigara_details select_meigara_details
[mupdate_meigaradetails.s (scrape_megara_details, reinsert_meigara_details) |
dupdate_company.s (scrape_meigara_company_details, update_meigara_company_details)]
6. edinet (deprecated)
7. fund (deprecated)
8. theme select_theme
[mupdate_meigaradetails.s (scrape_theme) |
AM dupdate_theme.s (extract_theme, reinsert_theme, extract_theme_recent, update_theme_recent, update_theme_custom, update_themedic)]
9. theme_custom select_theme_custom
10. relastats select_relastats [PM dupdate_relastats.s (r1->industry33, r2->theme, r3->market, r4->topix, r5->per, r6->pbr, r7->yield, r8->mratio, r9->mvalue, r10->taishaku, r11->rstrength, r12->settlement, r13->continuity, r14->atratio, r15->vratio, r16->ma5dratio, r17->ma10dratio, r18->ma25dratio, r19->ma50dratio, r20->ma75dratio, r21->mrstrength, r22->news, r23->gratio, r24->volaratio)]
dp7db_price
1. companyprice select_companyprice [ydatareader_ondemand.p (ydatareader_insert_companyprice | ydatareader_update_companyprice_one) | PM dupdate_price.s (scrape_companyprice, update_companyprice)]
2. companyprice_etc select_companyprice_etc [dupdate_price.s (update_companyprice_etc_other)]
3. wwindex select_wwindex [ydatareader_wwindex.py (datareader_wwindex, reinsert_wwindex) | AM dupdate_wwindexy.s (datareader_wwindex_y, update_wwindex_y) | PM dupdate_wwindexk.s (scrape_wwindex_k, update_wwindex_k)]
4. fundprice (deprecated)
5. stocksplit select_stocksplit [AM dupdate_stocksplit.s (scrape_stocksplit_s, update_stocksplit_s, update_companyprice_onstocksplit)]
dp7db_wide
1. meigaranews select_meigaranews [AMPM dupdate_news_k.s (scrape_meigaranews_k, update_meigaranews_k)]
2. newsdic select_newsdic
3. newstrend select_newstrend
relations
1. r1_industry view_industry33
| r2_theme view_theme
| r3_market view_market
| r4_topix view_topix
| r5_per view_per
| r6_pbr view_pbr
| r7_yield view_yield
| r8_mratio view_mratio
| r9_mvalue view_mvalue
| r10_taishaku view_taishaku
| r11_rstrength view_rstrength
| r12_settlement view_settlement
| r13_continuity view_continuity
| r14_atratio view_atratio
| r15_vratio view_vratio
| r16_ma5dratio view_ma5dratio
| r17_ma10dratio view_ma10dratio
| r18_ma25dratio view_ma25dratio
| r19_ma50dratio view_ma50dratio
| r20_ma75dratio view_ma75dratio
| r21_mrstrength view_mrstrength
| r22_news view_news
| r23_gratio view_gratio
| r24_volaratio view_volaratio
units
1. search relations by code
| relacompany by relations
| relacompany by codes
| correlation by codes
| rcorrelation by relations
| similarity by code
| settled15 by codes
2. explore go
3. predict
4. qa go
maintain
0. ps
| stop
1. daily auto
2. daily am
| daily pm
| daily news
| daily pm_tc