320 reputation
17
bio website assylias.wordpress.com
location London, United Kingdom
age 36
visits member for 2 years, 5 months
seen 1 hour ago

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.

Oct
6
comment finding the strike / maturity of warrants given their ISINs
I don't know optionmetrics.
Sep
23
comment Bloomberg Pricing Sources: TRAC vs. BGN vs. BVAL etc
TRAC only reports trace eligible trades (see TRAC <Go> for more info). BGN is indeed an old version of BVAL. For more info on BVAL: BVLI <Go>. HELP HELP should be able to give you that information too.
Sep
16
comment Exporting Time Series Data For Securities Prices From Bloomberg to Excel
The Excel addin is included in your subscription - so if you have a Bloomberg terminal you also have access to the Excel addin...
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.