Daily update from online delimited file

Discuss the spreadsheet application

Daily update from online delimited file

Postby fr3d » Mon Jul 13, 2020 7:52 am

 Edit: Split from Import tab-delimited .txt file into Calc. Different problem should have a new topic. 

Hi AOO,

I would like to take this subject a step further if possible. Need it to "import" / Map the .txt file to Calc daily. Any pointers would be much appreciated.

http://regsho.finra.org/CNMSshvol20200710.txt
Date|Symbol|ShortVolume|ShortExemptVolume|TotalVolume|Market
20200710|A|96058|473|204861|B,Q,N
20200710|AA|1525245|2465|2798013|B,Q,N
20200710|AAAU|182495|0|234759|B,Q,N
20200710|AACG|35718|329|111349|Q,N
20200710|AADR|761|0|3330|Q,N
20200710|AAL|16106270|611887|44055729|B,Q,N
20200710|AAMC|200|0|1321|Q,N
20200710|AAME|318|0|1806|Q,N
20200710|AAN|46676|343|97093|Q,N
20200710|AAOI|144039|100|329152|B,Q,N
20200710|AAON|17389|0|25120|B,Q,N
20200710|AAP|51141|98|103005|B,Q,N
20200710|AAPL|3853343|54295|9735345|B,Q,N

Environment:
LibreOffice
Version: 6.4.4.2
Build ID: 1:6.4.4~rc2-0ubuntu0.18.04.1
CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: gtk3;
Locale: en-AU (en_AU.UTF-8); UI-Language: en-US
Calc: threaded

Many thanks,
Fr3d
Last edited by MrProgrammer on Thu Jul 16, 2020 6:45 pm, edited 1 time in total.
Reason: Added sample from http://regsho.finra.org, since that link will eventually die
LibreOffice 6.4.4.2 on Ubuntu 18.04
fr3d
 
Posts: 1
Joined: Mon Jul 13, 2020 7:44 am

Re: Daily update from online delimited file

Postby robleyd » Mon Jul 13, 2020 11:12 am

It isn't quite clear what your goal is. Do you want to:

1) Get the file and add it to an existing sheet
2) Get the file and add it as a new sheet in an existing spreadsheet file
3) Get the file and create a new spreadsheet each day
4) Get the file and overwrite data in an existing sheet
5) Something else?
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.4.6.2 (SlackBuild for 6.4.6 by Eric Hameleers) - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3750
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Daily update from online delimited file

Postby Villeroy » Mon Jul 13, 2020 2:01 pm

Since many years I import csv files from my bank statements into a database. Calc has nothing to offer for this difficult task.
You have 3 options:
1) Fumble around with spreadsheets on a daily basis, insert cells, fill cells, adjust formulas, fix broken references.
2) Develop a database solution (takes much more than a lazy weekend) and use it on a daily basis
3) Use a dedicated application for this
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 29279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: mike.stirton and 22 guests