[smf_addin] Digest Number 4433

EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #4433

1a

Re: Getting Stock Quote from Investing.com by alankc_mok

1b

Re: Getting Stock Quote from Investing.com by "Randy Harmelink" rharmelink

2a

Wrong Name for ticker by climbermel

2b

Re: Wrong Name for ticker by "Randy Harmelink" rharmelink

Messages

1a

Re: Getting Stock Quote from Investing.com

Mon Dec 3, 2018 8:52 am (PST) . Posted by:

alankc_mok

Randy,


Thanks for your reply.


If I want to make the date as variable, what should be the proper way of doing it ?


I have used =">Dec";&" "&"03"&", "&"2018" , but it failed.


Regards


Alan

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

1b

Re: Getting Stock Quote from Investing.com

Mon Dec 3, 2018 9:16 am (PST) . Posted by:

"Randy Harmelink" rharmelink

You should use EXCEL's TEXT() function to format a date. So, if cell D4
contained an EXCEL serial date value:

=TEXT(D4,">mmm dd, yyyy")

On Mon, Dec 3, 2018 at 9:53 AM alankc_mok@... wrote:

>
> If I want to make the date as variable, what should be the proper way of
> doing it ?
>
> I have used =">Dec";&" "&"03"&", "&"2018" , but it failed.
>
>
>

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

2a

Wrong Name for ticker

Mon Dec 3, 2018 4:45 pm (PST) . Posted by:

climbermel

It is odd, but one ticker seems to pull the wrong name. I'm using =smfGetYahooPortfolioView($L$3:$L$57,$M$1:$N$1,"Y",0) where M1 & N1 are 03 & 15. The ticker is T.TO which if I go into Yahoo it gives me Telus. In the spreadsheet, it gives me "Trans Canadian Fixed Pay GIF -" but the correct Current Price for Telus. I closed the sheet, reopened, refreshed it, waited an hour or so and tried again, two different computers... any ideas?


Mel

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

2b

Re: Wrong Name for ticker

Mon Dec 3, 2018 5:38 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

An error on Yahoo's part? If I go to the web page:

https://finance.yahoo.com/quote/T.TO

....it does says "TELUS Corporation" on the web page, but the title of the
page says "T.TO Profile | Trans Canadian Fixed Pay GIF - Stock - Yahoo
Finance". So they appear to have both names attached to the ticker symbol,
in one capacity or another.

On Mon, Dec 3, 2018 at 5:45 PM climbermel@... wrote:

>
> It is odd, but one ticker seems to pull the wrong name. I'm using
> =smfGetYahooPortfolioView($L$3:$L$57,$M$1:$N$1,"Y",0) where M1 & N1 are 03
> & 15. The ticker is T.TO which if I go into Yahoo it gives me Telus. In
> the spreadsheet, it gives me "Trans Canadian Fixed Pay GIF -" but the
> correct Current Price for Telus. I closed the sheet, reopened, refreshed
> it, waited an hour or so and tried again, two different computers... any
> ideas?
>
>
>

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