[Excel Question] Automatically update daily Yield/Bond rates

So I'm looking to implement a tool into our proforma to feed our debt assumptions. Typically when we get serious about a deal we start to call our lenders and get quotes on base+spread. Since we usually take 10yr fixed rate debt on all our deals, the vanilla Fannie/Freddie loans usually work for us. That being said, our spreads are pretty consistent, leaving the 10yr Yield for the that day to set the rate.

Question being, is there a way to have a cell or cells that automatically source data from a website that would display these rates? Has anyone implemented something like this? I attempted to use Data>From Web, but couldn't get it to work.

This way whenever I open a new proforma, my daily debt assumptions would be automatically updates. Call me lazy, but I believe in reducing redundancy. Any help is greatly appreciated.

7 Comments
 

Definitely possibly, but you will need to use VBA to query a website and pull the data into excel, I did this a few yrs ago when doing research but don't have the code..just google it or ask your coder buddies

 

I have been thinking of a way to do this as well. Using the Data>From Web tool worked to import a table of indices that I can link to my debt calculations. In your case, what was the problem? Was the data not updating?

 

Repudiandae voluptates qui et necessitatibus accusamus consequatur corporis. Fuga sint sit vel. Iste rerum occaecati aut quibusdam. Dicta ipsum itaque sed repellendus qui laborum porro. Nihil minima expedita tempore enim dolorem magni.

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 04 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (17) $409
  • Associates (58) $261
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (77) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
dosk17's picture
dosk17
98.9
6
DrApeman's picture
DrApeman
98.9
7
GameTheory's picture
GameTheory
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
CompBanker's picture
CompBanker
98.9
10
Linda Abraham's picture
Linda Abraham
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”