Convert EPOCH Time to GMT Time

Finally, you need to adjust the formula for the GMT offset. For example, if you're in New York the GMT offset is -5. Therefore, the final formula is:

=(((B2/60)/60)/24)+DATE(1970,1,1)+(+8/24)

E.g.

 
 
 


  
values:Timestamp
  
GMT8
 

  
1433727278
  
6/8/15 9:34
 

  
1433727545
  
6/8/15 9:39
 

Get Intraday Stock Prices from Yahoo Finance

How to get

Format : http://chartapi.finance.yahoo.com/instrument/1.0/[TICKER]/chartdata;type=quote;range=1d/csv

Example: http://chartapi.finance.yahoo.com/instrument/1.0/GOOG/chartdata;type=quote;range=1d/csv

Example 2:
http://chartapi.finance.yahoo.com/instrument/1.0/0862.HK/chartdata;type=quote;range=5d/csv