home of great excel tools          
 
Yahoo Realtime Addin Excel Toolkit    

 

(all proceeds will go to the Hokari Minoru Scholarship Fund)

Yahoo! Excel Realtime Addin

Get realtime quotes from Yahoo! finance within Microsoft Excel. Docs and demo included with download - click the ReadMe from the Start Menu or the two example sheets for a demo. You'll need to have Microsoft XML v4 installed on your machine. If you have an up to date machine you'll have that already. Otherwise follow the link below.

Features:

  • Realtime global stock and options qoutes into Excel from Yahoo!
  • Simple and clean interface, use familar RTD function in Excel (e.g. =RTD("GTRtd.RTD",,"yahoo::msft::bid-rt") to get bid price for MSFT).
  • All Yahoo! supplied fields accessible (bid, ask, PE, volume, etc.)
  • Multiple sources can be defined (e.g. Yahoo! US, Yahoo! Australia etc.)
  • Speed of updates can be controlled
  • Updates can be frozen / unfrozen
  • Also get real time data from files (CSV, tab or space delimited from UNIX or Windows sources - great for simulating real time sources in classrooms or cheap pub-sub system)
  • 100% Free!

Downloads:

Screenshot:

rtscreen 

Check out my blog for more information (link above).