Back to Community
Using proprietary data from CSV with 'fetch' function

I have a CSV with date, signal, and symbol information linked below. In backtesting, I am able to get the signal data for that date, but I am not able to then trade the security in the 'ticker' column based on the signal. What am I missing when trying to access both?

CSV File

3 responses

Are you saying that you aren't able to access any of your CSV file or are you saying that you can't use the data within the 'ticker' column? Either way, it would be helpful if you sent us your code. I think I recall having to use the sid instead of the ticker when importing CSV files via fetch.

This is what I'm working with. I am able to print out the value of the indicator column for each day, but I am also trying to trade the symbol from the 'symbol' column based on the value in the indicator column for the same day.

Clone Algorithm
7
Loading...
Backtest from to with initial capital
Total Returns
--
Alpha
--
Beta
--
Sharpe
--
Sortino
--
Max Drawdown
--
Benchmark Returns
--
Volatility
--
Returns 1 Month 3 Month 6 Month 12 Month
Alpha 1 Month 3 Month 6 Month 12 Month
Beta 1 Month 3 Month 6 Month 12 Month
Sharpe 1 Month 3 Month 6 Month 12 Month
Sortino 1 Month 3 Month 6 Month 12 Month
Volatility 1 Month 3 Month 6 Month 12 Month
Max Drawdown 1 Month 3 Month 6 Month 12 Month
# Backtest ID: 58757131ddbce6625becc0cc
There was a runtime error.

As an update, I've pulled a basket of securities from the file with a regular expression into a 'symbols' data frame in the latest iteration seen below:

Clone Algorithm
7
Loading...
Backtest from to with initial capital
Total Returns
--
Alpha
--
Beta
--
Sharpe
--
Sortino
--
Max Drawdown
--
Benchmark Returns
--
Volatility
--
Returns 1 Month 3 Month 6 Month 12 Month
Alpha 1 Month 3 Month 6 Month 12 Month
Beta 1 Month 3 Month 6 Month 12 Month
Sharpe 1 Month 3 Month 6 Month 12 Month
Sortino 1 Month 3 Month 6 Month 12 Month
Volatility 1 Month 3 Month 6 Month 12 Month
Max Drawdown 1 Month 3 Month 6 Month 12 Month
# Backtest ID: 58771e0e1a3fbf624529b41f
There was a runtime error.