Send Symbol from Excel cell to active Quantshare chart window
I would be extremely grateful if someone can help me out with this. I have the following Visual Basic code. Idea is when I double click on an Excel cell which has symbol name, the chart of that symbol

...

comp function or equivalent does not seem to be working
//Trying to see if comp produce the correct result on filter
1. when i use just flt it has different set of output
2. when i put flt in comp as filter symbols it has different set of output and way higher...

Monthly Tactical Asset Allocation Strategy Formulas
Hi,
I'm applying the info from two, recent blog posts on how to create tactical asset allocation strategies. I'm building a long strategy based on a universe
of 21 ETFs, filtered at the end of each month,...

How to download Time and Sales data for a particular stock
Hi there,

I am wondering if there is anyway to download "Time and Sales" intraday data for a particular stock? ...

How to export historical data for a list of symbols
I created a very large database and successfully exported that to a csv file thanks to some posts on your forum. Now, I am wondering how I can just
export the historical data for a set of 10 or 20 symbols
...

how to add buy condition when the color change
Hi guru,

Need help in adding buy and sell condition ...

Ranking Stocks By Dollar Liqudidty
Have EOD data for all US exchanges.

I want a list in descending order (from highest to lowest) of the most liquid instruments to the least liquid instrument of the previous day, week, month....

candle programinig
If I Have strategy having following rules how to program in quant share
1) 5 period ema cross 9 peroid ema
2) two green candle above 5 period ema after cross over...

Crash course
I think this software is great. It has a lot of bells and whistles and is fully customizable.

My biggest issue is the way the documentation is disjointed. A newbie doesn't know where to start. There...

Volume Adjusted Moving Average
I want to write my first formula

How do I access the previous trading day's value?...

wget/curl symbol lists in script editr
Quantshare support said

...

Export technical indicators to CSV
I see this

https://www.quantshare.com/item-1601-export-indicators-data...

Using getseries to calculate ema
Hi,

I'm trying to use a filter rule that gets the series for the SPY ETF and calculates an EMA to see if the SPY is closing above it's 75 average....

PROGRAM HANGED
MY SOFTWARE GET HANGED WHOLE DOWNLOAD NEWS FOR STOCKS

How to remove symbols that have zero volume
Hi,

I have a problem with symbols that I download from Yahoo that create incorrect signals, for instance NRE, which have incorrect data (zero volume for some days, close values that jump from zero to...

Earnings Annoouncement Dates
I would like to get the dates for US stocks for the last few years. Is there a way to get that data? All I really need is the symbol and the date.

How can i download additional data not within the standard time period
I need data for the Hong Kong Stock Exchange from 2003. however the data set only seems to go from 2003. I was able to get some data for some stocks the other day updated, but I cannot seem to do the same

...

Automation of download
Is there a way to set the downloader to automatically update every few minutes for my ES futures contract 5 min charts? I see a box that states it can "send updates every X minutes", but when checked it

...

I cannot retrieve database
Please, how do I retrieve earnings announcement data after download is complete

ADX di and Di- indicators incorrect
i am using the following to plot all three on the chart and have found that they are at completely different levels as the same adx indicators on multiple other web sites and trading locations.
this is
...

Getting volume for period of last condition
I'm using the following formula to look up securities rising 20%:

Searchfor perf(close, 30) > 20 ...

Symbol Change
Hi,how do you change the name of a symbol and merge the old symbol data with the new??

WTW changed to WW...

Access the equity value of the portfolio from the simulator
Hello,

Is there a way to access the total value of the portfolio being traded from the simulator ? If for instance I have a system with an equity = $10.000, I want access the value of equity at the start...

Importing ASCII data
I have ascii data in the format: DD/mm/yyyy, HHSS, open, high, low, close, volume
I went to the ASCII importer, then specified the data file, went through each response. I noticed the symbol was added
...

Historical Daily High, Low, and Close for every single stock?
For a 90-day time frame. Any insight is greatly appreciated on how I can find this information... I need this info for every single stock available for every single day within a 90 day time frame. It seems

...

Quotes downloader for NSE scrips
Hi,

I have tested most of the NSE quotes downloaders and none of them downloads any data. ...

How can I loop/iterate over a parameter list?
To a given method, say ref(close, 10), is there anyway to iterate this method over a range of values for the parameter.

For example, I would like to do something like:...

List of functions
Where can I find a list of functions (syntax) and how they are used? I am new to Quantshare and am not a professional trader, coder etc. but can follow examples fairly well. My problem is I don't know

...

Watchlist (New User)
Having trouble creating first watchlist

Historical stock data
For about a year I cannot update stock quotes anymore. What is the best way of doing it now?