- - File : fundamentals_200606.xls
м ҽ, ڷԴϴ.
(ũ ÷ΰ ȵ αױۿ ÷ ҽϴ. URL ÷θ ص .)
http://blog.naver.com/neobundy/130008657559
(ġ ǥ Ÿ ʿ ÷ ϸ ŵ ˴ϴ.)
Ǯ ҽ ϰ Բ data 丮 ȿ MySQL dump (data.sql) ϴ.
ʿ信 ó ֽϴ.
MySQL Python Ϲ
data 丮ȿ ִ ϵ ȰϽø ˴ϴ. FnGuide.com 2005 ~ 2006 2/4б Ÿ Ե ֽϴ.
Ư, fundamentals_200606.xls ( ۿ ÷) ںм⸦ ݴŻ (2006 2/4б Ÿ 2005 2006 9 8 )̸ PBR ROE ̾ ǥְ ް ֽϴ. , ̿ ٸ ǥ ֽϴ,
ǥְ 꿡 http://blog.naver.com/neobundy/130008061534 ֽϴ. § ǥְ ø ˴ϴ.
MySQL ִ
MySQL 5.0 ̻ ġϰ data/data.sql MySQL Administrator import ϸ stocks Ÿ̽ ؿ stored procedures/functions ϴ. , 20051/4б 2006 2/4б Ÿ 2004/2005 Ÿ, Ÿ, 2006 9 8 Ÿ import ˴ϴ.
stored procedures functions ҽ Ⱦ Ȱ ̴ϴ.
:
select getPBR('A015750') -> PBR ( ڵ 'A015750' ̾. )
call ListMarketFundamentals() -> ü ݴŻ ǥ(fundamentals_200606.xls )
select * from market_fundamentals order by discount_ratio desc -> call ListMarketFundamentals() ̾Ƴ ǥ market_fundamentals ̺ Ʈ ϹǷ ǥε ̾ƺ
call addToPortfoilo('A015750') -> Ʈ
call deleteFromPortfoilo('A015750') -> Ʈ
call ListPortfolioFundamentals() -> Ʈ ݴŻ ǥ ̾ƺ
...
MySQL Python/wxPython ִ α
Python ҽ Ÿ Ʈ θ ϰ Ÿ ӽ 丮 ⺻ (COM ) Ȱմϴ.
ҽ db ڸ ȣ 'root', '1234' ִµ ڿ ° ؾ մϴ.
ҽ Ÿ FnGuide.com б⺰ ǥϴ ڷḦ 'б' Ÿ ణ ؾ . Ÿ İ ƾ . (: 200606_quarterly_report.xls 2006 2/4б Ÿ̹Ƿ ̿ Ȱ 200609_quarterly_report.xls 3/4б Ÿ import .)
cwkCompanyImporter.py -> data/companies.xls ( ⺻ )
cwkQuarterlyReportImporter.py -> data/606_quarterly_report.xls ( б )
cwkStockQuoteGetter.py -> data/stock_quotes.xls ( )
cwkStockImporter.py -> data/60630_ðѾ.xls (ֽļ )
cwkDividendImporter.py -> data/5_dividends.xls ( )
cwkMarketCapFileStockCodeGetter.py -> ڵ/ Ī
cwkExportTool.py -> export ҽ ø
밳 б⺰ б ϰ , ǥ ϴ Ʈ ʿ.
Ÿ ̹ ü Ȩ Խ Ľ. Ʈũ (timeout) 5ȸ õ.
ȵ ҽ... ̼ GPL :-)
м Ư¡
- б 4б Ÿ ȯϿ ǥ (: ListQuarterFundamentals() ֱ б Ÿ 1б ǥ )
- Ÿ ǥ Ȯ . ⺻ ϰ ۾ ʿ.
- ǥְ ROE PBR 3ġ ̾ . 23% ROE 3Ⱓ Ѵٴ Ͽ PBR 1 ؿ 3ġ ̾ 9500.
ǥְ (getTargetPrice() stored function ҽ Ϻ):
SET target_price = bps;
my_loop: REPEAT
IF years >= num_years THEN
LEAVE my_loop;
END IF;
SET target_price = target_price + (roe * target_price);
SET years = years + 1;
UNTIL years >= num_years
END REPEAT my_loop;
- ̳ պ, . : SP
- Ͻ ROE ǥ ְ . :
ڼ м Ʈ
ںм Ʈ 1: http://blog.naver.com/neobundy/130007774974
ںм Ʈ 2: http://blog.naver.com/neobundy/130007872168
ںм Ʈ 3: http://blog.naver.com/neobundy/130007912077
ںм Ʈ 4: http://blog.naver.com/neobundy/130008004920
ںм Ʈ 5: http://blog.naver.com/neobundy/130008243589
и Ÿ , ֽϴ. Ѵް Ʈ Ȱ 1 ϴ ū ϴ. , ĵ ʿϰ ۾ ̰ ʿմϴ.
Ư, ġ ǥ 꿡 ǥְ ڽ Ͼ ϴ.
(м ڷḦ Ʈ ߴµ... ٽ ú ְ ̵ ö^^)
Ÿ ... ¿ κ̰ FnGuide.com ְ ʴ ̻ (ϸ ᰡ ...) ... ֽ߰ô е ø ڽϴ^^ ¼ҽ αӱ ° ֵ ϳ :-)
ģȭ м Ͻ ... ׳ 鶧 ǵ ϰ ϴ. α ϴ ̶....
ѱſ ʹ ĵؼ ͽƮ ϴٸ,
Ͱ ǹ մϴ. 5 ̻ Ͱ ־ мٿ м
... ;;
ٵ Ƹ ڷ . 3 鼭 ڷ ٿ ƺýϴ. 3 ... .
3 Դϴ. Ϻδ ٿε尡 ȵ, ʼ ڷ κ ٿε ϴ.
http://sm.krx.co.kr/webkor/sang/sang_index.jsp?url=/webkor/sang/fn/corp/sn_fn_corp_stat01.jsp
ܰ ΰ! ϴ ھ! raw öǿ ??(Դϴ)
ؾϰڽϴ ̤
ڷ ҽϴ. ڷ fundamental ôµ
Ȥ sp,ǰ per,pbr ġ ϱ
ΰͷ Ѱ ݿ ʰ °
ƴѰ ñ մϴ.
raw Ÿ ġ ʾ ̳ / ġ ְ ֽϴ. 1 Ҹ Ѵٰ 帰 ̴ϴ :-)