Convert Numeric To Date - Trading Software

Convert Numeric To Date

ymlee
2018-04-26 08:42:38

I received EOD pricing in json format
But the date was store as numeric
How to convert it to date in downloader's pre script?

{"Data":[[3.76,3.77,3.71,3.73],[3.75,3.8,3.72,3.8]],
"Date":[43212,43213]}

QuantShare
2018-04-27 03:43:23

Hi,

If you want to learn how to parse json data, you can check this downloader (pre script)
https://www.quantshare.com/item-1765-daily-historical-data-alphavantage

Regarding the date, you need to contact the data provider and tell them what this number means. Maybe it is the number of days since a reference date.

Get more messages

No more messages

Back


Trading Items BSE historical data by date Days To Next Date Convert Seconds to Trading Bars Vary the Start Date of a Trading System Simulation Indicator/Price Value on a Specific Trading Date	How-to Lessons How to quickly select stocks based on the last value of a databas... How to quickly download the most recent EOD data for your stocks How to plot the relative performance of several stocks/indices How to add future bars to plan for market scenarios How to set order type of a trading system programmatically
Related Forum Threads How to read date and get quote of next day. Watch-list Filter by Date Show Date Column when condition was true Dynamic Watchlist Visible Date of first and last bar on chart Portfolio - Symbols are not up to date error	Blog Posts How to use date components in your trading rules 4 Links to Download Free Historical Stock Prices Data by Date A vector-based language QuantShare Programming Language Tutorial Custom Indicator: Relative Strength