Skip to content

adriantorrie/EodData.jl

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

71 Commits
examples
examples
 
 
src
src
 
 
test
test
 
 
.travis.yml
.travis.yml
 
 
LICENSE.md
LICENSE.md
 
 
README.md
README.md
 
 
REQUIRE
REQUIRE
 
 

Repository files navigation

EodData.jl

Build Status Coverage Status

Julia package for connecting to EodData.com and downloading financial markets data.

  • The source files are heavily documented, please review the source for in-depth documentation, and references.
  • The examples on this page can be found in /examples/examples.jl.

Package Dependencies

Test Repo:

Web Service Calls

Utility Functions

Types

Web Service Calls

using EodData

const USERNAME = "string"
const PASSWORD = "string"

login()

Call login. This will assign you a token which is needed to make EodData web service calls. The second call directly assigns a token, which is merely an ::ASCIIString.

resp = login(USERNAME, PASSWORD)
println(resp.message)
println(resp.token)
println(typeof(resp))

token = login(USERNAME, PASSWORD).token
println(token)
println(typeof(token))

country_list()

Call and assign countries.

countries = country_list(resp.token)
println(countries)

data_client_latest_version()

Call and assign the latest version for EodData's data client.

version = data_client_latest_version(resp.token)
println(version)

data_formats()

Call and assign the formats available, then assign the Standard CSV format to work with at your leisure.

formats = data_formats(resp.token)
println(formats)

csv = formats["CSV"]
println(csv.name)
println(csv.format_header)
for column=values(csv.columns)
	println("$(column.column_name) | $(column.column_header)")
end

exchange_get()

Call and assign a single exchange, in this case the NASDAQ, and assign to a variable to work with at your leisure.

nasdaq = exchange_get(resp.token, "NASDAQ")
println(nasdaq.name)
println(nasdaq.advances)
println(nasdaq.declines)
println("Advance/Decline Ratio \= $(nasdaq.advances / nasdaq.declines)")

exchange_list()

Call and assign the exchanges available (these can be iterated over if you wish), then assign the New York Stock Exchange to work with at your leisure.

exchanges = exchange_list(resp.token)
println(exchanges)

nyse = exchanges["NYSE"]
println(nyse.name)
println(nyse.advances)
println(nyse.declines)
println("Advance/Decline Ratio \= $(nyse.advances / nyse.declines)")

intraday_exchanges = filter((k,v) -> v.is_intraday == true, exchanges)

exchange_months()

Call and assign the number of months history available to download for a given exchange.

months = exchange_months(resp.token,"NYSE")
println(months)

fundamental_list()

Call and assign the fundamentals of all the listings on a given exchange. Here we look at the New Zealand Exchange (NZX) market capitalisation, which also has bonds listed on it, and from time-to-time, options as well.

nzx_fundamentals = fundamental_list(resp.token,"NZX")

nzx_market_cap = 0.0
for listing = values(nzx_fundamentals)
	nzx_market_cap += listing.market_cap
end
println(nzx_market_cap)
@sprintf "%.2f" nzx_market_cap

login_2()

Call and assign the response. Not really necessary for end-users from what I can tell.

resp = login_2(USERNAME,PASSWORD,"0.1")

membership()

Call and assign the users membership level/account type with EodData.com.

membership = membership(resp.token)
println(membership)

quote_get()

Call and assign the end-of-day quote for a given instrument. Here we get the quote for JP Morgan.

jpm = quote_get(resp.token, "NYSE", "JPM")
println(jpm)
println(jpm.close)
println(jpm.previous)
println(jpm.change)
println(jpm.simple_return)

quote_list()

Call and assign the end-of-day quotes for an exchange. The collection can be iterated over if you wish.

nyse_quotes = quote_list(resp.token, "NYSE")

quote_list_2()

Call and assign the end-of-day quotes for a custom group. The collection can be iterated over if you wish.

my_quotes = quote_list_2(resp.token, "NYSE", "C,MS,JPM,BAC,DB")
println(my_quotes)

quote_list_by_date()

Call and assign the end-of-day quotes for a custom date. The collection can be iterated over if you wish.

nyse_20140605 = quote_list_by_date(resp.token, "NYSE", "20140605")

for qt = values(nyse_20140605)
	println("$(qt.name) | $(qt.close)")
end

quote_list_by_date_2

Call and assign end-of-day quotes, with a smaller type ::Quote_2 for a custom date on a particular exchange. The collection can be iterated over if you wish.

asx_20131203 = quote_list_by_date_2(resp.token, "ASX", "20131203")
for qt = values(asx_20131203)
	println("$(qt.ticker_code) | $(qt.close)")
end

quote_list_by_date_period()

Call and assign quotes for a custom date, and a custom period on a particular exchange. If you choose "h" this will return hourly data for the exchange. The collection can be iterated over if you wish.

cme_20141008_h = quote_list_by_date_period(resp.token, "CME", "20141008", "h")

for k = keys(cme_20141008_h)
	println(k)
end

for qt = values(cme_20141008_h)
	println("$(qt.ticker_code)\t|\tDate Time: $(qt.date_time)\t|\tClose: $(qt.close)\t|\tVolume: $(qt.volume)")
end

cme_h = collect(cme_20141008_h)

quote_list_by_date_period_2()

Call and assign quotes, with a smaller type ::Quote_2, for a custom date, and a custom period on a particular exchange. If you choose "h" this will return hourly data for the exchange. The keys, values, and collection can be iterated over if you wish.

cme_20141008_h_2 = quote_list_by_date_period_2(resp.token, "CME", "20141008", "h")

for k = keys(cme_20141008_h_2)
	println(k)
end

for qt = values(cme_20141008_h_2)
	println("$(qt.ticker_code)\t|\tDate Time: $(qt.date_time)\t|\tClose: $(qt.close)\t|\tVolume: $(qt.volume)")
end

cme_h_2 = collect(cme_20141008_h_2)

split_list_by_exchange()

Call and assign the most recent splits for a given exchange.

nyse_splits = split_list_by_exchange(resp.token, "NYSE")
splits = collect(nyse_splits)
println(splits)

split_list_by_symbol()

Call and assign the most recent splits for a given symbol on a particular exchange.

nct_splits = split_list_by_symbol(resp.token, "NYSE", "NCT")
for sp = values(nct_splits)
	println("$(sp.exchange_code)\t|\t$(sp.ticker_code)\t|\tDate Time: $(sp.date_time)\t|\tRatio: $(sp.ratio)\t|\tPrice Multiplier: $(sp.price_multiplier)\t|\tReverse Split: $(sp.is_reverse_split)")
end

symbol_changes_by_exchange()

Call and assign the most recent changes to stock symbols, and changes to exchanges

amex_changes = symbol_changes_by_exchange(resp.token, "AMEX")
for sc = values(amex_changes)
	println(sc)
end

symbol_chart()

Call and assign the url for a chart of the symbol's price history.

url = symbol_chart(resp.token, "NYSE", "A")
println(url)

symbol_get()

Call and assign the detail for a ticker.

fb = symbol_get(resp.token, "NASDAQ", "FB")
println(fb)

symbol_history()

Call and assign quotes for a ticker from a start date until "today". Due to the web service not returning 100% data, the following fields of the ::Quote type will be 0, or NaN:

  • open_interest
  • previous
  • change
  • simple_return
  • bid
  • ask
  • previous_close
  • next_open
  • modified
c_20140601_today = symbol_history(resp.token, "NYSE", "C", "20140601")
println(c_20140601_today)

symbol_history_period

Call and assign quotes for a ticker, for a date, and a custom period. Due to the web service not returning 100% data, the following fields of the ::Quote type will be 0, or NaN:

  • open_interest
  • previous
  • change
  • simple_return
  • bid
  • ask
  • previous_close
  • next_open
  • modified
pg_2014102_h = symbol_history_period(resp.token, "NYSE", "PG", "20141002", "h")
println(pg_2014102_h)

symbol_history_period_by_date_range()

Call and assign quotes for a ticker, between a start date and end date, and a custom period. Due to the web service not returning 100% data, the following fields of the ::Quote type will be "", 0, or NaN:

  • description
  • name
  • open_interest
  • previous
  • change
  • simple_return
  • bid
  • ask
  • previous_close
  • next_open
  • modified
amzn_20141020_20141024_30 = symbol_history_period_by_date_range(resp.token, "NASDAQ", "AMZN", "20141020", "20141024", "30")
println(amzn_20141020_20141024_30)

symbol_list()

Call and assign the tickers for a given exchange.

nyse_tickers = symbol_list(resp.token, "NYSE")
println(nyse_tickers)

symbol_list_2()

Call and assign the tickers for a given exchange. This is a "smaller" version of the ticker object with only the ticker code and ticker name

nyse_tickers_2 = symbol_list_2(resp.token, "NYSE")
println(nyse_tickers_2)

technical_list()

Call and assign the technical indicator values for each ticker on a given exchange.

nyse_technicals = technical_list(resp.token, "NYSE")
println(nyse_technicals)

top_10_gains()

Call and assign the quotes for the top 10 gains for the NZX, also collect the ticker codes into an array, as the ticker codes are the dictionary keys.

nzx_top_10_gains_dict = top_10_gains(resp.token, "NZX")
nzx_top_10_gains_tickers = collect(keys(nzx_top_10_gains_dict))
println(nzx_top_10_gains_tickers)

top_10_losses()

Call and assign the quotes for the top 10 losses for the NZX, also collect the ticker codes into an array, as the ticker codes are the dictionary keys.

nzx_top_10_losses_dict = top_10_losses(resp.token, "NZX")
nzx_top_10_losses_tickers = collect(keys(nzx_top_10_losses_dict))
println(nzx_top_10_losses_tickers)

update_data_format()

This is not implemented.

validate_access()

The first call shows what is expected The second and third calls show the use of a utility function that's found in: /src/eod_utils_external.jl called set_date_string() that converts values that are type ::Date and ::DateTime into the correctly formatted string expected by the web service.

validate_access(resp.token, "NZX", "20141001", "h")
validate_access(resp.token, "NYSE", set_date_string(today()), "h")
validate_access(resp.token, "NYSE", set_date_string(now()), "h")

Utility Functions

set_date_string()

Converts values that are type ::Date and ::DateTime into the correctly formatted string expected by the web service.

  • The first call passes in a ::DateTime
  • The second call passes in a ::Date
  • Calls 3-6 show how further dynamic strings can be set
set_date_string(now())
set_date_string(today())
quarter_1 = set_date_string(Date(year(today()), 1, 1))
quarter_2 = set_date_string(Date(year(today()), 4, 1))
quarter_3 = set_date_string(Date(year(today()), 7, 1))
quarter_4 = set_date_string(Date(year(today()), 9, 1))

Data Types

Country

type Country
	code::String
	name::String
end

DataFormatColumn

type DataFormatColumn
	column_header::String
	sort_order::Int
	data_format_code::String
	data_format_name::String
	column_code::String
	column_name::String
	column_type_id::Int
	column_type::String
end

DataFormat

type DataFormat
	code::String
	name::String
	header_format::Vector{String}
	date_format::String
	extension::String
	include_suffix::Bool
	tab_column_seperator::Bool
	column_seperator::String
	text_qualifier::String
	filename_prefix::String
	filename_exchange_code::Bool
	filename_date::Bool
	include_header_row::Bool
	hour_format::String
	datetime_seperator::String
	exchange_filename_format_date::String
	exchange_filename_format_date_range::String
	ticker_filename_format_date::String
	ticker_filename_format_date_range::String
	columns::Dict{Int, DataFormatColumn}
end

Exchange

type Exchange
	code::String
	name::String
	last_trade_date_time::DateTime
	country_code::String
	currency_code::String
	advances::Float64
	declines::Float64
	suffix::String
	time_zone::String
	is_intraday::Bool
	intraday_start_date::DateTime
	has_intraday_product::Bool
end

Fundamental

type Fundamental
	ticker_code::String
	name::String
	description::String
	date_time::DateTime
	industry::String
	sector::String
	share_float::Float64
	market_cap::Float64
	pe_ratio::Float64
	earnings_per_share::Float64
	net_tangible_assets::Float64
	dividend_yield::Float64
	dividend::Float64
	dividend_date::DateTime
	dividend_per_share::Float64
	imputation_credits::Float64
	ebitda::Float64
	peg_ratio::Float64
	ps_ratio::Float64
	pb_ratio::Float64
	yield::Float64
end

LoginResponse

type LoginResponse
	message::String
	token::String
end

Quote

type Quote
	ticker_code::String
	description::String
	name::String
	date_time::DateTime
	open::Float64
	high::Float64
	low::Float64
	close::Float64
	volume::Float64
	open_interest::Float64
	previous::Float64
	change::Float64
	simple_return::Float64
	bid::Float64
	ask::Float64
	previous_close::Float64
	next_open::Float64
	modified::DateTime
end

Quote_2

type Quote_2
	ticker_code::String
	date_time::DateTime
	open::Float64
	high::Float64
	low::Float64
	close::Float64
	volume::Float64
	open_interest::Float64
	bid::Float64
	ask::Float64
end

Split

type Split
	exchange_code::String
	ticker_code::String
	date_time::DateTime
	ratio::String
	price_multiplier::Float64
	share_float_multiplier::Float64
	is_reverse_split::Bool
end

TickerChange

type TickerChange
	old_exchange_code::String
	new_exchange_code::String
	old_ticker_code::String
	new_ticker_code::String
	date_time::DateTime
	is_change_of_exchange_code::Bool
	is_change_of_ticker_code::Bool
end

Ticker

type Ticker
	code::String
	name::String
	long_name::String
	date_time::DateTime
end

Ticker_2

type Ticker_2
	code::String
	name::String
end

Technical

type Technical
	ticker_code::String
	name::String
	description::String
	date_time::DateTime
	previous::Float64
	change::Float64
	ma_1::Float64
	ma_2::Float64
	ma_5::Float64
	ma_20::Float64
	ma_50::Float64
	ma_100::Float64
	ma_200::Float64
	ma_percent::Float64
	ma_return::Float64
	volume_change::Float64
	three_month_change::Float64
	six_month_change::Float64
	week_high::Float64
	week_low::Float64
	week_change::Float64
	avg_week_change::Float64
	avg_week_volume::Float64
	week_volume::Float64
	month_high::Float64
	month_low::Float64
	month_change::Float64
	avg_month_change::Float64
	avg_month_volume::Float64
	month_volume::Float64
	year_high::Float64
	year_low::Float64
	year_change::Float64
	avg_year_change::Float64
	avg_year_volume::Float64
	ytd_change::Float64
	rsi_14::Float64
	sto_9::Float64
	wpr_14::Float64
	mtm_14::Float64
	roc_14::Float64
	ptc::Float64
	sar::Float64
	volatility::Float64
	liquidity::Float64
end

About

Julia package for connecting to the EodData.com XML Web Service.

eoddata.com/products/webservice.aspx

Resources

Readme

License

View license
Activity

Stars

0 stars

Watchers

2 watching

Forks

2 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages