I have made a template of running financial data.
It has the date; day; stock market models/predictions by account size, £/pt, margin, number of points...; income; withdrawal; income from other sources; bank account; and expenses.
Each column perpetuates itself on formulae.
Certain information on holidays is excluded using formulae, and the dates of holidays are listed and highlighted until the end of 2026.
Column breaks have been added for ease of reading.
Top row is frozen for ease of reading.
I've been working on it for a while.
Navigation short-cuts: CTRL+SHIFT+Arrows; ALT+Arrows for adjusting width/height of cells; CTRL+PGUP/PGDN for switching between sheets; SHIFT+F4 for locking cells; CTRL+S for saving; CTRL+W for closing; CTRL+Z for undo; CTRL+C for copy; CTRL+V for paste; CTRL+X for cut; CTRL+B for bold; CTRL+I for italic; CTRL+U for underline; ...
I have put "END" at the end of each of column of filled data to make it easier to navigate from top to bottom.
I have had to abridge it so that it could be uploaded.
Please remember that the main purpose for this spreadsheet is STOCK MARKET.
Stock market is a MIXTURE of BOTH ART, FEELING, AND MATHEMATICS.
As such, not all of the formulae are ubiquitous, some cells have been replaced with raw data or left empty to be determined on the day.
Please feel free to steal it and adjust it for your own purposes.
Please feel free to give me suggestions and feedback on its functionality and spreadsheet technicality.
Financial data template
-
taylorr113y93
- Posts: 9
- Joined: Thu Jul 25, 2024 10:54 am
- Location: Glasgow
Financial data template
- Attachments
-
- Micro-Budget Public Version.ods
- (108.3 KiB) Downloaded 72 times
OpenOffice 4.1.15 on Windows 11 Pro
Re: Financial data template
Hi, thank you for uploading your template. warning: Most people won't find your template here. You should really submit it in the Templates sections of Apache OpenOffice and of LibreOffice (especially in the LibreOffice section). See https://templates.openoffice.org/ and https://extensions.libreoffice.org/. Upload it there in the template format; save as a template with extension .ots instead of .ods, (that's the extension for an ordinary Calc spreadsheet document).
LibreOffice 25.8.4.2 on Ubuntu Linux
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
-
taylorr113y93
- Posts: 9
- Joined: Thu Jul 25, 2024 10:54 am
- Location: Glasgow
Re: Financial data template
Hi Floris, you're right, thanks for telling me.
I've been trying for a few hours, but keep getting this message.
I've been trying for a few hours, but keep getting this message.
- Attachments
-
- Screenshot 2024-07-26 142319.jpeg (126.93 KiB) Viewed 2063 times
OpenOffice 4.1.15 on Windows 11 Pro
Re: Financial data template
A guess: try replacing the - and the spaces in the fiilename with underscores.
Apache OpenOffice 4.1.16 on Xubuntu 24.04.4 LTS
-
taylorr113y93
- Posts: 9
- Joined: Thu Jul 25, 2024 10:54 am
- Location: Glasgow