best NASDAQ, NYSE ticker list that is IB API friendly

[Ivano]

I need to daily retrieve NASDAQ tickers(as a bonus NYSE).

From Nasdaq.com i get an excel list, but need to manually select, then need to work out to remove options/warrant(s) and unlisted stocks (because otherwise i get error from the server if i will retrieve a ticker unlisted)*1
I would like a more effective way to get via API the tickers so that can automatize more the process, did you run across this issue or even better can you use a kind of "try..catch" to ignore the error message and load the next ticket?

Note
*1 Via python was able to solve these 2 issues but still need to load the list manually or find a way to scrape

 

[Ivano]

EDIT: I found can use Selenium as a library to automate the interaction with the site and programmatically make all the rest.

EDIT 2 maybe is better if i put a link in automated trading sub forum section!

 

[Quanto]

So, you can use an API to get the data, but cannot parse & filter the received data?
You maybe should hire a programmer to do it for you.
Parsing text files where each item is on a row (line), incl. csv, is easy to do.

 

[Ivano]

So, you can use an API to get the data, but cannot parse & filter the received data?
You maybe should hire a programmer to do it for you.
Parsing text files where each item is on a row (line), incl. csv, is easy to do.

>Yes i can use the API to get the data,
Correct.

>but cannot parse & filter the received data?

I can do it, but as OP and programmer I would gracefully avoid to do that.

As an OP because I am asking if one of you can recommend a "ticker list" that is better than the one I have to access as a programmer from Nasdaq.com implementing techniques as browser automation/or scraping, really error prone procedures, not future proof, and terrible in terms of performance, not too mention my dermatologist asked me to avoid everything based on javascript, whereas maybe you know an API i can call with just the common stock prices without implementing BL that could backfire if there are server kinda breaking changes.

Also as an OP i am asking for a way that someone more experienced than me with the IB API knows to prevent that i get an

```
ERROR 27 200 No security definition has been found for the request
```

so that I can fetch a wrong ticker, in this way and i could add a log without blocking the execution of the program with a try catch proven bulletproof construct or whatever nice workaround.

>You maybe should hire a programmer to do it for you.
thank you for the suggestion, would like to look on freelance.com to find someone called Jim S., not too much luck so far.

>Parsing text files where each item is on a row (line), incl. csv, is easy to do.

Sure it is, but life is not only software engineering but also data engineering, is conceptually wrong to do it, when you can work upstream a better solution as a real API, of retrieving better data quality.