Financial data template

Discuss the spreadsheet application
Post Reply
taylorr113y93
Posts: 9
Joined: Thu Jul 25, 2024 10:54 am
Location: Glasgow

Financial data template

Post by taylorr113y93 »

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.
Attachments
Micro-Budget Public Version.ods
(108.3 KiB) Downloaded 72 times
OpenOffice 4.1.15 on Windows 11 Pro
User avatar
floris v
Volunteer
Posts: 4635
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: Financial data template

Post by floris v »

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
taylorr113y93
Posts: 9
Joined: Thu Jul 25, 2024 10:54 am
Location: Glasgow

Re: Financial data template

Post by taylorr113y93 »

Hi Floris, you're right, thanks for telling me.
I've been trying for a few hours, but keep getting this message.
Attachments
Screenshot 2024-07-26 142319.jpeg
Screenshot 2024-07-26 142319.jpeg (126.93 KiB) Viewed 2064 times
OpenOffice 4.1.15 on Windows 11 Pro
User avatar
RoryOF
Moderator
Posts: 35210
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Financial data template

Post by RoryOF »

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

Re: Financial data template

Post by taylorr113y93 »

Still the same, after 2 attempts.
OpenOffice 4.1.15 on Windows 11 Pro
Post Reply