sand112281
Board Regular
- Joined
- Aug 6, 2004
- Messages
- 75
I need some help with trimming/formating some information. I downloaded bond ratings from a website and it returned the ratings and the credit outlook for the bond. eg. AA- *-, BBB- *+, or just AA-, BBB+. The information is in columns with the rating next to the company name. What I want is just the credit outlook for the bonds ( *- or *+ or 0) or some number/symbol to show if it is a positive, negative nor no outlook.
Eg.
Name Rating Outlook
Ford A *+ +
GM A 0
Exxon BBB *- -
Thanks for any help.
Eg.
Name Rating Outlook
Ford A *+ +
GM A 0
Exxon BBB *- -
Thanks for any help.