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 Derivatives: Number of days until the expiration date Year to Date Excess Return Days To Next Date Number of Days to a Specific Date Convert Seconds to Trading Bars	How-to Lessons How to synchronize stock charts? How to create a screen 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
Related Forum Threads How to read date and get quote of next day. Inserting today's date in Downloader field? How do you sort simulations by the date that the simulation was r... Lookup Earnings Announcement date and trade on post-earnings day Custom Date Format When Importing Data from CSV	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