Updates to a custom database
I have a custom database called mktcap, it only contains the date and the mktcap of a stock,
now I have noticed that each time I update the latest market cap of a symbol, a new row is created in the database
...

Weekly Prices in a QS Watchlist formula
I am looking to create a watchlist that is filtered by applying a fornula on weekly prices of stocks. I am not sure how to get the weekly stock prices in a formula ? can you please show me an example

...

Data for Cryptocurrencies
How can I download data for cryptocurrencies? I use to have it, but when I opened the software today, everything was gone.

Analyse your own data ?
Hi Guys

Completely new to this - so apologies if this a dumb question - but can you analyse your own data set - for example, in its simplest form just time, traded price and volume ?...

Watchlist Column order
1. I am using the AddColumn function to add columns to a watchlist but the columns do not appear on the watchlist grid in the order in which they are added, how can I force column order ?
2. For most of
...

Changing Colour of Graph Crosshairs and Date OHLC values
1. I would like to change the colour of the crosshairs as I prefere a chart with black background, trouble is the crosshiars also seem to be black so I cannot see the cross hairs.
Is there a way to change
...

SMA of SMA return NAN sometimes even though there are enough bars
I have the following code for my chart

xa = stddev(close, 10);...

Selling according to the buy day data
Hi,

if I want to sell according to buy day data, which function must I use?...

Rules Analyzer - Error in Formula
Hello,

Great software so far, really impressed with the functionality. One area I'm having trouble with, however, is the Rules Analyzer. Whatever I seem to put in comes up with a formula error. ...

I do not get it, how do you get the data?
Just want to pull data for algo.All I see is an .exe program and I do not run windows.

Google intraday downloader stopped working.
The Google intraday downloader doesn't seem to be working for me.

Does anyone have a source for free intraday data? ...

Exporting optimized test data from trading report
Hey All,
i am testing various entrance and exit methods over a time period with different optimizations and i wanted to ask if there was a nice easy way to export the optimized basic info from each entrance
...

Deleting Quote data for a symbol from the Database
How can I delete quote data for a symbol (either all data or some data for a particular date) in a C# script rather than manually. Thanks

problem with backtesting ^dji
i am testing a simple entry moving average for performance and the system will not make any buys after 1/26/1996.
When i isolate the test to the time frame where no trades are made the test gives me the
...

Rotation of strategies based on their performance
Anyone can explain how to do that with the program?

Symbol Management using C# scripts
Is there a way to manage symbols using C# scripts so that I can insert, delete and update them. I would like to automate this,
rather than use the Symbol menu to do things manuallly.
Thanks....

Unable to use Symbols.GetSymbols() in a custom downloader URL script
I'm adding a new custom downloader. I am creating a URL script so that I can download end of day data for various instrument types such as stocks and currencies.
In the URL script I am unable to call
...

Lower of formula
Is there a formula such as the "lower of" two values?
for example I'd like to plot the lower of two indicators when using an exit. such as the lower of an SMA and the SAR for example
...

How to Turn any ordinary trading strategy into a profitable one
I need help trying to follow this article
I have a pretty good trading strategy let alone ordinary, however i'd love to know if i can make it better. I came across this article
https://www.quantshare.com/sa-289-how-to-turn-any-ordinary-trading-strategy-into-a-very-profitable-one...

ATS orders not in IB
Hi,

I have created an Automated Trading System with Portfolio but the orders do not appear in IB....

Simulation and equity Invested doesn't correspond to equity settings
Hi there, can someone tell me what the allocation of equity is based on
I'm running a simulation on one share with a 100,000 capital, and investment of 100%
yet on its trade selection it uses only 20%...

Ability to remove fill colour for rising candlesticks only.
I have a candlestick graph for a stock and am applying a trading system which changes the colour of the candlestick, wick and its border, however to distinguish between rising and falling candlesticks

...

Add earning dates for 1000 symbols
I've created a database to add a single field (Earning Date) for 1000 stocks - in a year, this database will have only 4 entries (the 4 earning dates).
Would like to use this database to report the Price
...

hourly bars bottom of the hour
how can I configure hourly bars to close on the bottom of the hour ie one hour bar open at 8:30 and close at 9:30?

Recover a custom database
Hello, i had an error that said my account file was corrupt. I was then prompt to create a new file. I backed up the old QS folder and then had the system create a new one. I then reloaded my account however

...

Change EPS revisions by week (average and # of analysts)
Is there a data source/download object that provides
1) Change in Average EPS revision over the last week?
2) Net revisions (up or down) in EPS estimates over the last week (or month)?...

How to get stocktwits historical data?
I have just started using QuantShare again after about 7 years. Last time I was on I downloaded the stocktwits downloader.
And as a result I have some stocktwit data for 2009 and 2010. Downloading again
...

Is there an Updated EOD data for Delisted Stocks?
Hello, I downloaded the Historical EOD data downloader for Delisted and Bankrupt stocks, but there are quotes only until 2012. Is there an updated version of this?

Coding Question Applying an Indicator to an Indicator
I'm having some issues with getting the code right with creating an custom indicator that can be charted and used in a screener that applies an indicator to another indicator.
Specifically, I'm trying
...

Results DISPARITY
I have created a following trading system

-------------...