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 Year to Date Excess Return Days To Next Date Number of Days to a Specific Date Vary the Start Date of a Trading System Simulation	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 code to get todays date Show Date Column when condition was true Dynamic Watchlist Visible Date of first and last bar on chart	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