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

Thanks. I can only imagine how you can get backlogged in ideas with a project like this.

Tony M

Hi Sacha.
I just had a thought. I know that data for a portfolio is kept in an XML file. Is it possible to import Symbols into a portfolio? If I build a portfolio for and industry for example. I have a csv file of symbols and prices. Is this possible?

thanks,
Tony M.

Hi Sacha.

I haven't communicated with you in a while.
That's because your program has been awesome and I have had  no problems with it and I have it set up just the way I like for my portfolios and backtesting.

But, I have noticed lately, that when running a scan of stocks and I switch to another application (mostly Office Excel 365), the scan will "pause" after a varied number of tickers. And if I activate the results window, it will proceed and continue where it left off.

I can't say if any of the recent upgrades has brought this on or it's been there all along. Just that recently I have been using other Applications while Stockalyze is scanning.

Thanks,
Tony M