Sample Code from Beginner
I am trying to write a simple system that ranks all the stocks in the portfolio based on ROC and then buys the number 1 stock out of a portfolio, when the S&P500 close crosses over its 50 day SMA.

...

Interactive Broker NYSE Advance Decline line
How can I get data on NYSE Advance Decline line through real time IB data feed. I tried symbol lookup and added symbol AD-NYSE-NYSE even tried AD-NYSE but neither worked. Also was interested in Advance

...

Test Halloween Effect on Eurostoxx 50 last 20 years
Hello everyone,

I'm trying to test the halloween (sell in may and go away), January effect or different calendar, efficiency or other anomalies on the EuroStoxx 50 index for the last 20 years (daily close)....

ESignal DataFeed..?
Do you have eSignal datafeed capability or plugins..?

Thanks in advance....

Custom timeframe (candle) database from realtime feed..?
Hi there.... Do you know of a plugin or capabilities of QuantShare to convert on the fly realtime data and store to a customized candle database..?

From some Tick intraday data (dalayed could be) I want...

Continuous futures symbol for Live data feed Interactive Broker
What would be the symbol for ES continuous futures for Live data feed Interactive Broker. Thanks

Tiingo EOD data not working properly
Hi,

I'm trying the Tiingo EOD downloader and the data it downloads is not correct; after troubleshooting I found out the problem: ...

Plotting 3D Surface Plots in Excel using Optimization Data
Hi,

I read how to obtain data from QS to Excel in https://www.quantshare.com/sa-570-reading-and-exporting-data-from-quantshare-to-excel-programmatically ....

New to Quantshare
My name is Christoph, I am using Quantshare for the very first time. I'd like to use the system to backtest a trading strategy based on sentiment data I am currently experimenting with. Am I able to upload

...

Screener emailing results
Hi guys,

Just a quick question, has anyone utilised the email function in Quantshare?...

Arrow on certain dates
How can I program an up arrow to appear on 4/1/17 and 5/3/17?

Question on Proxy Trading
I have found that mutual funds and indices are better suited in generating signals than the corresponding ETFs. I want to generate signals using mutual funds but trade an ETF.

For example, I want to see...

Data from Metastock Xenith (Reuters Eikon)
Is there a way to retrieve (parse) custom data just ending day or session from time & sales (ticks) resolution from Metastock Xenith (Reuters Eikon) from it's now opened API (maybe web)...?

I don't...

Question on going all cash or buying short term treasury etf
Thank you for all your help. It is very much appreciated.

I am looking at a system where if the Momentum conditions are met but the stock price is below its 200 day moving average, I want to buy the short...

Stock Data update
I just want to maintain the daily OHLC and Volume data for about 100 assets. I don't want to spend the time, bandwidth and storage maintaining a 8000+ item database.

How can I do that?...

Helf with Modified Schiff Pitchfork
I am trying to code Modified Schiff Pitchfork drawing tool and was hoping if you can kindly share the code for traditional Andrew's pitchfork that is currently implemented in Quantshare, so I can modify

...

Mutual Fund Data
How can I obtain the daily data of certain mutual funds traded in the US?

Thank you,...

How to obtain volatility of all the stocks in the portfolio?
I am trying to write a system where I need to calculate the average of the volatility and Sharpe Ratio of the all the stocks in the trading portfolio. How can I do that?

Thank you,...

how to compare the returns of multiple ETF pairs?
Say I am looking at 4 ETFs, A, B, C and D.

How can I compare the ROC(A using 40% of capital + B using 60% of capital) and the ROC(C using 80% of capital + D using 20% of capital) ? ...

CSV files of historical 1 or 5 minute forex data?
Hi,
I am a forex beginner. Does anyone know how I can get CSV files of historical 1 or 5 minute forex data? Thank you.

Bi-Weekly Trading
I am a newbie here and trying to learn how to program on this platform. I love the way that both admin and others help out people here.

How can I make sure that a system trades biweekly? ...

How are corporate action adjustments treated with Yahoo Finance
Hi All, I have just started using Quantshare. I am an expeerienced quant analyst for a large institutional asset manager.
As a first step to start exploring this platform, I have started to download some
...

Display Sector and Industry in pivot table rows and in screens
I tried Add Indicator->Database->company_desc-> sector / industry, which gives me this function GetDataCount('company_desc', 'sector');
But the function doesn't display industry or sector.
...

Historical Earnings Calendar doesn't download after Nov 2016
I have the "Historical Earnings Calendar for Major Stock Exchanges" and it doesn't download data after Nov 2016 - gives "27935 Errors" message.
- How do i fix this? I need the Earnings Surprise number
...

Multi-line formula in Ranking system node ..
Want to use Earning surprise (from the eCal database populated by Historic Earnings Calendar data source) as a factor in the Ranking System Analyzer.
However, I need to normalize it (using formula below)
...

Formula
Hi guru,need formula for, z line is below the x and y line,for screening.

Problem with downloading a strategy
I tried to download the following strategy - Weekly ETF Switch V 1.
It gives an error message - Cannot download object. Error while reading stream.
...

Long/short portfolio rebalancing
Hello,

I am quite new to Quantshare and still don't fully understand the intricacies. I am trying to combine a long/short portfolio based on past returns with a...

Survivorship-bias since 1960
Hello,

I am new to quantshare and am trying to download all the quotes for American stock prices since 1960. I am predominantly interested in SP500-listed companies but a ...

Yahoo historical stock market data downloader not working
Hi,
It seems that Yahoo has changed their download interfaces and the downloader does not work anymore. Would you please update the downloader?
...