Index | Recent Threads | Who's Online | Search

Posts: 13    Pages: 2    1 2 Next
Last Post
This topic has been viewed 371 times and has 12 replies
danp
Operations added to the API for Stock Factor and Data Series

There are 6 new API operations available which create/update, delete or upload data to an imported data series or stock factor:
data_series_create_update
data_series_delete
data_series_upload
stock_factor_create_update
stock_factor_delete
stock_factor_upload

The API page in the Knowledge Base contains information and examples for each operation.

The code for the examples is here

You will need to update your p123api package to access these new operations. This is done by running the following at a command prompt: pip install -U p123api

Apr 26, 2021 9:42:32 AM       
Edit 1 times, last edit by danp at Apr 26, 2021 9:44:21 AM
azouz110
Re: Operations added to the API for Stock Factor and Data Series

Thank you.

Would it be possible to add the ability to upload stock factors without triggering the unknow symbol error. Just ignore these or add an option to ignore them.

If there is a lot of symbols that doesn't match P123 symbols then it really time consuming to remove them all as the error displayed by P123 doesn't show all unknown symbols.

Apr 26, 2021 6:41:47 PM       
azouz110
Re: Operations added to the API for Stock Factor and Data Series

I see that it is possible to ignore errors in the API. That is good. Maybe it could be added to the website as well.

Apr 26, 2021 6:43:25 PM       
danp
Re: Operations added to the API for Stock Factor and Data Series

The website will also have the option to ignore errors and the other enhancements you see in the API. Those changes should be released this week.

Apr 26, 2021 7:46:18 PM       
azouz110
Re: Operations added to the API for Stock Factor and Data Series

Great. Thanks.

Apr 26, 2021 8:02:26 PM       
InspectorSector
Re: Operations added to the API for Stock Factor and Data Series

Hi Dan - it will be a while before I try these new API features but I was wondering how to call up the data series or stock factor within P123 screens, ranking systems, ports, etc.

Thanks
Steve

Apr 27, 2021 3:33:09 PM       
danp
Re: Operations added to the API for Stock Factor and Data Series

Hi Steve.
This page in the knowledge base explains what imported stock factors and data series are and gives some examples of how they can be used. Please read that and let me know if you have any questions or examples you want me to go over. I have not yet updated that page to reflect the new functionality, but I will do that on the day those functionality changes go out to the web site.

Apr 27, 2021 3:57:55 PM       
geov
Re: Operations added to the API for Stock Factor and Data Series

Would it be possible to add the ability to upload stock factors without triggering the unknown symbol error.
If there is a lot of symbols that doesn't match P123 symbols then it really time consuming to remove them all as the error displayed by P123 doesn't show all unknown symbols.

P123 must have all the old stock symbols in their system and their matching currently recognizable symbols. It should be easy to automatically converted the old to the current symbols when uploading stock factors.

Apr 27, 2021 4:00:04 PM       
azouz110
Re: Operations added to the API for Stock Factor and Data Series

This is not the case. A lot of symbol names are dropped/renamed. When I tried to upload factors with P123 symbols (from 2000 to 2019) I have downloaded one year ago, I found out that at least 5% (and even more) of the symbols has changed. The value is too high and I am not sure why.

Apr 27, 2021 9:05:41 PM       
geov
Re: Operations added to the API for Stock Factor and Data Series

According to P123:
For the key column, you must specify either a Portfolio123 StockID, current ticker, GVKey, current CUSIP, or CIK, matching the identification specified in the header.

Question is whether for unlisted stocks any of the above can be matched to the old ticker symbols automatically. So where can one find a listing of all the Portfolio123 StockIDs, for example? And showing my ignorance, what is a GVKey or CIK, and where can one find them.

Apr 28, 2021 7:47:39 AM       
Posts: 13    Pages: 2    1 2 Next
 Last Post