search

cmallwitz / Financials-Extension

Extension for LibreOffice Calc to access stock market data
Other
145 stars 19 forks source link

EX_DIV_DATE : Can you provide it with a calc date format? #16

Closed casper43 closed 1 year ago

casper43 commented 3 years ago

It seems that EX_DIV_DATE doesn't come in a readable calc date format to run formulas on it. In my case it would be neat to run some conditional formatting on it (I'd like to highlight the upcoming EX_DIV_DATES).

Should be straightforward to change. Any plans?

cmallwitz commented 3 years ago

I can format cells with the ex div date as "Date" in format "1999-12-31". When I then e.g. do +1 or -1 against those cells, the date is correctly reflected. So what is not working for you?

cmallwitz commented 3 years ago

Having said that I'm struggling to get any conditional formatting to work with dates...

casper43 commented 3 years ago

Clicking on the date-format button in calc won't change anything. The date always displays the same (e.g. 2020-04-12). I also tried to make a reference in another cell to the date and format these reference cells as date. Couldn't get any date calculations that way (substracting one date from another).

cmallwitz commented 3 years ago

I tried to do something like this: one cell contains e.g. '=GETREALTIME("IBM",72,"YAHOO")' - the another cell says ={this ex-div date cell}+30 . then I see another date 30 later than the first. This looks to be working for me?

casper43 commented 3 years ago

Yes, this seems to work. I can't format the specific original cell as a date though. Maybe that's the reason why conditional formating doesn't work?

cmallwitz commented 1 year ago

Closing this for now