[smf_addin] Digest Number 3136

EXCEL Stock Market Functions Add-in Group

8 Messages

Digest #3136

1a

First time user: trying to get quote using RCHGetYahooQuotes by "Sandeep Bhanushali" sandeep.bhanushali

1b

Re: First time user: trying to get quote using RCHGetYahooQuotes by "Randy Harmelink" rharmelink

2a

Dates prior to 1900 by glenn_ochs

2b

Re: Dates prior to 1900 by "Randy Harmelink" rharmelink

2c

Re: Dates prior to 1900 by "Yahoo!" lewglenn

2d

Re: Dates prior to 1900 by "Raymond K. Gota Toudji" kgotatoudji

2e

Re: Dates prior to 1900 by glenn_ochs

3

Advfn 15 years of data by DefelRadar

Messages

1a

First time user: trying to get quote using RCHGetYahooQuotes

Wed Jul 30, 2014 5:57 am (PDT) . Posted by:

"Sandeep Bhanushali" sandeep.bhanushali

Hi,

I am using this addin for the first time. I am trying to get the quote for
an indian stock "Aditya Birla Nuvo" using below function but getting a
return value zero.
Am I missing something? The below function works perfectly for ticket MMM
or IBM.

=RCHGetYahooQuotes("ABIRLANUV.NS","l1")

--
Thanks and Regards,
Sandeep R. Bhanushali

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

1b

Re: First time user: trying to get quote using RCHGetYahooQuotes

Wed Jul 30, 2014 6:07 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

If you're getting a value of zero, that's what Yahoo is sending to you.
Maybe a temporary glitch? Or market wasn't open yet? Because I just tried
it, and I got a returned value of 1423.7.

On Wed, Jul 30, 2014 at 5:41 AM, Sandeep Bhanushali sandeep.bhanushali@...
wrote:

>
> I am using this addin for the first time. I am trying to get the quote for
> an indian stock "Aditya Birla Nuvo" using below function but getting a
> return value zero.
> Am I missing something? The below function works perfectly for ticket MMM
> or IBM.
>
> =RCHGetYahooQuotes("ABIRLANUV.NS","l1")
>

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

2a

Dates prior to 1900

Wed Jul 30, 2014 10:41 am (PDT) . Posted by:

glenn_ochs

I have economic & stock price data prior to 1900


Does anyone know of a way for excel to recognize this as DATEs not text?

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

2b

Re: Dates prior to 1900

Wed Jul 30, 2014 10:47 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The methods I've seen of dealing with dates before 1900 all used special
macros. Do a Google search and you'll find a number of methods. Mostly
dealing with computing age between dates.

On Wed, Jul 30, 2014 at 10:34 AM, bruce.bender2001@...wrote:

> I have economic & stock price data prior to 1900
>
> Does anyone know of a way for excel to recognize this as DATEs not text?
>

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

2c

Re: Dates prior to 1900

Wed Jul 30, 2014 3:16 pm (PDT) . Posted by:

"Yahoo!" lewglenn

Click on the column letter to highlight the column & go to Format/Format Cells and in the pop-up menu click the Number column and choose Date from the menu.

On Wednesday, July 30, 2014 10:42 AM, "bruce.bender2001@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


 
I have economic & stock price data prior to 1900

Does anyone know of a way for excel to recognize this as DATEs not text?

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

2d

Re: Dates prior to 1900

Wed Jul 30, 2014 3:42 pm (PDT) . Posted by:

"Raymond K. Gota Toudji" kgotatoudji

http://j-walk.com/ss/excel/usertips/tip028.htm

John Walkenbach talks about it here, proposes an AddIn, and warns for dates before 1752!

Gr,
Raymond

----------------------------------------------------------
For years, the NASA invested millions of dollars in developing a pen that could work in space, struggling
with null gravity issues. The Russians looked at each other, shrug, and took a pencil!

________________________________
> To: smf_addin@yahoogroups.com
> From: smf_addin@yahoogroups.com
> Date: Wed, 30 Jul 2014 15:16:32 -0700
> Subject: Re: [smf_addin] Dates prior to 1900
>
>
>
> Click on the column letter to highlight the column & go to
> Format/Format Cells and in the pop-up menu click the Number column and
> choose Date from the menu.
>
>
> On Wednesday, July 30, 2014 10:42 AM, "bruce.bender2001@gmail.com
> [smf_addin]" <smf_addin@yahoogroups.com> wrote:
>
>
>
> I have economic & stock price data prior to 1900
>
> Does anyone know of a way for excel to recognize this as DATEs not text?
>
>
>
>

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

2e

Re: Dates prior to 1900

Wed Jul 30, 2014 6:10 pm (PDT) . Posted by:

glenn_ochs

thank you all

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

3

Advfn 15 years of data

Wed Jul 30, 2014 1:38 pm (PDT) . Posted by:

DefelRadar

Randy,

I was wondering if it was possible to add the data that comes in from AdVfn for the past 15 years into the RCHGetElementNumber functions? I see you already have the past 10 years from AdVfn and I frequently use the past 15 years if it is available to me.

Thanks in advance!

Aaron

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

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

Visit Your Group

• New Members 40

• Privacy • Unsubscribe • Terms of Use