| User | Post |
|
7:32 am
June 7, 2010
|
charlieliu
| | |
| Member | posts 3 |
|
|
|
10:15 pm
June 6, 2010
|
Jae Jun
| | |
| Admin
| posts 1453 |
|
|
Use this one.
=RCHGetTableCell("http://www.bloomberg.com/markets/rates/corpbonds.html", 1,">Avg Redemption Yld")
Yahoo gets their data from valubond and it looks their service is down or something.
|
|
|
10:08 pm
June 6, 2010
|
Jae Jun
| | |
| Admin
| posts 1453 |
|
|
Are you using the free or the premium spreadsheet?
|
|
|
9:55 pm
June 6, 2010
|
charlieliu
| | |
| Member | posts 3 |
|
|
Hey
I tried changing the code to both codes that you posted. I still get N/A for 20 yr aa corp bond rate resuling in #VALUE at several places. Is there anyway to fix this?
thanks
charlie
|
|
|
1:16 pm
May 31, 2010
|
PresidentClark
| | |
| New Member | posts 2 |
|
|
Worked like a charm. Thanks!
|
|
|
12:31 pm
May 31, 2010
|
Jae Jun
| | |
| Admin
| posts 1453 |
|
|
Could you change the formula above to the following
=RCHGetTableCell("http://finance.yahoo.com/bonds/composite_bond_rates", 2,">Corporate Bonds",">20yr AAA", ">20yr AA",">20yr A")
Instead of a 1, replace it with a 2
|
|
|
12:09 pm
May 31, 2010
|
PresidentClark
| | |
| New Member | posts 2 |
|
|
This does not fix my problem. The problem seems to be with the data on the webpage. The cell is returning N/A which is the yield being displayed on Yahoo.
|
|
|
3:41 am
September 27, 2009
|
Jae Jun
| | |
| Admin
| posts 1453 |
|
|
In the free spreadsheet of the Benjamin Graham valuation caculator, you may get N/A for the values because the Graham bond corporate rate is N/A.
In the company stats area where it says "2oyr AA Corp Bond Rate" change the formula to
=RCHGetTableCell("http://finance.yahoo.com/bonds/composite_bond_rates", 1,">Corporate Bonds",">20yr AAA", ">20yr AA",">20yr A")
|
|
Home
