Daily update from online delimited file

[fr3d]

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

[robleyd]

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?

[Villeroy]

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