search

cmallwitz / Financials-Extension

Extension for LibreOffice Calc to access stock market data
Other
137 stars 17 forks source link

GETREALTIME Command #52

Closed Andresmith76 closed 1 year ago

Andresmith76 commented 2 years ago

If I create a spreadsheet containing numerous cells using the GETREALTIME command, is there a way to disable those commands when the file is saved, preserving the data collected for future reference? I want a spreadsheet that will fetch individual stock statistics each day and then save the collected data for future viewing, comparison, etc. without automatically updating every time the file is reopened.

cmallwitz commented 2 years ago

Unfortunately I don't know of any way to accomplish this.

On Thu, 5 May 2022 at 00:05, Andresmith76 @.***> wrote:

If I create a spreadsheet containing numerous cells using the GETREALTIME command, is there a way to disable those commands when the file is saved, preserving the data collected for future reference? I want a spreadsheet that will fetch individual stock statistics each day and then save the collected data for future viewing, comparison, etc. without automatically updating every time the file is reopened.

— Reply to this email directly, view it on GitHub https://github.com/cmallwitz/Financials-Extension/issues/52, or unsubscribe https://github.com/notifications/unsubscribe-auth/AA226T7OJS2LI4B6UUBOOSLVIMGFFANCNFSM5VDRC2AQ . You are receiving this because you are subscribed to this thread.Message ID: @.***>

jbourvic commented 2 years ago

Perhaps save the document as a pdf. If it is for reference, there is no need for the data to change.

Andresmith76 commented 2 years ago

Thank you - that is what I ended up doing. Saving each daily spreadsheet as a PDF for static future reference.

cmallwitz commented 1 year ago

Closing now.