Financial関数の一覧・例
- テスト用のインジケータ作成
- 使い方
- 【1 損益計算書(Income Statements)】
- 【2 貸借対照表(1/2)(Balance Sheet)】
- 【2 貸借対照表(2/2)(Balance Sheet)】
- 【3 キャッシュフロー(Cash Flow)】
- 【4 比率(1/2)(Ratios)】
- 【4 比率(2/2)(Ratios)】
テスト用のインジケータ作成
こんばんわ。 上記で紹介したfinancial関数ですが、いつもと違う日本語訳で紹介されているので(書いたの自分ですが)値が合っているか確認したくて、値を確認するためのインジケータを作成しました。
financial関数の書き方の参考例 + 値・単位の確認用としてどなたかの役に立てば嬉しいです。
使い方
数が多い(financial関数は一つのコードにつき40までしか使えない)ので、複数に分けてます。
必要なものだけ使ってもらえばと思います。
ラベルの左から、日本名(機械翻訳)、financial関数のid、呼び出された最新のFY(本決算)数値。
本決算数値を株探等の値と合致させ確認してみてください。
呼び出しには少し時間がかかりますのでその点注意ください。
この日本語訳はないわ。これに修正するべきだ!があれば教えていただけると助かります
【1 損益計算書(Income Statements)】
サンプル画像
コード
//@version=4 // finnancialデータを一覧で確認するスクリプト // 1 損益計算書(Income Statements) study("WR_FinancialDataList_to_IncomeStatements") // 登録一覧 AFTER_TAX_OTHER_INCOME_FY=financial(syminfo.tickerid,"AFTER_TAX_OTHER_INCOME", "FY") COST_OF_GOODS_FY=financial(syminfo.tickerid,"COST_OF_GOODS", "FY") DILUTED_NET_INCOME_FY=financial(syminfo.tickerid,"DILUTED_NET_INCOME", "FY") DILUTION_ADJUSTMENT_FY=financial(syminfo.tickerid,"DILUTION_ADJUSTMENT", "FY") DISCONTINUED_OPERATIONS_FY=financial(syminfo.tickerid,"DISCONTINUED_OPERATIONS", "FY") EARNINGS_PER_SHARE_BASIC_FY=financial(syminfo.tickerid,"EARNINGS_PER_SHARE_BASIC", "FY") EARNINGS_PER_SHARE_FY=financial(syminfo.tickerid,"EARNINGS_PER_SHARE", "FY") EBITDA_FY=financial(syminfo.tickerid,"EBITDA", "FY") EQUITY_IN_EARNINGS_FY=financial(syminfo.tickerid,"EQUITY_IN_EARNINGS", "FY") GROSS_PROFIT_FY=financial(syminfo.tickerid,"GROSS_PROFIT", "FY") INCOME_TAX_FY=financial(syminfo.tickerid,"INCOME_TAX", "FY") MINORITY_INTEREST_EXP_FY=financial(syminfo.tickerid,"MINORITY_INTEREST_EXP", "FY") NET_INCOME_BEF_DISC_OPER_FY=financial(syminfo.tickerid,"NET_INCOME_BEF_DISC_OPER", "FY") NET_INCOME_FY=financial(syminfo.tickerid,"NET_INCOME", "FY") OPER_INCOME_FY=financial(syminfo.tickerid,"OPER_INCOME", "FY") OPERATING_EXPENSES_FY=financial(syminfo.tickerid,"OPERATING_EXPENSES", "FY") OTHER_OPER_EXPENSE_TOTAL_FY=financial(syminfo.tickerid,"OTHER_OPER_EXPENSE_TOTAL", "FY") PRETAX_INCOME_FY=financial(syminfo.tickerid,"PRETAX_INCOME", "FY") RESEARCH_AND_DEV_FY=financial(syminfo.tickerid,"RESEARCH_AND_DEV", "FY") SELL_GEN_ADMIN_EXP_OTHER_FY=financial(syminfo.tickerid,"SELL_GEN_ADMIN_EXP_OTHER", "FY") SELL_GEN_ADMIN_EXP_TOTAL_FY=financial(syminfo.tickerid,"SELL_GEN_ADMIN_EXP_TOTAL", "FY") TOTAL_NON_OPER_INCOME_FY=financial(syminfo.tickerid,"TOTAL_NON_OPER_INCOME", "FY") TOTAL_OPER_EXPENSE_FY=financial(syminfo.tickerid,"TOTAL_OPER_EXPENSE", "FY") TOTAL_REVENUE_FY=financial(syminfo.tickerid,"TOTAL_REVENUE", "FY") //最後の足で描写処理 if (barstate.islast) financial_data_value = array.new_string(0) financial_data_description = array.new_string(0) // ------------- array.push(financial_data_description,"税引後 その他収支 AFTER_TAX_OTHER_INCOME") array.push(financial_data_description,"商品の原価 COST_OF_GOODS") array.push(financial_data_description,"潜在株式調整後1株当たり 当期純利益 DILUTED_NET_INCOME") array.push(financial_data_description,"希薄化調整 DILUTION_ADJUSTMENT") array.push(financial_data_description,"非継続事業 DISCONTINUED_OPERATIONS") array.push(financial_data_description,"基本EPS EARNINGS_PER_SHARE_BASIC") array.push(financial_data_description,"潜在株式調整後1株当たり 当期純利益 EARNINGS_PER_SHARE") array.push(financial_data_description,"EBITDA EBITDA") array.push(financial_data_description,"持分法による投資利益 EQUITY_IN_EARNINGS") array.push(financial_data_description,"売上総利益 GROSS_PROFIT") array.push(financial_data_description,"税金 INCOME_TAX") array.push(financial_data_description,"非支配/少数株主持分 MINORITY_INTEREST_EXP") array.push(financial_data_description,"非継続事業前の 当期純利益 NET_INCOME_BEF_DISC_OPER") array.push(financial_data_description,"当期純利益 NET_INCOME") array.push(financial_data_description,"営業利益 OPER_INCOME") array.push(financial_data_description,"営業費用(除くCOGS OPERATING_EXPENSES") array.push(financial_data_description,"その他の営業費用合計 OTHER_OPER_EXPENSE_TOTAL") array.push(financial_data_description,"税引前利益 PRETAX_INCOME") array.push(financial_data_description,"研究開発 RESEARCH_AND_DEV") array.push(financial_data_description,"販売費・ 一般管理費 、その他 SELL_GEN_ADMIN_EXP_OTHER") array.push(financial_data_description,"販売費及び 一般管理費 、合計 SELL_GEN_ADMIN_EXP_TOTAL") array.push(financial_data_description,"営業外収益 合計 TOTAL_NON_OPER_INCOME") array.push(financial_data_description,"営業費用合計 TOTAL_OPER_EXPENSE") array.push(financial_data_description,"総収入 TOTAL_REVENUE") // ------------- array.push(financial_data_value,tostring(AFTER_TAX_OTHER_INCOME_FY[0])) array.push(financial_data_value,tostring(COST_OF_GOODS_FY[0])) array.push(financial_data_value,tostring(DILUTED_NET_INCOME_FY[0])) array.push(financial_data_value,tostring(DILUTION_ADJUSTMENT_FY[0])) array.push(financial_data_value,tostring(DISCONTINUED_OPERATIONS_FY[0])) array.push(financial_data_value,tostring(EARNINGS_PER_SHARE_BASIC_FY[0])) array.push(financial_data_value,tostring(EARNINGS_PER_SHARE_FY[0])) array.push(financial_data_value,tostring(EBITDA_FY[0])) array.push(financial_data_value,tostring(EQUITY_IN_EARNINGS_FY[0])) array.push(financial_data_value,tostring(GROSS_PROFIT_FY[0])) array.push(financial_data_value,tostring(INCOME_TAX_FY[0])) array.push(financial_data_value,tostring(MINORITY_INTEREST_EXP_FY[0])) array.push(financial_data_value,tostring(NET_INCOME_BEF_DISC_OPER_FY[0])) array.push(financial_data_value,tostring(NET_INCOME_FY[0])) array.push(financial_data_value,tostring(OPER_INCOME_FY[0])) array.push(financial_data_value,tostring(OPERATING_EXPENSES_FY[0])) array.push(financial_data_value,tostring(OTHER_OPER_EXPENSE_TOTAL_FY[0])) array.push(financial_data_value,tostring(PRETAX_INCOME_FY[0])) array.push(financial_data_value,tostring(RESEARCH_AND_DEV_FY[0])) array.push(financial_data_value,tostring(SELL_GEN_ADMIN_EXP_OTHER_FY[0])) array.push(financial_data_value,tostring(SELL_GEN_ADMIN_EXP_TOTAL_FY[0])) array.push(financial_data_value,tostring(TOTAL_NON_OPER_INCOME_FY[0])) array.push(financial_data_value,tostring(TOTAL_OPER_EXPENSE_FY[0])) array.push(financial_data_value,tostring(TOTAL_REVENUE_FY[0])) var label_text = "【1 損益計算書(Income Statements)】\n" for i=0 to array.size(financial_data_value)-1 label_text := label_text + array.get(financial_data_description,i)+"\t\t:\t\t" label_text := label_text + array.get(financial_data_value,i)+"\n" var label l = na l := label.new( bar_index, 0, yloc=yloc.price, style=label.style_label_right, color=color.green,textcolor=color.white,textalign=text.align_left,size=size.large, text=label_text )
【2 貸借対照表(1/2)(Balance Sheet)】
サンプル画像
コード
//@version=4 // finnancialデータを一覧で確認するスクリプト // 2 貸借対照表(1/2)(Balance Sheet) study("WR_FinancialDataList_to_BalanceSheet_1") // 登録一覧 ACCOUNTS_PAYABLE_FY=financial(syminfo.tickerid,"ACCOUNTS_PAYABLE", "FY") ACCOUNTS_RECEIVABLES_NET_FY=financial(syminfo.tickerid,"ACCOUNTS_RECEIVABLES_NET", "FY") ACCRUED_PAYROLL_FY=financial(syminfo.tickerid,"ACCRUED_PAYROLL", "FY") ACCUM_DEPREC_TOTAL_FY=financial(syminfo.tickerid,"ACCUM_DEPREC_TOTAL", "FY") BOOK_VALUE_PER_SHARE_FY=financial(syminfo.tickerid,"BOOK_VALUE_PER_SHARE", "FY") CAPITAL_OPERATING_LEASE_OBLIGATIONS_FY=financial(syminfo.tickerid,"CAPITAL_OPERATING_LEASE_OBLIGATIONS", "FY") CASH_N_EQUIVALENTS_FY=financial(syminfo.tickerid,"CASH_N_EQUIVALENTS", "FY") CASH_N_SHORT_TERM_INVEST_FY=financial(syminfo.tickerid,"CASH_N_SHORT_TERM_INVEST", "FY") COMMON_EQUITY_TOTAL_FY=financial(syminfo.tickerid,"COMMON_EQUITY_TOTAL", "FY") CURRENT_PORT_DEBT_CAPITAL_LEASES_FY=financial(syminfo.tickerid,"CURRENT_PORT_DEBT_CAPITAL_LEASES", "FY") DEFERRED_INCOME_CURRENT_FY=financial(syminfo.tickerid,"DEFERRED_INCOME_CURRENT", "FY") DEFERRED_INCOME_NON_CURRENT_FY=financial(syminfo.tickerid,"DEFERRED_INCOME_NON_CURRENT", "FY") DEFERRED_TAX_ASSESTS_FY=financial(syminfo.tickerid,"DEFERRED_TAX_ASSESTS", "FY") DEFERRED_TAX_LIABILITIES_FY=financial(syminfo.tickerid,"DEFERRED_TAX_LIABILITIES", "FY") DIVIDENDS_PAYABLE_FY=financial(syminfo.tickerid,"DIVIDENDS_PAYABLE", "FY") GOODWILL_FY=financial(syminfo.tickerid,"GOODWILL", "FY") INCOME_TAX_PAYABLE_FY=financial(syminfo.tickerid,"INCOME_TAX_PAYABLE", "FY") INTANGIBLES_NET_FY=financial(syminfo.tickerid,"INTANGIBLES_NET", "FY") INVENTORY_FINISHED_GOODS_FY=financial(syminfo.tickerid,"INVENTORY_FINISHED_GOODS", "FY") INVENTORY_PROGRESS_PAYMENTS_FY=financial(syminfo.tickerid,"INVENTORY_PROGRESS_PAYMENTS", "FY") INVENTORY_RAW_MATERIALS_FY=financial(syminfo.tickerid,"INVENTORY_RAW_MATERIALS", "FY") INVENTORY_WORK_IN_PROGRESS_FY=financial(syminfo.tickerid,"INVENTORY_WORK_IN_PROGRESS", "FY") INVESTMENTS_IN_UNCONCSOLIDATE_FY=financial(syminfo.tickerid,"INVESTMENTS_IN_UNCONCSOLIDATE", "FY") LONG_TERM_DEBT_EXCL_CAPITAL_LEASE_FY=financial(syminfo.tickerid,"LONG_TERM_DEBT_EXCL_CAPITAL_LEASE", "FY") LONG_TERM_DEBT_FY=financial(syminfo.tickerid,"LONG_TERM_DEBT", "FY") LONG_TERM_INVESTMENTS_FY=financial(syminfo.tickerid,"LONG_TERM_INVESTMENTS", "FY") LONG_TERM_NOTE_RECEIVABLE_FY=financial(syminfo.tickerid,"LONG_TERM_NOTE_RECEIVABLE", "FY") LONG_TERM_OTHER_ASSETS_TOTAL_FY=financial(syminfo.tickerid,"LONG_TERM_OTHER_ASSETS_TOTAL", "FY") MINORITY_INTEREST_FY=financial(syminfo.tickerid,"MINORITY_INTEREST", "FY") OTHER_COMMON_EQUITY_FY=financial(syminfo.tickerid,"OTHER_COMMON_EQUITY", "FY") OTHER_CURRENT_ASSETS_TOTAL_FY=financial(syminfo.tickerid,"OTHER_CURRENT_ASSETS_TOTAL", "FY") OTHER_CURRENT_LIABILITIES_FY=financial(syminfo.tickerid,"OTHER_CURRENT_LIABILITIES", "FY") OTHER_INTANGIBLES_NET_FY=financial(syminfo.tickerid,"OTHER_INTANGIBLES_NET", "FY") OTHER_INVESTMENTS_FY=financial(syminfo.tickerid,"OTHER_INVESTMENTS", "FY") OTHER_LIABILITIES_TOTAL_FY=financial(syminfo.tickerid,"OTHER_LIABILITIES_TOTAL", "FY") OTHER_RECEIVABLES_FY=financial(syminfo.tickerid,"OTHER_RECEIVABLES", "FY") //最後の足で描写処理 if (barstate.islast) financial_data_value = array.new_string(0) financial_data_description = array.new_string(0) // ------------- array.push(financial_data_description,"買掛金 ACCOUNTS_PAYABLE") array.push(financial_data_description,"売掛金 -貿易、ネット ACCOUNTS_RECEIVABLES_NET") array.push(financial_data_description,"未払給与 ACCRUED_PAYROLL") array.push(financial_data_description,"減価償却 累計額合計 ACCUM_DEPREC_TOTAL") array.push(financial_data_description,"1株当たり純資産額 BOOK_VALUE_PER_SHARE") array.push(financial_data_description,"キャピタルリース債務及び オペレーティングリース 債務 CAPITAL_OPERATING_LEASE_OBLIGATIONS") array.push(financial_data_description,"現金及び 現金同等物 CASH_N_EQUIVALENTS") array.push(financial_data_description,"現金及び短期投資 CASH_N_SHORT_TERM_INVEST") array.push(financial_data_description,"資本金・総資産 COMMON_EQUITY_TOTAL") array.push(financial_data_description,"長期借入金・キャピタル・リース取引の 当座預金 残高 CURRENT_PORT_DEBT_CAPITAL_LEASES") array.push(financial_data_description,"繰延税金資産 DEFERRED_INCOME_CURRENT") array.push(financial_data_description,"繰延収益、非流動 DEFERRED_INCOME_NON_CURRENT") array.push(financial_data_description,"繰延税金資産 DEFERRED_TAX_ASSESTS") array.push(financial_data_description,"繰延税金負債 DEFERRED_TAX_LIABILITIES") array.push(financial_data_description,"配当金支払額 DIVIDENDS_PAYABLE") array.push(financial_data_description,"のれん・純額 GOODWILL") array.push(financial_data_description,"法人税 等の支払額 INCOME_TAX_PAYABLE") array.push(financial_data_description,"無形固定資産 INTANGIBLES_NET") array.push(financial_data_description,"棚卸資産 -完成品 INVENTORY_FINISHED_GOODS") array.push(financial_data_description,"たな卸資産-未払賃金・その他 INVENTORY_PROGRESS_PAYMENTS") array.push(financial_data_description,"棚卸資産 -原材料 INVENTORY_RAW_MATERIALS") array.push(financial_data_description,"棚卸資産 -仕掛品 INVENTORY_WORK_IN_PROGRESS") array.push(financial_data_description,"非 連結子会社 への投資 INVESTMENTS_IN_UNCONCSOLIDATE") array.push(financial_data_description,"リース債務を除く長期借入金 LONG_TERM_DEBT_EXCL_CAPITAL_LEASE") array.push(financial_data_description,"長期借入金 LONG_TERM_DEBT") array.push(financial_data_description,"長期投資 LONG_TERM_INVESTMENTS") array.push(financial_data_description,"長期 受取手形 LONG_TERM_NOTE_RECEIVABLE") array.push(financial_data_description,"その他の長期資産合計 LONG_TERM_OTHER_ASSETS_TOTAL") array.push(financial_data_description,"少数株主持分 MINORITY_INTEREST") array.push(financial_data_description,"その他の 普通株式 OTHER_COMMON_EQUITY") array.push(financial_data_description,"その他の 流動資産 合計 OTHER_CURRENT_ASSETS_TOTAL") array.push(financial_data_description,"その他の流動負債 OTHER_CURRENT_LIABILITIES") array.push(financial_data_description,"その他の無形固定資産 OTHER_INTANGIBLES_NET") array.push(financial_data_description,"その他の投資 OTHER_INVESTMENTS") array.push(financial_data_description,"その他の負債合計 OTHER_LIABILITIES_TOTAL") array.push(financial_data_description,"その他の債権 OTHER_RECEIVABLES") // ------------- array.push(financial_data_value,tostring(ACCOUNTS_PAYABLE_FY[0])) array.push(financial_data_value,tostring(ACCOUNTS_RECEIVABLES_NET_FY[0])) array.push(financial_data_value,tostring(ACCRUED_PAYROLL_FY[0])) array.push(financial_data_value,tostring(ACCUM_DEPREC_TOTAL_FY[0])) array.push(financial_data_value,tostring(BOOK_VALUE_PER_SHARE_FY[0])) array.push(financial_data_value,tostring(CAPITAL_OPERATING_LEASE_OBLIGATIONS_FY[0])) array.push(financial_data_value,tostring(CASH_N_EQUIVALENTS_FY[0])) array.push(financial_data_value,tostring(CASH_N_SHORT_TERM_INVEST_FY[0])) array.push(financial_data_value,tostring(COMMON_EQUITY_TOTAL_FY[0])) array.push(financial_data_value,tostring(CURRENT_PORT_DEBT_CAPITAL_LEASES_FY[0])) array.push(financial_data_value,tostring(DEFERRED_INCOME_CURRENT_FY[0])) array.push(financial_data_value,tostring(DEFERRED_INCOME_NON_CURRENT_FY[0])) array.push(financial_data_value,tostring(DEFERRED_TAX_ASSESTS_FY[0])) array.push(financial_data_value,tostring(DEFERRED_TAX_LIABILITIES_FY[0])) array.push(financial_data_value,tostring(DIVIDENDS_PAYABLE_FY[0])) array.push(financial_data_value,tostring(GOODWILL_FY[0])) array.push(financial_data_value,tostring(INCOME_TAX_PAYABLE_FY[0])) array.push(financial_data_value,tostring(INTANGIBLES_NET_FY[0])) array.push(financial_data_value,tostring(INVENTORY_FINISHED_GOODS_FY[0])) array.push(financial_data_value,tostring(INVENTORY_PROGRESS_PAYMENTS_FY[0])) array.push(financial_data_value,tostring(INVENTORY_RAW_MATERIALS_FY[0])) array.push(financial_data_value,tostring(INVENTORY_WORK_IN_PROGRESS_FY[0])) array.push(financial_data_value,tostring(INVESTMENTS_IN_UNCONCSOLIDATE_FY[0])) array.push(financial_data_value,tostring(LONG_TERM_DEBT_EXCL_CAPITAL_LEASE_FY[0])) array.push(financial_data_value,tostring(LONG_TERM_DEBT_FY[0])) array.push(financial_data_value,tostring(LONG_TERM_INVESTMENTS_FY[0])) array.push(financial_data_value,tostring(LONG_TERM_NOTE_RECEIVABLE_FY[0])) array.push(financial_data_value,tostring(LONG_TERM_OTHER_ASSETS_TOTAL_FY[0])) array.push(financial_data_value,tostring(MINORITY_INTEREST_FY[0])) array.push(financial_data_value,tostring(OTHER_COMMON_EQUITY_FY[0])) array.push(financial_data_value,tostring(OTHER_CURRENT_ASSETS_TOTAL_FY[0])) array.push(financial_data_value,tostring(OTHER_CURRENT_LIABILITIES_FY[0])) array.push(financial_data_value,tostring(OTHER_INTANGIBLES_NET_FY[0])) array.push(financial_data_value,tostring(OTHER_INVESTMENTS_FY[0])) array.push(financial_data_value,tostring(OTHER_LIABILITIES_TOTAL_FY[0])) array.push(financial_data_value,tostring(OTHER_RECEIVABLES_FY[0])) var label_text = " 【2 貸借対照表(1/2)(Balance Sheet)】\n" for i=0 to array.size(financial_data_value)-1 label_text := label_text + array.get(financial_data_description,i)+"\t\t:\t\t" label_text := label_text + array.get(financial_data_value,i)+"\n" var label l = na l := label.new( bar_index, 0, yloc=yloc.price, style=label.style_label_right, color=color.green,textcolor=color.white,textalign=text.align_left,size=size.large, text=label_text )
【2 貸借対照表(2/2)(Balance Sheet)】
サンプル画像
コード
//@version=4 // finnancialデータを一覧で確認するスクリプト // 2 貸借対照表(2/2)(Balance Sheet) study("WR_FinancialDataList_to_BalanceSheet_2") // 登録一覧 PAID_IN_CAPITAL_FY=financial(syminfo.tickerid,"PAID_IN_CAPITAL", "FY") PPE_TOTAL_GROSS_FY=financial(syminfo.tickerid,"PPE_TOTAL_GROSS", "FY") PPE_TOTAL_NET_FY=financial(syminfo.tickerid,"PPE_TOTAL_NET", "FY") PREFERRED_STOCK_CARRYING_VALUE_FY=financial(syminfo.tickerid,"PREFERRED_STOCK_CARRYING_VALUE", "FY") PREPAID_EXPENSES_FY=financial(syminfo.tickerid,"PREPAID_EXPENSES", "FY") PROVISION_F_RISKS_FY=financial(syminfo.tickerid,"PROVISION_F_RISKS", "FY") RETAINED_EARNINGS_FY=financial(syminfo.tickerid,"RETAINED_EARNINGS", "FY") SHORT_TERM_DEBT_EXCL_CURRENT_PORT_FY=financial(syminfo.tickerid,"SHORT_TERM_DEBT_EXCL_CURRENT_PORT", "FY") SHORT_TERM_DEBT_FY=financial(syminfo.tickerid,"SHORT_TERM_DEBT", "FY") SHORT_TERM_INVEST_FY=financial(syminfo.tickerid,"SHORT_TERM_INVEST", "FY") SHRHLDRS_EQUITY_FY=financial(syminfo.tickerid,"SHRHLDRS_EQUITY", "FY") TOTAL_ASSETS_FY=financial(syminfo.tickerid,"TOTAL_ASSETS", "FY") TOTAL_CURRENT_ASSETS_FY=financial(syminfo.tickerid,"TOTAL_CURRENT_ASSETS", "FY") TOTAL_CURRENT_LIABILITIES_FY=financial(syminfo.tickerid,"TOTAL_CURRENT_LIABILITIES", "FY") TOTAL_DEBT_FY=financial(syminfo.tickerid,"TOTAL_DEBT", "FY") TOTAL_EQUITY_FY=financial(syminfo.tickerid,"TOTAL_EQUITY", "FY") TOTAL_INVENTORY_FY=financial(syminfo.tickerid,"TOTAL_INVENTORY", "FY") TOTAL_LIABILITIES_FY=financial(syminfo.tickerid,"TOTAL_LIABILITIES", "FY") TOTAL_LIABILITIES_SHRHLDRS_EQUITY_FY=financial(syminfo.tickerid,"TOTAL_LIABILITIES_SHRHLDRS_EQUITY", "FY") TOTAL_NON_CURRENT_ASSETS_FY=financial(syminfo.tickerid,"TOTAL_NON_CURRENT_ASSETS", "FY") TOTAL_NON_CURRENT_LIABILITIES_FY=financial(syminfo.tickerid,"TOTAL_NON_CURRENT_LIABILITIES", "FY") TOTAL_RECEIVABLES_NET_FY=financial(syminfo.tickerid,"TOTAL_RECEIVABLES_NET", "FY") TOTAL_SHARES_OUTSTANDING_FY=financial(syminfo.tickerid,"TOTAL_SHARES_OUTSTANDING", "FY") //最後の足で描写処理 if (barstate.islast) financial_data_value = array.new_string(0) financial_data_description = array.new_string(0) // ------------- array.push(financial_data_description,"資本金の支払い PAID_IN_CAPITAL") array.push(financial_data_description,"有形固定資産合計 PPE_TOTAL_GROSS") array.push(financial_data_description,"有形固定資産純額 PPE_TOTAL_NET") array.push(financial_data_description,"優先株式 、 貸借対照表 計上額 PREFERRED_STOCK_CARRYING_VALUE") array.push(financial_data_description,"前払い費用 PREPAID_EXPENSES") array.push(financial_data_description,"リスク 引当金 繰入額 PROVISION_F_RISKS") array.push(financial_data_description,"利益剰余金 RETAINED_EARNINGS") array.push(financial_data_description,"短期借入金(1年以内返済予定の長期借入金を除く SHORT_TERM_DEBT_EXCL_CURRENT_PORT") array.push(financial_data_description,"短期借入金 SHORT_TERM_DEBT") array.push(financial_data_description,"短期投資 SHORT_TERM_INVEST") array.push(financial_data_description,"株主資本 SHRHLDRS_EQUITY") array.push(financial_data_description,"総資産 TOTAL_ASSETS") array.push(financial_data_description,"流動資産 合計 TOTAL_CURRENT_ASSETS") array.push(financial_data_description,"流動負債合計 TOTAL_CURRENT_LIABILITIES") array.push(financial_data_description,"負債総額 TOTAL_DEBT") array.push(financial_data_description,"純資産の部 TOTAL_EQUITY") array.push(financial_data_description,"棚卸資産 合計 TOTAL_INVENTORY") array.push(financial_data_description,"負債の部 TOTAL_LIABILITIES") array.push(financial_data_description,"負債・株主資本合計 TOTAL_LIABILITIES_SHRHLDRS_EQUITY") array.push(financial_data_description,"固定資産の部) Ⅰ 流動資産 合計 TOTAL_NON_CURRENT_ASSETS") array.push(financial_data_description,"固定負債 の部) Ⅰ 流動負債の部 TOTAL_NON_CURRENT_LIABILITIES") array.push(financial_data_description,"売上債権合計(純額) (単位:百万円 TOTAL_RECEIVABLES_NET") array.push(financial_data_description,"発行済株式総数 TOTAL_SHARES_OUTSTANDING") // ------------- array.push(financial_data_value,tostring(PAID_IN_CAPITAL_FY[0])) array.push(financial_data_value,tostring(PPE_TOTAL_GROSS_FY[0])) array.push(financial_data_value,tostring(PPE_TOTAL_NET_FY[0])) array.push(financial_data_value,tostring(PREFERRED_STOCK_CARRYING_VALUE_FY[0])) array.push(financial_data_value,tostring(PREPAID_EXPENSES_FY[0])) array.push(financial_data_value,tostring(PROVISION_F_RISKS_FY[0])) array.push(financial_data_value,tostring(RETAINED_EARNINGS_FY[0])) array.push(financial_data_value,tostring(SHORT_TERM_DEBT_EXCL_CURRENT_PORT_FY[0])) array.push(financial_data_value,tostring(SHORT_TERM_DEBT_FY[0])) array.push(financial_data_value,tostring(SHORT_TERM_INVEST_FY[0])) array.push(financial_data_value,tostring(SHRHLDRS_EQUITY_FY[0])) array.push(financial_data_value,tostring(TOTAL_ASSETS_FY[0])) array.push(financial_data_value,tostring(TOTAL_CURRENT_ASSETS_FY[0])) array.push(financial_data_value,tostring(TOTAL_CURRENT_LIABILITIES_FY[0])) array.push(financial_data_value,tostring(TOTAL_DEBT_FY[0])) array.push(financial_data_value,tostring(TOTAL_EQUITY_FY[0])) array.push(financial_data_value,tostring(TOTAL_INVENTORY_FY[0])) array.push(financial_data_value,tostring(TOTAL_LIABILITIES_FY[0])) array.push(financial_data_value,tostring(TOTAL_LIABILITIES_SHRHLDRS_EQUITY_FY[0])) array.push(financial_data_value,tostring(TOTAL_NON_CURRENT_ASSETS_FY[0])) array.push(financial_data_value,tostring(TOTAL_NON_CURRENT_LIABILITIES_FY[0])) array.push(financial_data_value,tostring(TOTAL_RECEIVABLES_NET_FY[0])) array.push(financial_data_value,tostring(TOTAL_SHARES_OUTSTANDING_FY[0])) var label_text = " 【2 貸借対照表(2/2)(Balance Sheet)】\n" for i=0 to array.size(financial_data_value)-1 label_text := label_text + array.get(financial_data_description,i)+"\t\t:\t\t" label_text := label_text + array.get(financial_data_value,i)+"\n" var label l = na l := label.new( bar_index, 0, yloc=yloc.price, style=label.style_label_right, color=color.green,textcolor=color.white,textalign=text.align_left,size=size.large, text=label_text )
【3 キャッシュフロー(Cash Flow)】
サンプル画像
コード
//@version=4 // finnancialデータを一覧で確認するスクリプト // 2 貸借対照表(2/2)(Balance Sheet) study("WR_FinancialDataList_to_CashFlow") // 登録一覧 CAPITAL_EXPENDITURES_FIXED_ASSETS_FY=financial(syminfo.tickerid,"CAPITAL_EXPENDITURES_FIXED_ASSETS", "FY") CAPITAL_EXPENDITURES_FY=financial(syminfo.tickerid,"CAPITAL_EXPENDITURES", "FY") CAPITAL_EXPENDITURES_OTHER_ASSETS_FY=financial(syminfo.tickerid,"CAPITAL_EXPENDITURES_OTHER_ASSETS", "FY") CASH_F_FINANCING_ACTIVITIES_FY=financial(syminfo.tickerid,"CASH_F_FINANCING_ACTIVITIES", "FY") CASH_F_INVESTING_ACTIVITIES_FY=financial(syminfo.tickerid,"CASH_F_INVESTING_ACTIVITIES", "FY") CASH_F_OPERATING_ACTIVITIES_FY=financial(syminfo.tickerid,"CASH_F_OPERATING_ACTIVITIES", "FY") CASH_FLOW_DEFERRED_TAXES_FY=financial(syminfo.tickerid,"CASH_FLOW_DEFERRED_TAXES", "FY") CASH_FLOW_DEPRECATION_N_AMORTIZATION_FY=financial(syminfo.tickerid,"CASH_FLOW_DEPRECATION_N_AMORTIZATION", "FY") CHANGE_IN_ACCOUNTS_PAYABLE_FY=financial(syminfo.tickerid,"CHANGE_IN_ACCOUNTS_PAYABLE", "FY") CHANGE_IN_ACCOUNTS_RECEIVABLE_FY=financial(syminfo.tickerid,"CHANGE_IN_ACCOUNTS_RECEIVABLE", "FY") CHANGE_IN_ACCRUED_EXPENSES_FY=financial(syminfo.tickerid,"CHANGE_IN_ACCRUED_EXPENSES", "FY") CHANGE_IN_INVENTORIES_FY=financial(syminfo.tickerid,"CHANGE_IN_INVENTORIES", "FY") CHANGE_IN_OTHER_ASSETS_FY=financial(syminfo.tickerid,"CHANGE_IN_OTHER_ASSETS", "FY") CHANGE_IN_TAXES_PAYABLE_FY=financial(syminfo.tickerid,"CHANGE_IN_TAXES_PAYABLE", "FY") CHANGES_IN_WORKING_CAPITAL_FY=financial(syminfo.tickerid,"CHANGES_IN_WORKING_CAPITAL", "FY") FREE_CASH_FLOW_FY=financial(syminfo.tickerid,"FREE_CASH_FLOW", "FY") FUNDS_F_OPERATIONS_FY=financial(syminfo.tickerid,"FUNDS_F_OPERATIONS", "FY") ISSUANCE_OF_DEBT_NET_FY=financial(syminfo.tickerid,"ISSUANCE_OF_DEBT_NET", "FY") ISSUANCE_OF_LONG_TERM_DEBT_FY=financial(syminfo.tickerid,"ISSUANCE_OF_LONG_TERM_DEBT", "FY") ISSUANCE_OF_OTHER_DEBT_FY=financial(syminfo.tickerid,"ISSUANCE_OF_OTHER_DEBT", "FY") ISSUANCE_OF_SHORT_TERM_DEBT_FY=financial(syminfo.tickerid,"ISSUANCE_OF_SHORT_TERM_DEBT", "FY") ISSUANCE_OF_STOCK_NET_FY=financial(syminfo.tickerid,"ISSUANCE_OF_STOCK_NET", "FY") NET_INCOME_STARTING_LINE_FY=financial(syminfo.tickerid,"NET_INCOME_STARTING_LINE", "FY") NON_CASH_ITEMS_FY=financial(syminfo.tickerid,"NON_CASH_ITEMS", "FY") OTHER_FINANCING_CASH_FLOW_ITEMS_TOTAL_FY=financial(syminfo.tickerid,"OTHER_FINANCING_CASH_FLOW_ITEMS_TOTAL", "FY") OTHER_FINANCING_CASH_FLOW_SOURCES_FY=financial(syminfo.tickerid,"OTHER_FINANCING_CASH_FLOW_SOURCES", "FY") OTHER_FINANCING_CASH_FLOW_USES_FY=financial(syminfo.tickerid,"OTHER_FINANCING_CASH_FLOW_USES", "FY") OTHER_INVESTING_CASH_FLOW_ITEMS_TOTAL_FY=financial(syminfo.tickerid,"OTHER_INVESTING_CASH_FLOW_ITEMS_TOTAL", "FY") OTHER_INVESTING_CASH_FLOW_SOURCES_FY=financial(syminfo.tickerid,"OTHER_INVESTING_CASH_FLOW_SOURCES", "FY") OTHER_INVESTING_CASH_FLOW_USES_FY=financial(syminfo.tickerid,"OTHER_INVESTING_CASH_FLOW_USES", "FY") PURCHASE_OF_BUSINESS_FY=financial(syminfo.tickerid,"PURCHASE_OF_BUSINESS", "FY") PURCHASE_OF_INVESTMENTS_FY=financial(syminfo.tickerid,"PURCHASE_OF_INVESTMENTS", "FY") PURCHASE_OF_STOCK_FY=financial(syminfo.tickerid,"PURCHASE_OF_STOCK", "FY") PURCHASE_SALE_BUSINESS_FY=financial(syminfo.tickerid,"PURCHASE_SALE_BUSINESS", "FY") PURCHASE_SALE_INVESTMENTS_FY=financial(syminfo.tickerid,"PURCHASE_SALE_INVESTMENTS", "FY") SALE_OF_STOCK_FY=financial(syminfo.tickerid,"SALE_OF_STOCK", "FY") SALES_OF_BUSINESS_FY=financial(syminfo.tickerid,"SALES_OF_BUSINESS", "FY") SALES_OF_INVESTMENTS_FY=financial(syminfo.tickerid,"SALES_OF_INVESTMENTS", "FY") TOTAL_CASH_DIVIDENDS_PAID_FY=financial(syminfo.tickerid,"TOTAL_CASH_DIVIDENDS_PAID", "FY") TOTAL_EXTRA_ITEMS_FY=financial(syminfo.tickerid,"TOTAL_EXTRA_ITEMS", "FY") //最後の足で描写処理 if (barstate.islast) financial_data_value = array.new_string(0) financial_data_description = array.new_string(0) // ------------- array.push(financial_data_description,"設備投資-固定資産 CAPITAL_EXPENDITURES_FIXED_ASSETS") array.push(financial_data_description,"設備投資額 CAPITAL_EXPENDITURES") array.push(financial_data_description,"設備投資-その他の資産 CAPITAL_EXPENDITURES_OTHER_ASSETS") array.push(financial_data_description,"財務活動による キャッシュ・フロー CASH_F_FINANCING_ACTIVITIES") array.push(financial_data_description,"投資活動による キャッシュ・フロー CASH_F_INVESTING_ACTIVITIES") array.push(financial_data_description,"営業活動による キャッシュ・フロー CASH_F_OPERATING_ACTIVITIES") array.push(financial_data_description,"繰延税金資産 ( キャッシュ・フロー CASH_FLOW_DEFERRED_TAXES") array.push(financial_data_description,"減価償却 費( キャッシュフロー CASH_FLOW_DEPRECATION_N_AMORTIZATION") array.push(financial_data_description,"買掛金の増減額 CHANGE_IN_ACCOUNTS_PAYABLE") array.push(financial_data_description,"売掛金 の増減額 CHANGE_IN_ACCOUNTS_RECEIVABLE") array.push(financial_data_description,"未払費用の増減 CHANGE_IN_ACCRUED_EXPENSES") array.push(financial_data_description,"棚卸資産 の増減 CHANGE_IN_INVENTORIES") array.push(financial_data_description,"その他の資産・負債の増減 CHANGE_IN_OTHER_ASSETS") array.push(financial_data_description,"未払 法人税 等の増減額 CHANGE_IN_TAXES_PAYABLE") array.push(financial_data_description,"運転資金の推移 CHANGES_IN_WORKING_CAPITAL") array.push(financial_data_description,"フリー キャッシュフロー FREE_CASH_FLOW") array.push(financial_data_description,"営業活動による キャッシュ・フロー FUNDS_F_OPERATIONS") array.push(financial_data_description,"借入金の発行(消却)純額 ISSUANCE_OF_DEBT_NET") array.push(financial_data_description,"長期借入金の発行(償還)について ISSUANCE_OF_LONG_TERM_DEBT") array.push(financial_data_description,"その他の債務の発行(除却) ISSUANCE_OF_OTHER_DEBT") array.push(financial_data_description,"短期借入金の発行(消却)について ISSUANCE_OF_SHORT_TERM_DEBT") array.push(financial_data_description,"株式の発行(消却)純額 ISSUANCE_OF_STOCK_NET") array.push(financial_data_description,"当期純利益 ( キャッシュフロー NET_INCOME_STARTING_LINE") array.push(financial_data_description,"現金以外の項目 NON_CASH_ITEMS") array.push(financial_data_description,"その他の財務活動による キャッシュ・フロー OTHER_FINANCING_CASH_FLOW_ITEMS_TOTAL") array.push(financial_data_description,"財務活動による キャッシュ・フロー OTHER_FINANCING_CASH_FLOW_SOURCES") array.push(financial_data_description,"財務活動による キャッシュ・フロー OTHER_FINANCING_CASH_FLOW_USES") array.push(financial_data_description,"その他の投資 キャッシュ・フロー 項目 OTHER_INVESTING_CASH_FLOW_ITEMS_TOTAL") array.push(financial_data_description,"投資活動による キャッシュ・フロー OTHER_INVESTING_CASH_FLOW_SOURCES") array.push(financial_data_description,"投資活動による キャッシュ・フロー OTHER_INVESTING_CASH_FLOW_USES") array.push(financial_data_description,"事業譲受け PURCHASE_OF_BUSINESS") array.push(financial_data_description,"投資先の購入 PURCHASE_OF_INVESTMENTS") array.push(financial_data_description,"普通株式 ・ 優先株式 の取得 PURCHASE_OF_STOCK") array.push(financial_data_description,"事業の売買、ネット PURCHASE_SALE_BUSINESS") array.push(financial_data_description,"投資有価証券の取得・売却(純額 PURCHASE_SALE_INVESTMENTS") array.push(financial_data_description,"普通株式 ・ 優先株式 の売却 SALE_OF_STOCK") array.push(financial_data_description,"固定資産・事業の売却 SALES_OF_BUSINESS") array.push(financial_data_description,"投資有価証券の売却・償還時期 SALES_OF_INVESTMENTS") array.push(financial_data_description,"配当金総額 TOTAL_CASH_DIVIDENDS_PAID") array.push(financial_data_description,"非日常的なアイテム TOTAL_EXTRA_ITEMS") // ------------- array.push(financial_data_value,tostring(CAPITAL_EXPENDITURES_FIXED_ASSETS_FY[0])) array.push(financial_data_value,tostring(CAPITAL_EXPENDITURES_FY[0])) array.push(financial_data_value,tostring(CAPITAL_EXPENDITURES_OTHER_ASSETS_FY[0])) array.push(financial_data_value,tostring(CASH_F_FINANCING_ACTIVITIES_FY[0])) array.push(financial_data_value,tostring(CASH_F_INVESTING_ACTIVITIES_FY[0])) array.push(financial_data_value,tostring(CASH_F_OPERATING_ACTIVITIES_FY[0])) array.push(financial_data_value,tostring(CASH_FLOW_DEFERRED_TAXES_FY[0])) array.push(financial_data_value,tostring(CASH_FLOW_DEPRECATION_N_AMORTIZATION_FY[0])) array.push(financial_data_value,tostring(CHANGE_IN_ACCOUNTS_PAYABLE_FY[0])) array.push(financial_data_value,tostring(CHANGE_IN_ACCOUNTS_RECEIVABLE_FY[0])) array.push(financial_data_value,tostring(CHANGE_IN_ACCRUED_EXPENSES_FY[0])) array.push(financial_data_value,tostring(CHANGE_IN_INVENTORIES_FY[0])) array.push(financial_data_value,tostring(CHANGE_IN_OTHER_ASSETS_FY[0])) array.push(financial_data_value,tostring(CHANGE_IN_TAXES_PAYABLE_FY[0])) array.push(financial_data_value,tostring(CHANGES_IN_WORKING_CAPITAL_FY[0])) array.push(financial_data_value,tostring(FREE_CASH_FLOW_FY[0])) array.push(financial_data_value,tostring(FUNDS_F_OPERATIONS_FY[0])) array.push(financial_data_value,tostring(ISSUANCE_OF_DEBT_NET_FY[0])) array.push(financial_data_value,tostring(ISSUANCE_OF_LONG_TERM_DEBT_FY[0])) array.push(financial_data_value,tostring(ISSUANCE_OF_OTHER_DEBT_FY[0])) array.push(financial_data_value,tostring(ISSUANCE_OF_SHORT_TERM_DEBT_FY[0])) array.push(financial_data_value,tostring(ISSUANCE_OF_STOCK_NET_FY[0])) array.push(financial_data_value,tostring(NET_INCOME_STARTING_LINE_FY[0])) array.push(financial_data_value,tostring(NON_CASH_ITEMS_FY[0])) array.push(financial_data_value,tostring(OTHER_FINANCING_CASH_FLOW_ITEMS_TOTAL_FY[0])) array.push(financial_data_value,tostring(OTHER_FINANCING_CASH_FLOW_SOURCES_FY[0])) array.push(financial_data_value,tostring(OTHER_FINANCING_CASH_FLOW_USES_FY[0])) array.push(financial_data_value,tostring(OTHER_INVESTING_CASH_FLOW_ITEMS_TOTAL_FY[0])) array.push(financial_data_value,tostring(OTHER_INVESTING_CASH_FLOW_SOURCES_FY[0])) array.push(financial_data_value,tostring(OTHER_INVESTING_CASH_FLOW_USES_FY[0])) array.push(financial_data_value,tostring(PURCHASE_OF_BUSINESS_FY[0])) array.push(financial_data_value,tostring(PURCHASE_OF_INVESTMENTS_FY[0])) array.push(financial_data_value,tostring(PURCHASE_OF_STOCK_FY[0])) array.push(financial_data_value,tostring(PURCHASE_SALE_BUSINESS_FY[0])) array.push(financial_data_value,tostring(PURCHASE_SALE_INVESTMENTS_FY[0])) array.push(financial_data_value,tostring(SALE_OF_STOCK_FY[0])) array.push(financial_data_value,tostring(SALES_OF_BUSINESS_FY[0])) array.push(financial_data_value,tostring(SALES_OF_INVESTMENTS_FY[0])) array.push(financial_data_value,tostring(TOTAL_CASH_DIVIDENDS_PAID_FY[0])) array.push(financial_data_value,tostring(TOTAL_EXTRA_ITEMS_FY[0])) var label_text = " 【3 キャッシュフロー(Cash Flow)】\n" for i=0 to array.size(financial_data_value)-1 label_text := label_text + array.get(financial_data_description,i)+"\t\t:\t\t" label_text := label_text + array.get(financial_data_value,i)+"\n" var label l = na l := label.new( bar_index, 0, yloc=yloc.price, style=label.style_label_right, color=color.green,textcolor=color.white,textalign=text.align_left,size=size.large, text=label_text )
【4 比率(1/2)(Ratios)】
サンプル画像
コード
//@version=4 // finnancialデータを一覧で確認するスクリプト // 【4 比率(1/2)(Ratios)】 study("WR_FinancialDataList_to_Ratios1") // 登録一覧 ACCRUALS_RATIO_FY=financial(syminfo.tickerid,"ACCRUALS_RATIO", "FY") ASSET_TURNOVER_FY=financial(syminfo.tickerid,"ASSET_TURNOVER", "FY") BOOK_TANGIBLE_PER_SHARE_FY=financial(syminfo.tickerid,"BOOK_TANGIBLE_PER_SHARE", "FY") CASH_TO_DEBT_FY=financial(syminfo.tickerid,"CASH_TO_DEBT", "FY") COGS_TO_REVENUE_FY=financial(syminfo.tickerid,"COGS_TO_REVENUE", "FY") CURRENT_RATIO_FY=financial(syminfo.tickerid,"CURRENT_RATIO", "FY") DAY_SALES_OUT_FY=financial(syminfo.tickerid,"DAY_SALES_OUT", "FY") DAYS_INVENT_FY=financial(syminfo.tickerid,"DAYS_INVENT", "FY") DAYS_PAY_FY=financial(syminfo.tickerid,"DAYS_PAY", "FY") DEBT_TO_ASSET_FY=financial(syminfo.tickerid,"DEBT_TO_ASSET", "FY") DEBT_TO_EBITDA_FY=financial(syminfo.tickerid,"DEBT_TO_EBITDA", "FY") DEBT_TO_EQUITY_FY=financial(syminfo.tickerid,"DEBT_TO_EQUITY", "FY") DEBT_TO_REVENUE_FY=financial(syminfo.tickerid,"DEBT_TO_REVENUE", "FY") EARNINGS_ESTIMATE_FY=financial(syminfo.tickerid,"EARNINGS_ESTIMATE", "FY") EARNINGS_PER_SHARE_BASIC_ONE_YEAR_GROWTH_FY=financial(syminfo.tickerid,"EARNINGS_PER_SHARE_BASIC_ONE_YEAR_GROWTH", "FY") EARNINGS_PER_SHARE_DILUTED_ONE_YEAR_GROWTH_FY=financial(syminfo.tickerid,"EARNINGS_PER_SHARE_DILUTED_ONE_YEAR_GROWTH", "FY") EBITDA_MARGIN_FY=financial(syminfo.tickerid,"EBITDA_MARGIN", "FY") EF_INTEREST_DEBT_FY=financial(syminfo.tickerid,"EF_INTEREST_DEBT", "FY") ENTERPRISE_VALUE_FY=financial(syminfo.tickerid,"ENTERPRISE_VALUE", "FY") EQUITY_TO_ASSET_FY=financial(syminfo.tickerid,"EQUITY_TO_ASSET", "FY") EV_EBIT_FY=financial(syminfo.tickerid,"EV_EBIT", "FY") EV_EBITDA_FY=financial(syminfo.tickerid,"EV_EBITDA", "FY") EV_REVENUE_FY=financial(syminfo.tickerid,"EV_REVENUE", "FY") GOODWILL_TO_ASSET_FY=financial(syminfo.tickerid,"GOODWILL_TO_ASSET", "FY") GRAHAM_NUMBERS_FY=financial(syminfo.tickerid,"GRAHAM_NUMBERS", "FY") INTERST_COVER_FY=financial(syminfo.tickerid,"INTERST_COVER", "FY") INVENT_TO_REVENUE_FY=financial(syminfo.tickerid,"INVENT_TO_REVENUE", "FY") INVENT_TURNOVER_FY=financial(syminfo.tickerid,"INVENT_TURNOVER", "FY") LT_DEBT_ASSET_FY=financial(syminfo.tickerid,"LT_DEBT_ASSET", "FY") NCAVPS_RATIO_FY=financial(syminfo.tickerid,"NCAVPS_RATIO", "FY") NET_INCOME_MGN_ONE_YEAR_GROWTH_FY=financial(syminfo.tickerid,"NET_INCOME_MGN_ONE_YEAR_GROWTH", "FY") NET_INCOME_PER_EMPLOYEE_FY=financial(syminfo.tickerid,"NET_INCOME_PER_EMPLOYEE", "FY") NUMBER_OF_EMPLOYEES_FY=financial(syminfo.tickerid,"NUMBER_OF_EMPLOYEES", "FY") OPERATING_MARGIN_FY=financial(syminfo.tickerid,"OPERATING_MARGIN", "FY") QUALITY_RATIO_FY=financial(syminfo.tickerid,"QUALITY_RATIO", "FY") QUICK_RATIO_FY=financial(syminfo.tickerid,"QUICK_RATIO", "FY") RETURN_ON_EQUITY_FY=financial(syminfo.tickerid,"RETURN_ON_EQUITY", "FY") RETURN_TANG_ASSET_FY=financial(syminfo.tickerid,"RETURN_TANG_ASSET", "FY") RETURN_TANG_EQUITY_FY=financial(syminfo.tickerid,"RETURN_TANG_EQUITY", "FY") REVENUE_ONE_YEAR_GROWTH_FY=financial(syminfo.tickerid,"REVENUE_ONE_YEAR_GROWTH", "FY") //最後の足で描写処理 if (barstate.islast) financial_data_value = array.new_string(0) financial_data_description = array.new_string(0) // ------------- array.push(financial_data_description,"引当金 繰入額 ACCRUALS_RATIO") array.push(financial_data_description,"資産回転率 ASSET_TURNOVER") array.push(financial_data_description,"1株当たり純資産額 BOOK_TANGIBLE_PER_SHARE") array.push(financial_data_description,"キャッシュ・デビット CASH_TO_DEBT") array.push(financial_data_description,"売上高に対するCOGSの比率 COGS_TO_REVENUE") array.push(financial_data_description,"現在の比率 CURRENT_RATIO") array.push(financial_data_description,"卓越した日の販売 DAY_SALES_OUT") array.push(financial_data_description,"日の在庫 DAYS_INVENT") array.push(financial_data_description,"支払可能日数 DAYS_PAY") array.push(financial_data_description,"有利子負債比率 DEBT_TO_ASSET") array.push(financial_data_description,"有利子負債対EBITDA DEBT_TO_EBITDA") array.push(financial_data_description,"有利子負債比率 DEBT_TO_EQUITY") array.push(financial_data_description,"有利子負債比率 DEBT_TO_REVENUE") array.push(financial_data_description,"EPS推定値 EARNINGS_ESTIMATE") array.push(financial_data_description,"EPSベーシック1年成長率 EARNINGS_PER_SHARE_BASIC_ONE_YEAR_GROWTH") array.push(financial_data_description,"1株当たり 当期純利益 潜在株式調整後1株当たり 当期純利益 EARNINGS_PER_SHARE_DILUTED_ONE_YEAR_GROWTH") array.push(financial_data_description,"EBITDAマージン EBITDA_MARGIN") array.push(financial_data_description,"有利子負債の実効 金利 EF_INTEREST_DEBT") array.push(financial_data_description,"企業価値 ENTERPRISE_VALUE") array.push(financial_data_description,"自己資本比率 EQUITY_TO_ASSET") array.push(financial_data_description,"EV-toEBIT EV_EBIT") array.push(financial_data_description,"EV-toEBITDA EV_EBITDA") array.push(financial_data_description,"EV対レベニュー EV_REVENUE") array.push(financial_data_description,"のれんと資産の関係 GOODWILL_TO_ASSET") array.push(financial_data_description,"グラハムの番号 GRAHAM_NUMBERS") array.push(financial_data_description,"イン タレス ト カバレッジ INTERST_COVER") array.push(financial_data_description,"たな卸資産売上高 INVENT_TO_REVENUE") array.push(financial_data_description,"在庫回転率 INVENT_TURNOVER") array.push(financial_data_description,"総資産経常利益率 LT_DEBT_ASSET") array.push(financial_data_description,"1株当たり純資産額 NCAVPS_RATIO") array.push(financial_data_description,"ネットマージン NET_INCOME_MGN_ONE_YEAR_GROWTH") array.push(financial_data_description,"従業員一人当たり 当期純利益 NET_INCOME_PER_EMPLOYEE") array.push(financial_data_description,"従業員数 NUMBER_OF_EMPLOYEES") array.push(financial_data_description,"営業利益率 OPERATING_MARGIN") array.push(financial_data_description,"品質比 QUALITY_RATIO") array.push(financial_data_description,"クイックレシオ QUICK_RATIO") array.push(financial_data_description,"自己資本利益率 RETURN_ON_EQUITY") array.push(financial_data_description,"有形固定資産利益率 RETURN_TANG_ASSET") array.push(financial_data_description,"有形 株主資本利益率 RETURN_TANG_EQUITY") array.push(financial_data_description,"収入 1年間の成長率 REVENUE_ONE_YEAR_GROWTH") // ------------- array.push(financial_data_value,tostring(ACCRUALS_RATIO_FY[0])) array.push(financial_data_value,tostring(ASSET_TURNOVER_FY[0])) array.push(financial_data_value,tostring(BOOK_TANGIBLE_PER_SHARE_FY[0])) array.push(financial_data_value,tostring(CASH_TO_DEBT_FY[0])) array.push(financial_data_value,tostring(COGS_TO_REVENUE_FY[0])) array.push(financial_data_value,tostring(CURRENT_RATIO_FY[0])) array.push(financial_data_value,tostring(DAY_SALES_OUT_FY[0])) array.push(financial_data_value,tostring(DAYS_INVENT_FY[0])) array.push(financial_data_value,tostring(DAYS_PAY_FY[0])) array.push(financial_data_value,tostring(DEBT_TO_ASSET_FY[0])) array.push(financial_data_value,tostring(DEBT_TO_EBITDA_FY[0])) array.push(financial_data_value,tostring(DEBT_TO_EQUITY_FY[0])) array.push(financial_data_value,tostring(DEBT_TO_REVENUE_FY[0])) array.push(financial_data_value,tostring(EARNINGS_ESTIMATE_FY[0])) array.push(financial_data_value,tostring(EARNINGS_PER_SHARE_BASIC_ONE_YEAR_GROWTH_FY[0])) array.push(financial_data_value,tostring(EARNINGS_PER_SHARE_DILUTED_ONE_YEAR_GROWTH_FY[0])) array.push(financial_data_value,tostring(EBITDA_MARGIN_FY[0])) array.push(financial_data_value,tostring(EF_INTEREST_DEBT_FY[0])) array.push(financial_data_value,tostring(ENTERPRISE_VALUE_FY[0])) array.push(financial_data_value,tostring(EQUITY_TO_ASSET_FY[0])) array.push(financial_data_value,tostring(EV_EBIT_FY[0])) array.push(financial_data_value,tostring(EV_EBITDA_FY[0])) array.push(financial_data_value,tostring(EV_REVENUE_FY[0])) array.push(financial_data_value,tostring(GOODWILL_TO_ASSET_FY[0])) array.push(financial_data_value,tostring(GRAHAM_NUMBERS_FY[0])) array.push(financial_data_value,tostring(INTERST_COVER_FY[0])) array.push(financial_data_value,tostring(INVENT_TO_REVENUE_FY[0])) array.push(financial_data_value,tostring(INVENT_TURNOVER_FY[0])) array.push(financial_data_value,tostring(LT_DEBT_ASSET_FY[0])) array.push(financial_data_value,tostring(NCAVPS_RATIO_FY[0])) array.push(financial_data_value,tostring(NET_INCOME_MGN_ONE_YEAR_GROWTH_FY[0])) array.push(financial_data_value,tostring(NET_INCOME_PER_EMPLOYEE_FY[0])) array.push(financial_data_value,tostring(NUMBER_OF_EMPLOYEES_FY[0])) array.push(financial_data_value,tostring(OPERATING_MARGIN_FY[0])) array.push(financial_data_value,tostring(QUALITY_RATIO_FY[0])) array.push(financial_data_value,tostring(QUICK_RATIO_FY[0])) array.push(financial_data_value,tostring(RETURN_ON_EQUITY_FY[0])) array.push(financial_data_value,tostring(RETURN_TANG_ASSET_FY[0])) array.push(financial_data_value,tostring(RETURN_TANG_EQUITY_FY[0])) array.push(financial_data_value,tostring(REVENUE_ONE_YEAR_GROWTH_FY[0])) var label_text = " 【4 比率(1/2)(Ratios)】\n" for i=0 to array.size(financial_data_value)-1 label_text := label_text + array.get(financial_data_description,i)+"\t\t:\t\t" label_text := label_text + array.get(financial_data_value,i)+"\n" var label l = na l := label.new( bar_index, 0, yloc=yloc.price, style=label.style_label_right, color=color.green,textcolor=color.white,textalign=text.align_left,size=size.large, text=label_text )
【4 比率(2/2)(Ratios)】
サンプル画像
コード
//@version=4 // finnancialデータを一覧で確認するスクリプト // 【4 比率(2/2)(Ratios)】 study("WR_FinancialDataList_to_Ratios2") // 登録一覧 REVENUE_PER_EMPLOYEE_FY=financial(syminfo.tickerid,"REVENUE_PER_EMPLOYEE", "FY") ROA_PERC_FY=financial(syminfo.tickerid,"ROA_PERC", "FY") ROE_ADJUST_FY=financial(syminfo.tickerid,"ROE_ADJUST", "FY") ROIC_PERC_FY=financial(syminfo.tickerid,"ROIC_PERC", "FY") SALES_ESTIMATES_FY=financial(syminfo.tickerid,"SALES_ESTIMATES", "FY") SHARE_BUYBACK_RATIO_FY=financial(syminfo.tickerid,"SHARE_BUYBACK_RATIO", "FY") SLOAN_RATIO_FY=financial(syminfo.tickerid,"SLOAN_RATIO", "FY") TANGIBLE_COMMON_EQUITY_RATIO_FY=financial(syminfo.tickerid,"TANGIBLE_COMMON_EQUITY_RATIO", "FY") //最後の足で描写処理 if (barstate.islast) financial_data_value = array.new_string(0) financial_data_description = array.new_string(0) // ------------- array.push(financial_data_description,"従業員一人当たりの収入 REVENUE_PER_EMPLOYEE") array.push(financial_data_description,"総資産経常利益率 ROA_PERC") array.push(financial_data_description,"ROE % 簿価修正後 ROE_ADJUST") array.push(financial_data_description,"ROIC ROIC_PERC") array.push(financial_data_description,"収入の見積もり SALES_ESTIMATES") array.push(financial_data_description,"自己株式取得率 SHARE_BUYBACK_RATIO") array.push(financial_data_description,"スローン比率 SLOAN_RATIO") array.push(financial_data_description,"有形 自己資本比率 TANGIBLE_COMMON_EQUITY_RATIO") // ------------- array.push(financial_data_value,tostring(REVENUE_PER_EMPLOYEE_FY[0])) array.push(financial_data_value,tostring(ROA_PERC_FY[0])) array.push(financial_data_value,tostring(ROE_ADJUST_FY[0])) array.push(financial_data_value,tostring(ROIC_PERC_FY[0])) array.push(financial_data_value,tostring(SALES_ESTIMATES_FY[0])) array.push(financial_data_value,tostring(SHARE_BUYBACK_RATIO_FY[0])) array.push(financial_data_value,tostring(SLOAN_RATIO_FY[0])) array.push(financial_data_value,tostring(TANGIBLE_COMMON_EQUITY_RATIO_FY[0])) var label_text = " 【4 比率(2/2)(Ratios)】\n" for i=0 to array.size(financial_data_value)-1 label_text := label_text + array.get(financial_data_description,i)+"\t\t:\t\t" label_text := label_text + array.get(financial_data_value,i)+"\n" var label l = na l := label.new( bar_index, 0, yloc=yloc.price, style=label.style_label_right, color=color.green,textcolor=color.white,textalign=text.align_left,size=size.large, text=label_text )