テスト用のインジケータ作成
kabuist.hatenablog.com
こんばんわ。
上記で紹介した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 )
サンプル画像

コード
//@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 )