yccheok / jstock

JStock is a free stock market software for 28 countries.
https://jstock.org
657 stars 345 forks source link

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

Open jasonkhanlar opened 3 years ago

jasonkhanlar commented 3 years ago

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?