Page 1 of 1

[Solved] Importing CSV file from my Fidelity Account

PostPosted: Sat Apr 17, 2021 6:59 pm
by realitybytez
Greetings all!

I have an account at Fidelity that allows me to download a CSV file of my portfolio. However the file shows dollar amounts in the format $xxx.xx and this makes the data unusable since Calc treats the data as a text string. Is there an easy way to convert the data to xxx.xx format (without the dollar sign) so I can actually do something with it? I have the same problem with the percentage entries, which already have a "%" tacked on the end.

Thank you in advance.

Re: importing CSV file from my Fidelity Account

PostPosted: Sat Apr 17, 2021 7:10 pm
by RusselB
Welcome to the Forums.
When you import the csv file you'll get a text import dialog.
In that dialog there is a check box marked Detect Special Numbers.
This box, in OpenOffice, is unchecked by default. Simply check that box and your number concerns (both with the $ and the %) will be handled.
This is not a static change, so you'll have to do it each time you import the csv file.
In LibreOffice Calc this same box is checked by default.

Re: importing CSV file from my Fidelity Account

PostPosted: Sat Apr 17, 2021 8:39 pm
by Villeroy
RusselB wrote:This is not a static change, so you'll have to do it each time you import the csv file.

Luckily it is static, indeed.

Re: importing CSV file from my Fidelity Account

PostPosted: Sat Apr 17, 2021 8:52 pm
by RusselB
If this setting is static, then the coding for it has changed since the last time I used it, though that is possible as the last time I used it was version 4.1.4

Re: importing CSV file from my Fidelity Account

PostPosted: Sat Apr 17, 2021 9:17 pm
by Villeroy
This is the entry in my registrymodifications.xcu which stores this option:
Code: Select all   Expand viewCollapse view
<item oor:path="/org.openoffice.Office.Calc/Dialogs/CSVImport">
<prop oor:name="DetectSpecialNumbers" oor:op="fuse">
<value>true</value>
</prop>
</item>

Re: importing CSV file from my Fidelity Account

PostPosted: Sat Apr 17, 2021 9:19 pm
by realitybytez
thank you for the quick reply. you've made my life a lot easier. :super:

Re: [Solved] Importing CSV file from my Fidelity Account

PostPosted: Sat Apr 17, 2021 10:03 pm
by Villeroy
If you open the same file (or a similar one) again, is "Detect special numbers" checked or not?

Re: [Solved] Importing CSV file from my Fidelity Account

PostPosted: Sun Apr 18, 2021 12:04 pm
by peterj3527
Hi
I am lloking for a template of the csv easy file 501 import file

Thanks