Export of "Trade Date" from Portfolio is NOT Excel Compatible for DATE Format
The format of "Trade Date" when exported is "YYYYMMDD"
when put into an Excel cell and a DATE value is selected,
there are NO matching formats for a value formatted as "YYYYMMDD"
As a result, "########" appears in the cell(s).
My main portfolio is very large
and manual changing of format would not have been "pretty"
I wasted about an hour (using WORD)
to put the exported values into an Excel format.
Obviously,
I would greatly appreciate it if the exported format
would be changed to an Excel format
for my next export effort.
Why not use a format something like "MM/DD/YYYY" ???
-
RayO commented
Frank,
You can convert the YYYYMMDD values in the Trade Date column to MM/DD/YYYY pretty easily. Just use the below formula:
=DATE(LEFT(J2,4),MID(J2,5,2),RIGHT(J2,2))
It works though it shouldn't be necessary if YF actually designed the export properly. I woudn't expect a change anytime soon.