I did have about 2-dozen "DAT" files there. I deleted them and it cleaned up my issue. (yeah)

Thanks,
Tony

First and foremost, Thanks for Stockalyze. I love it.

Issue:
Periodically I rename and rebuild the database because sometimes the Exchange name is not correct and I end up with multiple tickers for the same stock but with different Exchange names. (Minor issue, but it bugs me).

What I notice is when the database is re-created, there are some tickers by default that are duplicated with the wrong Exchange name.

I have attached a sample of ticker: AIRI

Questions:
Does the "New EOD Chart" maintain information from previous database entries?
How do I clean this up? Or Can I?


Thanks
Tony

Cancel my request. I found my registration tucked safely away.

I am moving Stockalyze over to a new computer (yeah). I seemed to have lost my registration information. Can you send it to me, please.

Thank You,
Tony

Boy do I feel stupid. I normally leave that checked, but I remember I entered some symbols a few day back that I didn't have the Exchange Name, and I turned it off and forgot to turn it back on.

Sorry to have not followed the rules of troubleshooting and make sure I have done everything right. (I'm slapping myself right now).

Thank you,
Tony

Sorry, the size limits got me and I didn't realize how small it was.

Attached is a csv file. But I noticed that even before I select the CSV file with the Browse button the Exchange select pull down already contains the text and it's not headers.

Thank you,
Tony

First and foremost, Thank you for all your hard work. You do an amazing job keeping Stockalyze functioning at its best.

I installed the update and things look good, except I usually have the exchange name in my CSV file and select the column it resides in with the "pull down" menu when importing symbols.

Now when I select the pull down it's displaying (in my case) the company names of stocks NOT in my CSV file along with all the exchange names text (NYSE, NASDAQ, AMEX, etc.). The header I needed to select was also there.

I have attached a screenshot to help you.

Thanks,
Tony

Thank you for the response.

I had forgotten about removing the .lyzdb file. You had me do that in the beginning for some other troubles I was having.

Worked perfect.

I'm a happy camper now.

Tony

Hi Sacha.
First and foremost, thank you for continuing to improve Stockalyze. It is greatly appreciated.

Now here is my question:
When I began using Stockalyze, I didn't know much about what I was doing and some stocks got entered without the exchange name, so it has "UNKNOWN" for the exchange. I have since corrected my mistake, but now I have a large amount of duplicate tables for some symbols.
 
One with the correct exchange name and another with "UNKNOWN".

I use SQL Lite.
I know some SQL, but only enough to be dangerous. I have tried to Google my question, but have failed to find the solution.

What would the SQL syntax be to delete all tables with "UNKNOWN" in its name?
Or is this something that should be left alone?

Thanks,
Tony

Well, I'm an idiot. I discovered that the delimiters were set to TAB and COMMA. Which makes sense that it would treat those commas as delimiters.

My bad. Sorry.

Tony

Hi Sacha. I hope all is well with you.

I discovered an issue with scanning stocks.
If I have a CSV file with Tickers, Name, Exchange in columns.
And if the Name has a comma in it, Stockalyze seems to treat it as a tab stop when it wants to add missing tickers to the database, and crashes.
When I removed all commas from my list Stockalyze ran successfully.

I can get around it by removing commas.

Thanks,
Tony

I'm using Windows 10. It's very possible it's my computer doing it, I just don't know how to troubleshoot it.

Thanks,
Tony

Hi Sacha.
This is very minor, but I thought I would let you know of it.

When I scan stocks and I have symbols that are missing, I get the window to add them by selecting what column the NAME is located in the csv file. When I select the column and click OK, the main window pops up, NOT the Stock Screener window. It's displayed, just in the background of the main screen.

As I said, minor issue.

Thanks for all you do to keep improving your baby.
Tony

Thanks Sacha.

I'll take note of anything I see out of the ordinary.

Tony

Something I don't do often enough to remember how, but here are two links to my dropbox.

https://www.dropbox.com/s/exhfjrvz0yfn8z4/stockalyze.exe%281%29.12724.dmp?dl=0

https://www.dropbox.com/s/a1jelqrz74cuayf/stockalyze.log?dl=0


I hope I did it right.

Thanks,
Tony