Macro to calculate formula automatically from a list of input and save each result

[Alex Zana]

Hi,

I need your kind help to solve this problem:

I have a macro that can allow me to download the quotation of a single ticker (stock) from Yahoo. I type the ticker in a cell and, by pushing a button, I get the download of quotations. This data feed a formula that I have built to get a specific result.

So at the moment I change the ticker, I push download and I get the result of the calculation. I copy and paste this result manually in another sheet (ticker in one cell and the result of the formulation in the other).

As I want to make this calculation for a list of tickers, I would like to make this calculation automatic, by pushing a button.
My idea is: push the button, the macro calculates the result of each ticker got from a list (that I can change) and the relative result should be saved in an another sheet ( in which I have the ticker in the first column and the value of the calculation in the second column)

To make all more clear, I attach the file...

Thank you for your precious support and for your time....

Alessandro

[dflak]

I think this is what you want. It takes the selected columns from the Dati page and copies them to the Calcoli page. I make use of Excel tables on the Calcoli page in a table Called Table_Calcoli. The reason for using a table is that tables know their boundaries and are easy to clear. Also, they copy down formatting, validations and formulas automatically.

I also imported some modules that I have in my personal library to clear tables and find the last row.

Please Login or Register  to view this content.

[Alex Zana]

Thank you very much dflak.

What I am looking for, is a macro that can calculate the result that you can find in the sheet "Calcoli" (last cell not empty - the position is not fixed because depends on the data that you set in the first sheet) for a list of input that you put in the first sheet (position B4).
The automation should consist of pushing a button and starting the caluclation for a SET of input (from a list like in the column O in the first shee), and each result of the calculation (that you find currently in the sheet Calcoli in the position H272 - but it changes every day) should be saved in the other sheet "Results".


Thank you

Alessandro

[Alex Zana]

To all,

I have attached the file (name FILE2) with more comments in order to make it clearer

Thank you for what you can do for me.

Alessandro