CSV Bulk import date format - Australian format ?

Does ShareSight support australian format date in CSV files for bulk import ?
1 person has
this question
+1
Reply
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned happy, confident, thankful, excited sad, anxious, confused, frustrated kidding, amused, unsure, silly

  • Hi David

    I too have found this a pest in importing data but before you save the excel file to CSV if you format the date cells to DD/MM/YYYY then all will be well.

    Typically when importing the price I take this to 6+ decimal places as during the import process it will take the quantity and the price to calculate the consideration

    I find I need just the Date, (as discussed above) Market, Instrument code, Quantity, price per share (with 6+ decimal places), type (typically you are reduced to buy here - issued pointed out in another post) and comment. and the import works fine.

    The only trap I find is that Excel has a nasty habit of reformatting the date to DD/MM/YY if you reopen the source data and if you just save that you will have a problem.

    These are of course all excel issues (thanks Bill) rather than ShareSight.

    Done heaps of importing 80-100 transactions at a time... beats typing.

    Cheers .... Mike
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned happy, confident, thankful, excited sad, anxious, confused, frustrated kidding, amused, unsure, silly