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.
[Solved] Importing CSV file from my Fidelity Account
-
- Posts: 2
- Joined: Sun Oct 11, 2020 12:59 am
[Solved] Importing CSV file from my Fidelity Account
Last edited by Hagar Delest on Sat Apr 17, 2021 9:48 pm, edited 1 time in total.
Reason: tagged solved.
Reason: tagged solved.
openoffice 4.1.6 on windows 8.1
Re: importing CSV file from my Fidelity Account
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.
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.
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.
Re: importing CSV file from my Fidelity Account
Luckily it is static, indeed.RusselB wrote:This is not a static change, so you'll have to do it each time you import the csv file.
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: importing CSV file from my Fidelity Account
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.
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.
Re: importing CSV file from my Fidelity Account
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 2
- Joined: Sun Oct 11, 2020 12:59 am
Re: importing CSV file from my Fidelity Account
thank you for the quick reply. you've made my life a lot easier.
openoffice 4.1.6 on windows 8.1
Re: [Solved] Importing CSV file from my Fidelity Account
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 1
- Joined: Sun Apr 18, 2021 11:59 am
Re: [Solved] Importing CSV file from my Fidelity Account
Hi
I am lloking for a template of the csv easy file 501 import file
Thanks
I am lloking for a template of the csv easy file 501 import file
Thanks
OpenOffice 3.1 on Windows Vista