Automated Excel Tool for Stock Market Companies - 30/07/2024 07:07 EDT

I'm in need of a customized tool that can list all companies listed on the NYSE, S&P, and NASDAQ stock exchanges. This tool should be able to automatically fetch and update company information from a reliable data source.

Key Requirements:
- Should be developed on Excel
- Must list companies from NYSE, S&P, and NASDAQ
- Display company details in Excel spreadsheet format
- Automate the process of fetching and updating company information

Tool should show following,
1. Company Name,
2. Listed Exchange,
3. Origin Country
4. Ticker
5. Real Time Share Price
6. Real Time 52W High
7. Real Time 52W Low
8. Share Price Proximity to 52W Low
9. Price/Earning (P/E)
10. Earnings Per Share,
11. Last 5Y Average Growth Rate (in absolute value)
12. Estimated Average Growth for Next 5Y (in absolute value)
13. Real Time Yield of AAA Corporate Bonds (same with all stocks)
14. Real Time Corporate Credit Rating of the Company
15. Dividend Payer (Yes/No)
16. Dividend Yield (%)
17. Dividend Yield on Cost (%)
18. Real Time Annual Dividend Paid per Share