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

I know it's something in my computer like a library that gets corrupted or something like that.

But, on occasion, even before this last update, if I try to change a chart template, or run a scan by importing stocks, that has unknown symbols, Stockalyze will stop working with the Windows 10 message indicating it has stopped working, with option to restart the program or close the program.

When I restart my computer Stockalyze runs fine with no problems.

Example:
After I downloaded and installed the update, I tried changing the Chart Template and Stockalyze crashed. Restarted my computer and everything was fine and still is after 24 hours running.

Thanks,
Tony

You are truly amazing. How quick you can find solutions to our issues. Absolutely amazing.
This is exactly what I wished for. Works like a charm.
The "Don't Ask Again" feature is a nice touch, but I'm happy with what you have developed.

Thanks.


Again, Truly Amazing.

Tony

Hi Sacha. I hope your are well.

I don't know how "Apply Templates" is intended to work. But, I would think that if I want to apply a certain "designed" template, you would only see the indicators defined in THAT template.

That's not the case in my attempts and creating multiple chart templates. There are times when I want to see MACD and RSI and other times I'm looking for AROON, RSI and STOCH. I have two different templates designed for them.

When I apply the wanted template, the newly selected template appends itself to the current template, thus I end up with multiple indicators of the same. (i.e. two RSI indicators, if both templates have them)

So I currently have to Remove all indicators and then apply the template.

Could you either let me chose whether I want to append, or simply remove all indicators and apply the template when I select "Apply Templates".

Thanks for your hard work,
Tony

Once again, an amazing job with quick response and update.

I just ran it, and it appears to work perfectly.

Thanks,
Tony M