Copying Security Prices Automatically once Per Week
Posted: February 2nd, 2024, 2:47 pm
Hello @ Lemon Fool
I have several portfolios based on either Hyptuss or Yahoo Simple Price Scrape by Kiloran using LibreOffice Calc.
I am now at the stage where updating my portfolio is either one or two clicks according to Hyptuss or Yahoo Simple Price Scrape usage.
I am wanting to start the process of producing charts so I have started a sheet in each portfolio named Price History.
Dates are along the top row
Security name is in the first column
Prices are against each security name under relevant date advancing to the right.
I want to achieve the following:-
When each spreadsheet is updated (Saturday morning) I want to automatically copy the list of prices after the update, to the list of prices on Price History tab and paste it under the relevant date. Each week the new date is in a column advancing to the right.
I don't know how to do this and I am not strong on macros. Are their formulas that can achieve this?
Thank you for your help.
Terry
I have several portfolios based on either Hyptuss or Yahoo Simple Price Scrape by Kiloran using LibreOffice Calc.
I am now at the stage where updating my portfolio is either one or two clicks according to Hyptuss or Yahoo Simple Price Scrape usage.
I am wanting to start the process of producing charts so I have started a sheet in each portfolio named Price History.
Dates are along the top row
Security name is in the first column
Prices are against each security name under relevant date advancing to the right.
I want to achieve the following:-
When each spreadsheet is updated (Saturday morning) I want to automatically copy the list of prices after the update, to the list of prices on Price History tab and paste it under the relevant date. Each week the new date is in a column advancing to the right.
I don't know how to do this and I am not strong on macros. Are their formulas that can achieve this?
Thank you for your help.
Terry