Since 1962 the median interest of the 10 year treasury is about 6.0%. The current yield is about 2.5%. If the 10 year yield increase 50 to 300 basis points,...
11411
james morlock
kagawonger
Sep 2, 2010 1:56 am
Here are some bond valuation links that may help. http://www.investinginbonds.com/story.asp?id=351 http://www.econmodel.com/classic/calculators/pv1.php ...
11412
newengwongpeggy
Sep 2, 2010 3:55 am
hi Randy, Is it not possible to lookup data if the site is in aspx? i.e. http://www.tradingeconomics.com/Economics/GDP-Growth.aspx?Symbol=usd thx...
11413
Randy Harmelink
rharmelink
Sep 2, 2010 3:59 am
It all depends on how the data is gotten to and how it's presented. But ASPX pages are definitely more difficult, because in many cases you can't get a direct...
11414
slgolding@...
slgolding
Sep 2, 2010 4:29 am
Why doesn't the standard duration formula work to estimate gain or loss per 100 bp change? Sent from my Verizon Wireless BlackBerry ... From: james morlock...
11415
newengwongpeggy
Sep 2, 2010 5:10 am
http://www.tradingeconomics.com/Economics/GDP-Growth.aspx?Symbol=usd if you change the chart to 1990. It would show the data in the chart, but not table. Is it...
11416
Randy Harmelink
rharmelink
Sep 2, 2010 5:31 am
... not table. Is it possible to extract the data from chart? Not possible with the add-in, sorry. How about using FRED instead? Check out the smfGetEconData()...
11417
newengwongpeggy
Sep 2, 2010 6:05 am
thx...
11418
roctripod
Sep 2, 2010 7:20 am
"Bond bond"? Is that a typo or you mean to say "repackaged" products? I realized the shortcoming of Excel you mentioned. A user defined formula would do the...
11419
John
johnroppo
Sep 2, 2010 1:08 pm
If you manage portfolios of individual bonds for investors, it seems you should have software that is continuously updating the prices and duration of each...
11420
melody_of_destiny
melody_of_de...
Sep 2, 2010 2:10 pm
Hi newengwongpeggy. Using data web query, you can get data from the site: http://www.econstats.com/ifs/NorGSc_Jap1_M.htm Like this:...
11421
newengwongpeggy
Sep 2, 2010 2:39 pm
thx...
11422
cwhitehead2000
Sep 2, 2010 4:38 pm
IS there a formula for expected earnings date, the one that appears on the Analyst Estimate Page?...
11423
Randy Harmelink
rharmelink
Sep 2, 2010 4:44 pm
It's element #1285, as in: =RCHGetElementNumber("MMM";,1285)...
11424
cwhitehead2000
Sep 2, 2010 5:38 pm
Wow, thanks!...
11425
Jim H
jharlan
Sep 2, 2010 5:48 pm
I noticed from the Misc folder that the JPG illustrating SMF_Charts.XLS says it's in the Templates folder, but I cannot seem to find it. I'm curious about the...
11426
Randy Harmelink
rharmelink
Sep 2, 2010 6:50 pm
Look for SMF-Template-10-Year-Charts.xls. Are you aware of this group: http://finance.groups.yahoo.com/group/magicformulainvesting/...
11427
Randy Harmelink
rharmelink
Sep 2, 2010 6:53 pm
Also, just a note -- my calculations of the MFI ratios are just an interpretation of them. I couldn't really ever get them to match the numbers on the MFI...
11428
techohio
Sep 2, 2010 9:03 pm
Hi Randy, I'm trying to pull in 6 columns of data for 1020 symbols(rows) into Excel 2010 using the =RCHGetElementNumber formula. I get data on about 422...
11429
techohio
Sep 2, 2010 9:17 pm
Nevermind.. I found the FAQ: What is the smfForceRecalculation macro and how do I use it? I'll check that out and will let you know if I have questions. (p.s....
11430
Randy Harmelink
rharmelink
Sep 2, 2010 9:25 pm
Actually, the smfForceRecalculation macro alone will not solve your problem. You will STILL only be able to access 1000 web pages (the size of the "saved"...
11431
techohio
Sep 2, 2010 9:55 pm
Ok.. so for example, 2 of the data items I'm trying to pull are =rchgetelementnumber(A8,966) (Debt) =rchgetelementnumber(A8,967) (Debt/Equity) for 1000...
11432
Randy Harmelink
rharmelink
Sep 2, 2010 10:31 pm
... how to use it? The "Links" area of the group has two links discussing it. There are also several templates in the "Files" area of the group. ... You can...
11433
hp1mopar1
Sep 3, 2010 12:06 am
I think you can accomplished this with the Excel Price tool. Say you have a 3 year bond with face value 1000, $100 redemption value, 5% coupon ($50 coupon...
11434
chris.mcmonagle@...
chris.mcmona...
Sep 3, 2010 11:00 am
Hi all, I am trying to get market cap figures for a list of tickers. The equation =RCHGetYahooQuotes("IBM",j1,,,) works for some tickers, but strangely not...
11435
delorian212
Sep 3, 2010 1:39 pm
Does anyone know how to pull the pre-market/after hours data from Google Finance? Google's pre/after data is real-time while Yahoo's free data is delayed....
11436
Randy Harmelink
rharmelink
Sep 3, 2010 1:43 pm
Although Yahoo is posting the Market Cap on the web page, they are passing "N/A" into the current quotes CSV file that they provide. You could use one of the...
11437
techohio
Sep 3, 2010 3:00 pm
RCHGetElement # 990 in your spreadsheet shows that it should be Yahoo's Dividend Yield. However, when I use this via the smfUpdateDownload macro or the...
11438
techohio
Sep 3, 2010 3:04 pm
Ok.. Looks like my interpretation of 990 was confused by Yahoo's definition. When I look at the Key Statistics page.. it shows Trailing annual Dividend Yield...
11439
techohio
Sep 3, 2010 3:11 pm
And one last question in this thread, interestingly enough, "ERROR" comes up for Goldman Sachs (symbol=GS) under element #s 990, 975, 976, but the data exists...
