Please review Stockalyze:


Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Topics - Tony

Troubleshooting & Bug Reports / SQL to edit database
March 14, 2024, 09:46:58 AM
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?

Troubleshooting & Bug Reports / Scan Stocks Crashes
August 25, 2023, 07:31:53 AM
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.

Troubleshooting & Bug Reports / Scanning Stocks
May 19, 2023, 08:03:37 AM
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.
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.

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.

Troubleshooting & Bug Reports / Chart Templates
February 27, 2023, 09:30:21 AM
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,
Feature & Enhancement Requests / Portfolio Import
January 04, 2023, 09:14:36 AM
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?

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.

Tony M
General Discussion / WELCOME BACK SACHA
April 23, 2022, 05:25:04 AM
Whew. Finally relief. I am very happy to see you back.

I have had to resort to manually filtering my stock along with replacing my computer.

Since the change of computers, I have lost the registered copy of Stockalyze. I will gladly purchase another copy if needed.

Welcome back. I have certainly missed you.
Hi Socha.

I have a strange thing happening with a text file of stock symbols I am trying to scan.
I am using Yahoo as the data provider.

In the text file of 60 symbols is a symbol (LK - Luckin Coffee Inc.) and when I import the symbols, Stockalyze thinks the symbol is LKAI. That is, if I look at the import window of symbols, LK is not in the list but LKAI is.

The symbol does not show up as missing, though others in the list do as expected.

If I try to chart LK, it is not in the database. I'm sure I can add it, but I haven't yet, in case you need more information.

I have attached a snapshot of the import window showing the LKAI symbol.

Thanks Sacha,
General Discussion / Duplicate Symbols in Database
October 31, 2019, 11:31:17 AM
I notice that when I use a symbol from the AMEX exchange via Yahoo, there are two symbols that show up. One from AMEX and other from NYSEMKT.

Are they in fact two separate entries in the database?

Which one would be the correct one to use?

Should I delete one of them?

General Discussion / Question on historical data
October 25, 2019, 10:04:00 AM
Hi Sacha.
Just a question on when historical data is downloaded.

Early on in learning Stockalyze I thought running a trading system on a list of stock symbols would download the historical data.

But now when I run a trading system, and then chart a symbol, I get the brief message "waiting for price history" then the chart is displayed.

So my question is:
How did the system run a trading system and use historical data when, by displaying a chart for a symbol, Stockalye needs to retrieve historical data?


Feature & Enhancement Requests / Missing Tickers
October 04, 2019, 11:09:53 AM
Sometimes I get tickers from FinViz or other websites and I want to run those tickers through
stockalyze Backtesting, etc.

When a ticker is missing (sometimes the list can be more than five) is it possible to have an option in the popup window listing the missing tickers, to add these tickers then, instead of canceling your operation to add them, then re-start your operation?

Presently I have a screen capture utility to capture the tickers so that I remember which ones they were.

Your thoughts.
Troubleshooting & Bug Reports / XML parsing error
September 12, 2019, 04:26:21 PM
I'm using version build dated 9/8/3029 and when I launch it I get an error "XML parsing error: 'unclosed token' at line 27".

I thought it may be related to my alert file since I seem to have lost them.

I looked at the altert_repo file and it was missing the close "/>" symbol on the last line.

Once I corrected it all is fine.

These are the last few lines of the file BEFORE I corrected it:
  <AlertSetting Type="10" PriceOfInterest="25.0000">
    <Security Name="Yahoo!|US.AMEX.STOCK|ESP" LastEvaluationTime="20190910152401000">
      <Alert TimeStamp="20190812000000000" Status="2"/>
      <Alert TimeStamp="20190813000000000" Status="2"

Not sure how it removed or failed to put it in the file.

Troubleshooting & Bug Reports / Small Issues (annoyances)
September 10, 2019, 04:24:34 PM
Hi Sacha. I hope all is well with you.

I have some small annoyances that I hope you can remedy while you address more important issues.

When displaying a chart I must click it to make it the active window in order to scroll to my indicators.

When changing the time span in a chart, sometimes the info boxes on the left do not appear, when you change back and forth they will finally appear.

When changing time from 2 year to 3 months, the 3 month display isn't the current timeframe, in my test, it shows timeframe of 5/18/2001-8/16/2001 after viewing a 2YR chart and switching back to 3M. Can you default it to current timeframe on the right side of the chart?

The report generated by "Scan Ideas", can you re-draw the shading when you re-sort the list? Now, The shading "follows" the item, so they become bunched up. Sometimes I sort by Signal, and othertimes I sort by Last Price depending on my objective.

When you display a chart of an ticker, you lose the highlight on the report. Can you keep the row highlighted so you don't lost track of what you just viewed when viewing the chart and going back to the report?

I know these are very minor, but I just want you to know how "we" use your program, and what can be done to improve it.

Love all the recent changes you've made. Thank you for all your hard work.

Troubleshooting & Bug Reports / Transaction Price Date
August 02, 2019, 11:51:38 AM
I notice that when I enter a new transaction (ticker:YTEN) and choose yesterdays date, since you can't use today's date, the transaction price used is today's price, not yesterdays price.
In the example yesterday's(8/1) close price was .82 and today's current price is .85.
When I enter the transaction and use the button to Get Price, it uses today's price as the transaction price.
I can enter the correct price and it's fine.

Question: Shouldn't the "Get Price" use the date selected for the price? It seems to default to "latest" price.

Hi Sacha.
I notice that when I sort the portfolios, the chart display doesn't change.
I hope I can explain clearly.

If I display a portfolio then select a line within the portfolio, the chart changes.
But then sort on a different column, the chart doesn't change and the highlight bar doesn't de-select in it's line position, and you can't display the chart on whatever the new line item is under the selection, until you select a different line then go back.

It looks like the highlight needs to follow the item when re-sorting instead of staying stationary on the re-sort.

To me it's not a terrible thing since the work around is to select another item then go back.


Hi Sacha.
I have noticed that if I view the "Consolidated" portfolio, I can sort by each of the columns.
But if I view a specific portfolio, and sort, say on the %Gain column, then if I select a different column heading to sort, I can't go back to the %Gain column and re-sort unless I select a column that has not been sorted on yet.
I notice that when I sort on a column within a specific portfolio, the little triangle indicating the direction of the sort doesn't go away when I select a different column. But it does in the "Consolidated" listing.
I hope I have explained this clearly.

I entered UBER as a new security.
I have a default chart template setup to include the MACD indicator along with other indicators and zones.
I get an exception error when I try to chart the UBER ticker. I have to "abort" to close Stockalyze.
If I remove all indicators and zones, it displays the chart (Price, Volume)
I then tried to add the indicators, one at a time. When I enter the MACD indicator it crashed Stockalyze.
Now, I don't want the MACD or any indicators for that matter, for an IPO, but can Stockalyze be setup to ignore the default chart and use a basic (Price, Volume) when there is not sufficient data to display/calculate the indicators or zones?
Troubleshooting & Bug Reports / Registration
April 30, 2019, 05:57:28 AM
Hi Sacha.
You were gracious to allow me to use a registered copy of Stockalyze because I was having problems.
Now I am purchasing a copy because Stockalyze is awesome.
But when I go to the "Register" in the Help, it tells me that it's already registered.
When I launch the application it tells me that I only have 6 days left.
How do I enter my new registration?

General Discussion / Create a Trading System
June 03, 2018, 07:43:16 PM
I'm now advancing into creating some trading systems that I use online and am trying to replicate them in Stockalyze.
And I need help.

What I'm trying to create is a RSI(10) Bearish
Here's the criteria:

RSI(10) crossed below 70
and RSI(10) 1 day ago was above 70 for the last 5 days

I tried adding a sub condition for the "and" part to no avail. I then tried adding a condition for it and again nothing. Maybe I still am not understanding the X and Y days and how I can include an "and" criteria.

I have some tickers that fall into this criteria, but when I run it against them I get zero hits.
Can you help me?