Multiple Time Series Download

[Antonio Godoy]

Hello team, didn't find a conversation for this below.

Sure it's a stupid question, however how do I download multiple historical time series at once using the add-in? I tried different ways here and EPF formulae returned just "#VALUE".

For example if you have in a row AAPL, MSFT and TSLA, how would the formula be so that I can download all three price series for the same period?

Thanks in advance.

[Michael Pepperney]

Do you need all the data points (O, C,H,L and Volume) or just one such as Close.  I don’t think you can download more than one symbol at a time. But if only need close it would be simple.

Mike and Helen Pepperney

Pepper...@outlook.com

On May 16, 2025, at 9:41 AM, Antonio Godoy <god...@gmail.com> wrote:

Hello team, didn't find a conversation for this below.

Sure it's a stupid question, however how do I download multiple historical time series at once using the add-in? I tried different ways here and EPF formulae returned just "#VALUE".

For example if you have in a row AAPL, MSFT and TSLA, how would the formula be so that I can download all three price series for the same period?

Thanks in advance.

--
You received this message because you are subscribed to the Google Groups "Excel Price Feed" group.
To unsubscribe from this group and stop receiving emails from it, send an email to excel-price-fe...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/excel-price-feed/52cb4190-9217-4699-a882-08d0140a3719n%40googlegroups.com.

[Lou K]

I do this with dividend history for a number of symbols. I wrote a macro to cycle through the symbols, getting the time-series data. Once I have the data for a symbol, I copy it to the end of a list on another tab. Then the macro gets the time-series data for the next symbol.

The macro is quite complex, so if you are not already a macro-writer this is not something you will be able to do.

Apart from using a macro, you are stuck with doing these one at a time.

You could put these on separate worksheet tabs with a final tab that summarizes them all. Then all you have to do is click on each tab and calculate it.

[Antonio Godoy]

I found a solution using "INDEX" to bring several closing prices at once. "INDEX" handles the dynamic arrays generated by Excel Price Feed very well. Thanks for the help anyway!