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?
...

No data
Data for the last two days is not downloading. Last data to download was on 5/12/17. Has something changed?

adjust time settings
It is 12:40 EST. I am looking a 1-minute chart for Silver. The time on the chart is 16:44. How do I adjust the time on the chart so it is showing EST time?

Simulator symbols
I want to back-test a trading strategy against a special list of 30 stocks.
I know how to create a watchList of those 30 stocks, but how do I tell the simulator to use those 30 symbols?

Set 200% margin in Simulator Settings?
Would like to backtest with using 2x or 3x leverage.
I tried setting the Margin (Settings->Margin) to 200%, but the tool doesn't allow me to set above 100%.
...

How to create a Stop Limit
How can I get stopped out if the stock losses 1% or if it gains 5%?

ranking output in simulation
HI All,

I'm using a very simple single node ranking using the simulator ranking system , but when I run the simulation and look at the ranking tab in the simulation report it is blank . I was expecting...