Hot answers tagged monthly
All of these index constituents are available on Bloomberg and through Bloomberg Excel link. Just use one of those Index member formulas with a date override. http://libfaq.smu.edu.sg/a.php?qid=2998
You can have a look at this QUANT - Blog. You can get NDX100 and SP500 historical index constitution.
I have laid out below one way of solving this kind of problem. You have your timeline right and I have reproduced it with the correct amounts. The way to discount your 30Ks is the same as discounting 1,500K if you do it this way. Basically, you need to compute a discount factor. To calculate this discount factor, you need to de-annualize your interest rate ...
You are doing it right. The differences are rounding issues and can be safely ignored for any practical purpose.
When speaking with quants, I call such things Boundary Conditions. With traders I tend to use Terms or Features.
You can use Cubic Splines to convert quarterly data into monthly. See also the following: https://columbiaeconomics.com/2010/01/20/how-economists-convert-quarterly-data-into-monthly-cubic-spline-interpolation/ Update: Take a look at the following link too: http://answers.microsoft.com/en-us/office/forum/office_2010-excel/cubic-splines-in-excel-2010/...
You can get this information by 'web scraping' - running a script (Python is ideal) which visits the relevant websites and extracts the prices from the HTML, then packages it into a suitable form (eg XML) and saves to disk. The only drawback is that the script needs fairly regular maintenance, as the pages you are getting the information from tend to be ...
Only top voted, non community-wiki answers of a minimum length are eligible