Date conversion error on Json downloader

Date conversion error on Json downloader

Christian
2020-09-07 06:44:06

Conversion problem with JSON download.

I'm developing a downloader for JSON files.
Meanwhile all quotes are working but I always get an error message for the dates:

Conversion error: "2020-09-07" -- For every day

In the import module I have already changed the format to YMD and I also use "-" as date separator.
Maybe someone has an idea what I am doing wrong here.

Sample data:

{
"isin": "LU1033693638",
"data": [
{
"date": "2020-09-07",
"open": 24.6,
"close": 24.705,
"high": 24.725,
"low": 24.55,
"turnoverPieces": 6151,
"turnoverEuro": 151878.16
},
{
"date": "2020-09-04",
"open": 24.32,
"close": 24.29,
"high": 24.865,
"low": 24.15,
"turnoverPieces": 11535,
"turnoverEuro": 283828.58
}
],
"totalCount": 46,
"tradedInPercent": false
}

Prescript:

System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.InvariantCulture;
for(int i=0;i<Content.Rows.Length;i++)
{
Content.Rows[i].IsIgnoreLine = true;
}

string content = Content.GetContent();
JsonData j = Content.Net.ReadJsonData(content);

JsonData r = j["data"];

for(int i=0;i<r.Count;i++)
{
{
try{

string date = (r[i]["date"] == null) ? "" : r[i]["date"].ToString();
string open = (r[i]["open"] == null) ? "" : r[i]["open"].ToString();
string high = (r[i]["high"] == null) ? "" : r[i]["high"].ToString();
string low = (r[i]["low"] == null) ? "" : r[i]["low"].ToString();
string close = (r[i]["close"] == null) ? "" : r[i]["close"].ToString();
string volume = (r[i]["turnoverPieces"] == null) ? "" : r[i]["turnoverPieces"].ToString();
Content.AddRow(date, open, high, low, close, volume);
}
catch
{
}
}
}

Christian
2020-09-07 09:04:02

Was able to clarify the problem with a colleague.
Obviously the quotation marks are displayed twice.
I have removed them and now it works.
Here is my new code, maybe somebody also need it.

System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.InvariantCulture;
for(int i=0;i<Content.Rows.Length;i++)
{
Content.Rows[i].IsIgnoreLine = true;
}

string content = Content.GetContent();
JsonData j = Content.Net.ReadJsonData(content);

JsonData r = j["data"];

for(int i=0;i<r.Count;i++)
{

{
try{

string date = (r[i]["date"] == null) ? "" : r[i]["date"].ToString();
date = date.Substring(1,10);
// MessageBox.Show(date);
string open = (r[i]["open"] == null) ? "" : r[i]["open"].ToString();
string high = (r[i]["high"] == null) ? "" : r[i]["high"].ToString();
string low = (r[i]["low"] == null) ? "" : r[i]["low"].ToString();
string close = (r[i]["close"] == null) ? "" : r[i]["close"].ToString();
string volume = (r[i]["turnoverPieces"] == null) ? "" : r[i]["turnoverPieces"].ToString();
Content.AddRow(date, open, high, low, close, volume);
}
catch
{
}
}
}

QuantShare
2020-09-08 10:24:46

Thank you for sharing the solution.

Get more messages

No more messages

Back


Trading Items Quandl.com Universal Downloader BSE historical data by date Economic Series Downloader Days To Previous Date Days To Next Date	How-to Lessons How to automatically start a downloader every few minutes? How to debug a downloader How to download new quotes when selecting a chart How to plot the relative performance of several stocks/indices How to plot the number of stock tweets per day
Related Forum Threads Inserting today's date in Downloader field? JSON downloader Historical News Downloader Error Custom date parsing error Muscat Securities Market downloader shows error	Blog Posts 4 Links to Download Free Historical Stock Prices Data by Date How to use date components in your trading rules Troubleshooting a Trading System Introduction to sentiment analysis applied to the stock market Getting Accurate Backtesting Results: Survivorship bias-free S&P ...