[Solved] Importing CSV file from my Fidelity Account

Discuss the spreadsheet application
Post Reply
realitybytez
Posts: 2
Joined: Sun Oct 11, 2020 12:59 am

[Solved] Importing CSV file from my Fidelity Account

Post 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.
Last edited by Hagar Delest on Sat Apr 17, 2021 9:48 pm, edited 1 time in total.
Reason: tagged solved.
openoffice 4.1.6 on windows 8.1
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: importing CSV file from my Fidelity Account

Post 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.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: importing CSV file from my Fidelity Account

Post 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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: importing CSV file from my Fidelity Account

Post 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
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: importing CSV file from my Fidelity Account

Post by Villeroy »

This is the entry in my registrymodifications.xcu which stores this option:

Code: Select all

<item oor:path="/org.openoffice.Office.Calc/Dialogs/CSVImport">
<prop oor:name="DetectSpecialNumbers" oor:op="fuse">
<value>true</value>
</prop>
</item>
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
realitybytez
Posts: 2
Joined: Sun Oct 11, 2020 12:59 am

Re: importing CSV file from my Fidelity Account

Post by realitybytez »

thank you for the quick reply. you've made my life a lot easier. :super:
openoffice 4.1.6 on windows 8.1
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Post by Villeroy »

If you open the same file (or a similar one) again, is "Detect special numbers" checked or not?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
peterj3527
Posts: 1
Joined: Sun Apr 18, 2021 11:59 am

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

Post by peterj3527 »

Hi
I am lloking for a template of the csv easy file 501 import file

Thanks
OpenOffice 3.1 on Windows Vista
Post Reply