303 reputation
16
bio website assylias.wordpress.com
location London, United Kingdom
age 36
visits member for 2 years, 4 months
seen Sep 11 at 7:31

My work combines statistics and programming.

  • I am the author of jBloomberg, a high level wrapper around the Bloomberg Desktop Java API
  • my blog is a combination of those passions.

Jul
24
comment where to find historical option prices?
Bloomberg coverage and reliability (at least on market data, i.e. actual traded prices) are fine. Calculated analytics or greeks may or may not be what you are after as they are model based.
Jul
11
comment Mapping symbols between tickers, Reuters RICs and Bloomberg tickers
@simplethings the Bloomberg equivalent would be AAPL UW Equity.
May
30
comment Best performing stocks in given year
Have you tried HELP HELP? Also if there is no function you can do that fairly easily in Excel.
May
15
comment Forex brokers with free API compatible with Node.js
meetup.com/batsig/events/130829582
Mar
21
comment evaluating portfolio performance without knowing the amount held on cash accounts
@Noobie You need to make an assumption on leverage / cash held, for example by using an average number if that is a fairly stable metrics. For example, if it's a long only strategy, you could consider that the strategy is always 100% invested.
Mar
14
comment Is there evidence that illiquid stocks, held less by institutions, have more price momentum?
@Probilitator Feel free to use the link if you want to answer in more details.
Mar
11
comment Is there evidence that illiquid stocks, held less by institutions, have more price momentum?
No the opposite: they find a (small) momentum effect in liquid stocks but an "anti-momentum" (mean reverting?) effect in illiquid stocks.
Mar
11
comment Is there evidence that illiquid stocks, held less by institutions, have more price momentum?
papers.ssrn.com/sol3/papers.cfm?abstract_id=1800754
Feb
26
comment Bloomberg Alternative for Quant Fund
Why do you need an alternative? Do you need some data that is not available in Bloomberg? Is it a cost issue?
Dec
13
comment Bloomberg interest rate interpolation
They may interpolate based on actual issues closer to the target date than the 2 or 3 year...
Aug
31
comment How to compute the volume of an index from the volume of its constituents?
@EmmanuelBourg On Bloomberg. The sources you have looked at probably show the aggregate volume across several exchanges.
May
2
comment How to determine ratios for mean-reverting basket
You generally regress returns, not prices...
Apr
18
comment how do you evaluate an FX market EMS?
@Freddy You will (almost) always see better prices if you trade directly with the counterparty, not least because the counterparty pays a fee to FXAll. The impact on spreads can be as high as 2/4 pips on major pairs such as EUR.USD (it can be less). Probably negotiable though.
Mar
21
comment Mapping symbols between tickers, Reuters RICs and Bloomberg tickers
Also worth adding the Bloomberg open symbology links. On this one, you can download whole files (bottom left: predefined files) with tickers, names etc. And on this other one you can query securities by external codes (ISIN, SEDOL etc.) and get a file with the corresponding Bloomberg identifiers.
Mar
20
comment Mapping symbols between tickers, Reuters RICs and Bloomberg tickers
Depending on the security, the SEDOL might work better (ISIN don't specify listing place): =BDP("AAPL US Equity","ID_SEDOL1") => 2046251 / =BDP("2046251 SEDOL1","PARSEKYABLE_DES") => IBM US Equity.
Mar
20
comment Mapping symbols between tickers, Reuters RICs and Bloomberg tickers
@Radek On Bloomberg, in Excel for example, =BDP("AAPL US Equity","ID_ISIN") returns the ISIN: US0378331005 and inversely, =BPD("US0378331005 ISIN","TICKER") returns AAPL. You can do something similar with their VBA/C/C#/Java API. I'm not that familiar with Reuters but I would have thought you can do something similar.
Mar
20
comment Mapping symbols between tickers, Reuters RICs and Bloomberg tickers
AFAIK neither Bloomberg or Reuters provide a direct mapping - so the typical solution is to go through a third common code (like ISIN for example) - that requires to have access to both a Bloomberg & a Reuters data source.
Mar
8
comment Is there a comprehensive reference book on US fixed income conventions?
This guide (link towards the end of the post) details several market conventions but does not cover everything you asked for.
Mar
8
comment How to implement a long-term trade on oil?
@Freddy If you go for option 3, you need to carefully select the stocks - not all oil companies make more money when oil prices increase. Typically, services company would be good candidates.
Feb
8
comment Daily returns using adjusted close
@chrisaycock you make the assumption that he keeps the div in cash. If you assume that he reinvests it the result is in line with the ratio methodology. So with the ratio calculation you get a total return history (ie with divs reinvested).