Please review Stockalyze: https://g.page/r/CYw4g9KFTD6FEAI/review.

Recent posts

#1
Feature & Enhancement Requests / Composite indicator
Last post by Huub Poppelaars - April 21, 2024, 12:35:49 PM
Sacha,

I was using the composite indicator, it is a great help but it has some limitations or I did not use it in the right way.

1) I had made a composite indicator of 3 SMA lines (5-50-100) I had formatted the SMA 5 as dotted, SMA 50 as long dash and the SMA 100 as a solid line, all lines in blue. The composite indicator has all solid lines and different colors. How can I get the formatting as in the chart where I made the composite indicator?
2) I noticed that I can not change the composite indicator or did I something wrong?
3) Is it possible to delete a composite indicator ?

Kind regards
Huub Poppelaars
#2
Feature & Enhancement Requests / Download backtesting results
Last post by Huub Poppelaars - April 20, 2024, 04:46:09 PM
Sacha,

Is it possible to give a user the opportunity to download the backtesting report to Excel?
To get a good idea which backtesting system is the best for my portfolio, it will be helpfull to compare and analyse it in Excel.

The download file may be a csv.file.

Kind regards
Huub Poppelaars
#3
Troubleshooting & Bug Reports / Re: I have installed on only 3...
Last post by Sacha - April 15, 2024, 03:01:30 AM
Hi Ravi,
I have increased your license count. Please try again.
#4
Troubleshooting & Bug Reports / I have installed on only 3 com...
Last post by RAVI - April 15, 2024, 03:00:43 AM
Please correct the situation.
#5
Troubleshooting & Bug Reports / Re: All 5 licenses used
Last post by Sacha - March 26, 2024, 03:46:54 AM
I have increased your number of licenses. Please try again.
#6
Troubleshooting & Bug Reports / All 5 licenses used
Last post by bradbaum1 - March 26, 2024, 03:46:12 AM
previously bought if you would please update online registration database says max tries exceeded
#7
Troubleshooting & Bug Reports / Re: SQL to edit database
Last post by Tony - March 19, 2024, 05:03:06 AM
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
#8
Troubleshooting & Bug Reports / Re: SQL to edit database
Last post by Sacha - March 18, 2024, 11:52:52 AM
Hi Tony,
Sorry for late response. I had read your query but it slipped off my mind to respond earlier.
If I have understood your question correctly then you want to correct the exchange names of the stock symbols you had added to the Stockalyze. If that is so then please read on.

You don't actually need to manipulate the Stockalyze database. You can just delete the price-hist.lyzdb, it will get automatically created again, but before you do that you should close the Stockalyze first. This file is places in "%localappdata%\Lunetek Software\Stockalyze\data".
And before starting Stockalyze again then delete all files in "%appdata%\Lunetek Software\Stockalyze\yahoo_data_download\user_index". This path is for yahoo symbols, if you had added symbols for other data providers then change the path accordingly.
Now, start the Stockalyze and add your symbols again.

If you follow these steps then all the price history will be downloaded from start whenever they will be needed. In case you care about that or you want to take shortcuts you can do other things. Like instead of deleting all files in "%appdata%\Lunetek Software\Stockalyze\yahoo_data_download\user_index" you modify them, they are just text files. You can even create new files. You can copy the file names from "%programfiles(x86)%\Lunetek Stockalyze\data\yahoo_data_downloader".
You can freely delete the tables or their entries in price-hist.lyzdb. You can take backup of this file before you do that.

Please let me know if you need help.


Happy Stockalyzing.
#9
Troubleshooting & Bug Reports / SQL to edit database
Last post by Tony - 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?

Thanks,
Tony
#10
Troubleshooting & Bug Reports / Re: crash with text input
Last post by Sacha - February 03, 2024, 04:53:25 PM
Hi Brain,
I am happy to let you know that we just released a new update that has the fix. Please try again and let us know if you have any issues.