Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Is there a way to add support for OTC/Pink Sheets? #165

Open
jasonkhanlar opened this issue Feb 22, 2021 · 0 comments
Open

Is there a way to add support for OTC/Pink Sheets? #165

jasonkhanlar opened this issue Feb 22, 2021 · 0 comments

Comments

@jasonkhanlar
Copy link

jasonkhanlar commented Feb 22, 2021

Is there a way to add support for OTC (Over-The-Counter) / Pink Sheets?

For example I found

https://www.otcmarkets.com/glossary#otcqx

"The OTCQX Market is our best market, for companies that meet high financial standards and are current in their disclosure."

https://www.otcmarkets.com/glossary#otcqb

"The OTCQB Venture Market is for early-stage and developing U.S. and international companies."

https://www.otcmarkets.com/glossary#pink-current-information

"Companies that provide adequate current information to the market pursuant to the International Reporting Standard, the Bank Reporting Standard or the Alternative Reporting Standard, or are current in the SEC reporting obligations are designated as Pink Current Information."

Edited to add: Out of the box, I didn't find some example OTCQX/OTCQB stocks, when I typed them in the dropdown menu textbox at the top of the main "Stock Watchlist" tab. I found on the menubar: Database > Stock Database... > User Defined: manually typing 1 by 1, and clicking "OK" then I can search for those stocks when I type in the dropdown menu textbox at the top of the main "Stock Watchlist" tab. Is there a way I can automate this process for adding ALL of the OTC stocks to be queryable?

Edited to add: For each of the market snapshots listed at https://www.otcmarkets.com/market-activity/indices, I downloaded the XLS spreadsheet data for all of the constituents for each of the 3 top quality rankings, manually converted the data to 2 columns quoted CSV values for "Code" and "Symbol" to match the contents in my ~/.jstock/1.0.7/UnitedState/database/user-defined-database.csv file (which is not the best maybe, because a lot of the symbols are from countries other than "United States" (note: the directory "UnitedState" is missing an "s" at the end)), sorted, and removed duplicates, and applied the data to file ~/.jstock/1.0.7/UnitedState/database/user-defined-database.csv - Maybe, is there a way to automate this process too?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant