XJO
Click for more information
0.13% 8,187.4 s&p/asx 200

Can Excel it if you need yyyymmdd as integer, files back at...

  1. yellowgsum
    11,522 Posts.
    clock Created with Sketch.
    14/04/08
    10:31
    Post #: 3583034

    Can Excel it if you need yyyymmdd as integer, files back at home, but something like Bx=Year(Ax), Cx=Month(Ax), Dx=Day(Ax) etc, then Ex=10000*Year+100*Month+Day.

    Can only Excel dates after ~1900 though, anyone here an Excel wizz?

    Got some C# code somewhere that does similar, can email you the file, [email protected]?

    Anyone with a good site for complete S&P500 historicals?

    Cheers.




    XJO Value at posting: 0.00
    Likes Created with Sketch.  Upvote
    lightbulb Created with Sketch.  Great analysis
    Stroke 3 Created with Sketch. Comments Created with Sketch. Reply

  2. Top Stories

 

Featured News

RCE Phase II clinical trial recruitment for R327G topical gel passes halfway, showing promising results against bacterial skin infections
right-arrow Created with Sketch.
NEWS Most viewed thread today: Exceptional Niobium Intercepts at the Stinger Discovery
right-arrow Created with Sketch.
MTL RC Drilling has commenced at Roberts Hill and Mt Berghaus
right-arrow Created with Sketch.
NEWS Copper-gold and lithium targets at Lake Johnston heat up as new drill prep and surveys advance promising prospects
right-arrow Created with Sketch.
NEWS FDA clearance secured for AI-enabled EchoSolv AS – ready for rapid U.S. market launch
right-arrow Created with Sketch.
AHK Mining lease application submitted for Sandy Mitchell rare earths and heavy minerals project
right-arrow Created with Sketch.
watchlist Created with Sketch. Add XJO (ASX) to my watchlist
(20min delay)
Last
8,187.4 		Change
10.500(0.13%) 		Mkt cap ! n/a
Open High Low
8,176.9 8,226.7 8,173.8
XJO (ASX) Chart
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.