The tag has no wiki summary.

learn more… | top users | synonyms

4
votes
1answer
43 views

Obtaining logical lists of Bloomberg security codes in Excel

I am using Bloomberg's BDP and BDH functions in excel to retrieve data for a set of options. The problem is that (as underlying prices move and expiration dates come and go) option strikes are ...
1
vote
0answers
65 views

Review of Excel Stock Simulator

I am currently a senior in high school and I built a stock simulator using knowledge gained from a semester of AP Statistics. I was wondering if someone could tell me if my simulation is ...
1
vote
0answers
8 views

How can I conditionally reorder EPS data in an Excel table using visual basic for applications based on the frequency of the earnings announcements? [migrated]

I have downloaded earnings per share data from Bloomberg for a large number of assets for one year. The resulting table measures 4 rows and around 3000 columns. Some columns contain four values, some ...
0
votes
0answers
142 views

Exporting Time Series Data For Securities Prices From Bloomberg to Excel

I have a list of securities over a thousand entries long that I want to construct a time series of prices for over a specified historical period (e.g. 2/01/10-2/20/10). Doing this manually would take ...
3
votes
2answers
156 views

Resources for finding quantitative finance examples using excel, VBA and access

I am seeking to increase my knowledge in the quantitative finance field. I would be grateful if someone could point me to useful resource online, where I can find working examples of they types of ...
0
votes
1answer
170 views

Data feed for 10 year government bond yields [duplicate]

I am trying to access a data feed for 10 year sovereign bond yields for countries, say the G20. I have tried world bank and IMF data api sources but to no avail. The data feed is used to update an ...
1
vote
0answers
59 views

Clarifying the way in counting number of weeks for calculating historical weekly volatility in Bloomberg

I would like to confirm the way to counting number of weeks for calculating historical weekly volatility in Bloomberg. Given an option with issue date from 14/1/2014 to 13/1/2019, is the proper way to ...
2
votes
0answers
208 views

Which method is implemented by Excel's YEARFRAC for ACT/ACT?

I know the algorithm used by Excel to calculate the YEARFRAC(startDate, endDate, basis) for basis=1. Excel calls the method "act/act". A Java re-implentation of Excel's algorithm can be found at ...
4
votes
1answer
843 views

What is the best solution to use QuantLib within Excel?

Excel is likely the most widespread instrument across all not-only-quants desks; in addition, we have to keep in mind that Bloomberg and Reuters allow to easily import real time data in Excel, and ...
1
vote
1answer
826 views

IMM dates in excel

I need to get the IMM dates in excel. IMM dates are defined as the third Wednesday of every March/June/September/December.
3
votes
3answers
414 views

Loading HF stock data into excel

Are there any free, open source VBA addins or R packages that can be linked using the yahoo finance/Google finance/other data sources api to continuously download intraday data into excel or R? ...
2
votes
0answers
518 views

How to correctly construct a value- and equally weighted portfolio consisting of property-types?

A problem of which I couldn’t find the answer on the forum is about the construction of equally-weighted and value-weighted portfolio. I want to compute the equally-weighted property-type portfolio ...