The following lines of code in Python
r = requests.get("https://paper-api.alpaca.markets/v2/assets/SGAM",headers={"APCA-API-KEY-ID":"KEYID","APCA-API-SECRET-KEY":"SECRET"})
print (r.text)
returns
"id":"bdc9ac8c-2131-4b39-896b-483ae9586b28","class":"us_equity","exchange":"NASDAQ","symbol":"SGAM","name":"Seaport Global Acquisition Corp. Class A Common Stock","status":"active","tradable":true,"marginable":false,"shortable":false,"easy_to_borrow":false}
It shows the stock status as “ACTIVE” but its not active actually – https://www.otcmarkets.com/stock/SGAM/news/story?e&id=1761518.
Please make the appropriate changes.
Thank you for pointing this out. Ticker SGAM shows as able to trade, however one get’s an error failed to calculate cost basis when trying to place an order either via the API or the web.
This is a special case since SGAM just began trading on 2020-12-09. However, it probably shouldn’t have the tradable and active attributes set to True if one cannot actually trade it. I’ve logged this issue with the Alpaca engineering team. Sorry for the inconvenience.
Thanks for the quick response. Can you add a field like “ipoDate” or “tradingStartDate” that we can use to filter for such stocks?
Also, is there a way to find all holdings in SPY using alpaca api?
All the following have the same issue
BRLIR has an error in data
CEFA has an error in data
CHB has an error in data
SNRHU has an error in data
DHCNL has an error in data
ESSCR has an error in data
FDUSL has an error in data
GBLIL has an error in data
GECCM has an error in data
GECCL has an error in data
GFNSL has an error in data
GRNVR has an error in data
HCAPZ has an error in data
HCCHR has an error in data
IBTK has an error in data
KCAPL has an error in data
LOACR has an error in data
MCACR has an error in data
NBACR has an error in data
HTOO has an error in data
GLAQU has an error in data
CTAQU has an error in data
HYFM has an error in data
RMGBU has an error in data
ADOCR has an error in data
SHLD has an error in data
ZGYHR has an error in data
CERT has an error in data
SGAM has an error in data
AGBAR has an error in data
ANDAR has an error in data
CMFNL has an error in data
NEWTI has an error in data
OFSSL has an error in data
TOTAR has an error in data
VTRN has an error in data
MACU has an error in data
LEGOU has an error in data
I looked at several of the stocks in the above list. I show them as tradable, and also am able to trade them. What specifically is the issue you re seeing? The error not being able to trade SGAM on 12-10 was because it had just began trading on 12-9. It was sort of a fluke.
To answer your other questions. Typically, stocks will be available to trade on the first day they are listed on an exchange. To check if a stock can be traded, simply query the tradable attribute of the asset. Again, SGAM was sort of a bug where that didn’t work.
“is there a way to find all holdings in SPY” The simple answer is no. SPY follows the SP500 index which the S&P Dow Jones Indices guards pretty closely. One needs to pay them money to find out what the current holdings are. Technically SPY, being an ETF, is required to file a list of all its holdings with the SEC every quarter. There are data providers which provide these holdings but I am not aware of specific ones. In any case, the data is always one quarter behind (though the SPY holdings don’t change very often). A good proxy for SPY is to take the top 500 stocks by market cap and then weight them by market cap. It’s not perfect but it will track SPY, and the SP500, pretty well.
These ones are not working…
LEGOU
SNRHU
MACU
HTOO
GLAQU
CTAQU
HYFM
RMGBU
ADOCR
CERT
SGAM