Alpha Vantage preferred stock symbols?
Can I get prices for preferred stocks in the Quotes and Exchange Rates extension? Preferred stock symbols are always quirky but I've tried every format I know of and they all produce error messages ("Unable to get rate from to USD").
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
1 Posted by derekkent23 on 26 Dec, 2019 09:08 AM
I am not support staff, just a user.
Hi djxb2000-1
Its possible they are not supported.
Provide say three or four examples along with the ticker symbols and security names and I will test.
2 Posted by djxb2000-1 on 01 Jan, 2020 10:56 PM
Interestingly I have two that are not working (CLNY-J, USB-P) and two that are (EBGEF, NGHCN). The two not working have the tricky symbols that require different conventions depending upon where you. The other two seem to always be the same and AlphaVantage is returning them. CNLY-J and USB-P work with GoogleFinance.
CLNY-J is COLONY CAP INC NEW 7.125% CUM PFD J
USB-P is US BANCORP DEL DEP PERP PFD K
Appreciate your help. These are the only ones I have but I could find more if you need them.
3 Posted by derekkent23 on 02 Jan, 2020 08:43 AM
I am not support staff, just a user
Hi djxb2000-1
Check out the following:
COLONY CAP INC NEW 7.125% CUM PFD J try CLNY-PJ
US BANCORP DEL DEP PERP PFD K try USB-PP
Hope this helps
4 Posted by djxb2000-1 on 03 Jan, 2020 01:59 AM
That works! Thanks so much for your help.
5 Posted by derekkent23 on 03 Jan, 2020 07:46 AM
I am not support staff, just a user
Hi djxb2000-1
Glad I was able to help.
Have Fun.
System closed this discussion on 03 Apr, 2020 07:50 AM.