[Solved] Data Bars with OpenOffice Calc?

Discuss the spreadsheet application

[Solved] Data Bars with OpenOffice Calc?

Postby Jay_Dee » Sun Feb 16, 2020 9:46 am

Hello Everyone!

I am trying to implement the features shown in the video I uploaded but using OpenOffice. I have a column of data and want to use that range of data to create a histogram/relative bars in that column(I do not want to make a bar graph. That would be something completely different. I understand how to do that and it will not work for the project I need to complete). Both Excel and LibreOffice have this "data bars' presets/drop down in conditional formatting. I have looked online and tried messing around with OpenOffice for hours and have failed to figure out how to do Data Bars.

Thank you for any help!

****UPDATE What I am wanting to do cannot be done with OpenOffice for now******
Last edited by Jay_Dee on Fri Feb 21, 2020 5:51 am, edited 3 times in total.
Jay_Dee
 
Posts: 5
Joined: Sun Feb 16, 2020 9:07 am

Re: Data Bars with OpenOffice Calc?

Postby Zizi64 » Sun Feb 16, 2020 10:15 am

The Apache OpenOffice has not such feature (yet).

Use the LIbreOffice if you must use the Data Bars.
Last edited by Zizi64 on Sun Feb 16, 2020 10:39 am, edited 1 time in total.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9548
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Data Bars with OpenOffice Calc?

Postby Jay_Dee » Sun Feb 16, 2020 10:37 am

Zizi64 wrote:The Apache OpenOffice has not such feature (yet).

Use the LIbreOffice is you must use the Data Bars.


Okay thank you :(
Jay_Dee
 
Posts: 5
Joined: Sun Feb 16, 2020 9:07 am

Re: Data Bars with OpenOffice Calc?

Postby jrkrideau » Sun Feb 16, 2020 2:57 pm

Jay_Dee wrote:Hello Everyone!

I am trying to implement the features shown in the video

I do not see the video link but here is a link to a video that shows how to create a histogram in AOO Calc. https://www.youtube.com/watch?v=suFPnBV_NU4. I have not tried it but it looks fairly straight-forward if a trifle tedious.

If you are likely to be doing a lot of statistical graphing I'd recommend a real graphing package. Depending what you are doing both R and
Gnuplot have their good points.
LibreOffice 6.4.3.2; Ubuntu 20.04
jrkrideau
Volunteer
 
Posts: 3788
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Data Bars with OpenOffice Calc?

Postby Zizi64 » Sun Feb 16, 2020 4:05 pm

The "Data bars" is a feature in the Excel an the LO. This shows graphical bars in the cells instead of the pure numeric data:
https://www.youtube.com/watch?v=GKiYfijdr4c
https://www.youtube.com/watch?v=hUaIpG4zHKQ

(These videos are similar to the originally linked one)

It is a improved Conditional Formatting feature. The AOO has not such feature. I can not decide if it is an useful feature or not...
Last edited by Zizi64 on Sun Feb 16, 2020 7:27 pm, edited 3 times in total.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9548
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Data Bars with OpenOffice Calc?

Postby Zizi64 » Sun Feb 16, 2020 4:08 pm

Jay_Dee,

please do not erase the helper links (or other information) from your previous posts!
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9548
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Data Bars with OpenOffice Calc?

Postby jrkrideau » Sun Feb 16, 2020 5:55 pm

Zizi64 wrote:The "Data bars" is a feature in the Excel an the LO. This shows graphical bars in the cells indstead of the pure numeric data:
https://www.youtube.com/watch?v=GKiYfijdr4c
https://www.youtube.com/watch?v=hUaIpG4zHKQ

(These videos are similar to the originally linked one)

It is a improved Conditional Formatting feature. The AOO has not such feature. I can not decide if it is an useful feature or not...


Looks like a rather silly gimmick to me; they are just bar-plots the same as Calc produces. They are not histograms.

If Jay_Dee (the OP) really needs a histogram, a Data bar on the raw data is useless at best.
LibreOffice 6.4.3.2; Ubuntu 20.04
jrkrideau
Volunteer
 
Posts: 3788
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Data Bars with OpenOffice Calc?

Postby Lupp » Sun Feb 16, 2020 10:35 pm

It's annoying and also astonishing to see the impact of such toy features. If spreadsheets continue to develop in that direction it will be unavoidable to deprecate them for serious tasks. The implementation in LibO as a new 'All Cells' mode under ConditionalFormatting completely goes beyond the reasonable scope of that useful feature. Next time charts will play songs, and sheet tabs will show videos.
Sorry. I missed to label this as a personal opinion. Move the post virtually to the 'General Discussion' branch.
On Windows 10: LibreOffice 7.0 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 2918
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Data Bars with OpenOffice Calc?

Postby jrkrideau » Mon Feb 17, 2020 1:10 am

Lupp wrote: If spreadsheets continue to develop in that direction it will be unavoidable to deprecate them for serious tasks.


I consider them too dangerous to use for anything beyond a grocery shopping list. Have you read of the Reinhart and Rogoff mess?
LibreOffice 6.4.3.2; Ubuntu 20.04
jrkrideau
Volunteer
 
Posts: 3788
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Data Bars with OpenOffice Calc?

Postby Jay_Dee » Thu Feb 20, 2020 8:10 am

jrkrideau wrote:
Zizi64 wrote:The "Data bars" is a feature in the Excel an the LO. This shows graphical bars in the cells indstead of the pure numeric data:
https://www.youtube.com/watch?v=GKiYfijdr4c
https://www.youtube.com/watch?v=hUaIpG4zHKQ

(These videos are similar to the originally linked one)

It is a improved Conditional Formatting feature. The AOO has not such feature. I can not decide if it is an useful feature or not...


Looks like a rather silly gimmick to me; they are just bar-plots the same as Calc produces. They are not histograms.

If Jay_Dee (the OP) really needs a histogram, a Data bar on the raw data is useless at best.


Actually in my situation it is a histogram. I am a active day trader. I am using a spreadsheet to create a template/photo for my buddy who is helping me develop my own price ladder/dom. This template would give us visual reference how the we want the DOM to look, Price ladders/DOMs(or level2/Order book.. tons of names) is a tool/feature within trading software that have a vertical list of prices. The video I posted below should be a decent example of what I am referring to. Notice the dark blue histogram up and down the entire "ladder". That blue histogram translates to all the volume that has transacted at each price level, called the volume profile. This shows varying interests of prices in the auctioning process/order flow of trading that particular financial product.

*** Start video at 10:40
https://www.youtube.com/watch?v=B7EHoHgPTfs
Jay_Dee
 
Posts: 5
Joined: Sun Feb 16, 2020 9:07 am

Re: Data Bars with OpenOffice Calc?

Postby Jay_Dee » Thu Feb 20, 2020 8:13 am

Here is a good video explaining a Price Ladder/Depth of Market that shows and explains the "volume profile" portion that I was trying to mimic on a spreadsheet

https://www.youtube.com/watch?v=q5_GhCORZyY
Jay_Dee
 
Posts: 5
Joined: Sun Feb 16, 2020 9:07 am

Re: Data Bars with OpenOffice Calc?

Postby Lupp » Thu Feb 20, 2020 12:39 pm

Who remembers the (about) y2k bubble burst? (NASDAQ, dotcom/ In Germany "Neuer Markt")
https://en.wikipedia.org/wiki/File:NASD ... _small.png

Please remove the spam link.

(Spoken aside: Couldn't everybody trade their days elsewhere?
Why do people so readily make an effort to get effortless earnings?
They must be fond of such a paradox and of self-contradiction.
Probably there should be a rule that a day trader at least should know his community-driven, free-of-charge spreadsheet software.
In 1999/2000 I took part in training a young would-be teacher. One day he told me he felt demotivated because he earned more by speculative trading than he could expect to get paid as a profssional teacher. A short time later he broke off.
I don't know, but I suspect he may now neither be rich nor a teacher.)
On Windows 10: LibreOffice 7.0 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 2918
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Data Bars with OpenOffice Calc?

Postby Jay_Dee » Thu Feb 20, 2020 7:12 pm

Lupp wrote:Who remembers the (about) y2k bubble burst? (NASDAQ, dotcom/ In Germany "Neuer Markt")
https://en.wikipedia.org/wiki/File:NASD ... _small.png

Please remove the spam link.

(Spoken aside: Couldn't everybody trade their days elsewhere?
Why do people so readily make an effort to get effortless earnings?
They must be fond of such a paradox and of self-contradiction.
Probably there should be a rule that a day trader at least should know his community-driven, free-of-charge spreadsheet software.
In 1999/2000 I took part in training a young would-be teacher. One day he told me he felt demotivated because he earned more by speculative trading than he could expect to get paid as a profssional teacher. A short time later he broke off.
I don't know, but I suspect he may now neither be rich nor a teacher.)



-Please remove your spam link as it has no benefit to this conversation.

-:lol: Effortless? Paradox? You sound just like the rest of them. Typical.
-If you are German(as I can tell you are something by lack of the English language) I thank you people and your Country for the Eurex Exchange. My primary product is the Bund! :bravo:

-In 13 years I have never had to make a spreadsheet for trading. I have been trading for a living for over 9 years. Our software provides phenomenal analytics.

-The worse, more often than not, traders are teachers/professors.

-Not every investor/trader is rich or just getting by, but there are both. Just like the teachers who make $3000/mo living pay to pay check. Same as highly successful Professors making 100s of thousands of dollars per year.

-Trading and Investing are 2 different realms. You forgot the 07-9 Financial Crisis/bear market, 2010 1000pt DJ30 flash crash etc. I do not know why you are bringing this up. This clearly shows you have no idea what you are talking about...
Jay_Dee
 
Posts: 5
Joined: Sun Feb 16, 2020 9:07 am

Re: Data Bars with OpenOffice Calc?

Postby Lupp » Thu Feb 20, 2020 9:36 pm

It seems our points of view aren't fully compatible. (I couldn't find the emoticon with the tear in the eye.)

Just one remark in return. The "efforts to get a chance at effortless earnings" was a wilful attempt to create a kind of pun based on a superficial contradiction in itself. Less than phenomenal analytics may nonetheless unveil that efforts may contribute to common wealth in goods and real services - or may not.

To get to the point: I voluntarily contribute to this forum for reasons you may guess correctly or not. I don't exactly like to support "day trading" by my kind of investment.
On Windows 10: LibreOffice 7.0 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 2918
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: Data Bars with OpenOffice Calc?

Postby jrkrideau » Fri Feb 21, 2020 4:48 am

Jay_Dee wrote:Here is a good video explaining a Price Ladder/Depth of Market that shows and explains the "volume profile" portion that I was trying to mimic on a spreadsheet

https://www.youtube.com/watch?v=q5_GhCORZyY


I will leave you and Lupp to fight out the career choices.

As far as I can see, at least without some sophisticated macro programming that is outside my skills the only way to get real histograms is Calc is illustrated in the video linked in my earlier post.

I had a look at your video; are you sure that those blue bars are histograms? I got the impression that they were a bar plot of the number of transactions at some (price?) point. In which case, you have a bar plot of the sums of the counts of the transaction at each point. Excuse me if i am being obtuse, I just have never seen a data display like that.
LibreOffice 6.4.3.2; Ubuntu 20.04
jrkrideau
Volunteer
 
Posts: 3788
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 21 guests