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 BSE historical data by date Quandl.com Universal Downloader Equity and Date Export To Excel Number of Days to a Specific Date Historical EOD data Downloader for Delisted/Bankrupt Stocks	How-to Lessons How to automatically start a downloader every few minutes? How to debug a downloader How to adjust a stock for splits How to download earnings calendar data for various stocks How to add custom position-based metrics to your trading system
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 How to download the history of dividend payments for stocks in th... How to make sure your Historical Price Data is Split Adjusted Getting Accurate Backtesting Results: Survivorship bias-free S&P ...