[smf_addin] Digest Number 4486

EXCEL Stock Market Functions Add-in Group

2 Messages

Digest #4486

1a

Name and Earliest Data point by thomas91112

1b

Re: Name and Earliest Data point by "Randy Harmelink" rharmelink

Messages

1a

Name and Earliest Data point

Thu Feb 21, 2019 12:06 pm (PST) . Posted by:

thomas91112

Which function(s) can (1) provide me with the Stock Name given its Ticker, and (2) is there a way to pull down the earliest date for which historical pricing is available - don't want all the data downloaded yet but rather this date will tell me how much to expect so I can create properly sized array and my workbook fields.



Thanks

Mike

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: Name and Earliest Data point

Thu Feb 21, 2019 3:21 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Easiest way to get the name for a number of stocks is to use the
smfGetYahooPortfolioView() function.

To get the earliest trading date from Yahoo:

=MIN(smfGetYahooHistory("MMM",,,,"d",0,,30000,1))

On Thu, Feb 21, 2019 at 1:07 PM thomas91112@... wrote:

>
> Which function(s) can (1) provide me with the Stock Name given its
> Ticker, and (2) is there a way to pull down the earliest date for which
> historical pricing is available - don't want all the data downloaded yet
> but rather this date will tell me how much to expect so I can create
> properly sized array and my workbook fields.
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• Privacy • Unsubscribe • Terms of Use