15 New Messages
Digest #2675
Messages
Fri Jun 28, 2013 3:45 am (PDT) . Posted by:
"toms_mail_box" toms_mail_box
Can someone please post instructions on how to update the MSN links in 'Financials Import' tab of the Aug. 21, 2010 version of 'Cash Flow_17S'.
I understand about MSN changing their links many times, but the URL nested inside RCHGetTableCell command doesn't look sufficiently familiar for me to do a search and replace with the new investing.money.msn.com link.
Many thanks,
Tom
I understand about MSN changing their links many times, but the URL nested inside RCHGetTableCell command doesn't look sufficiently familiar for me to do a search and replace with the new investing.money.
Many thanks,
Tom
Fri Jun 28, 2013 8:14 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, not an easy fix. They've changed labels. Even added and
deleted line items from their statements.
Updating the URL is the easy part, but you'd have to do it for each
statement. For example:
http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Income&stmtView=Ann&Symbol=
...would need to be changed to:
http://investing.money.msn.com/investments/stock-income-statement/?symbol=
On Thu, Jun 27, 2013 at 10:43 PM, toms_mail_box <tom.s.davis1@gmail.com >wrote:
> Can someone please post instructions on how to update the MSN links in
> 'Financials Import' tab of the Aug. 21, 2010 version of 'Cash Flow_17S'.
>
> I understand about MSN changing their links many times, but the URL nested
> inside RCHGetTableCell command doesn't look sufficiently familiar for me to
> do a search and replace with the new investing.money.msn.com link.
>
deleted line items from their statements.
Updating the URL is the easy part, but you'd have to do it for each
statement. For example:
http://moneycentral
...would need to be changed to:
http://investing.
On Thu, Jun 27, 2013 at 10:43 PM, toms_mail_box <tom.s.davis1@
> Can someone please post instructions on how to update the MSN links in
> 'Financials Import' tab of the Aug. 21, 2010 version of 'Cash Flow_17S'
>
> I understand about MSN changing their links many times, but the URL nested
> inside RCHGetTableCell command doesn't look sufficiently familiar for me to
> do a search and replace with the new investing.money.
>
Fri Jun 28, 2013 10:17 am (PDT) . Posted by:
"toms_mail_box" toms_mail_box
Thanks, Randy - Are there other options for workaround, such as using the RCHGetElementNumber with MSN or a different site? Or smfGetAdvFNElement at ADVFN.com? Does the RCHGetTableCell command have to be nested in the RCHGetElementNumber command to extract Annual and Quarterly financials from a web page? Tom
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Unfortunately, not an easy fix. They've changed labels. Even added and
> deleted line items from their statements.
>
> Updating the URL is the easy part, but you'd have to do it for each
> statement. For example:
>
> http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Income&stmtView=Ann&Symbol=
>
> ...would need to be changed to:
>
> http://investing.money.msn.com/investments/stock-income-statement/?symbol=
>
> On Thu, Jun 27, 2013 at 10:43 PM, toms_mail_box <tom.s.davis1@...>wrote:
>
> > Can someone please post instructions on how to update the MSN links in
> > 'Financials Import' tab of the Aug. 21, 2010 version of 'Cash Flow_17S'.
> >
> > I understand about MSN changing their links many times, but the URL nested
> > inside RCHGetTableCell command doesn't look sufficiently familiar for me to
> > do a search and replace with the new investing.money.msn.com link.
> >
>
--- In smf_addin@yahoogrou
>
> Unfortunately, not an easy fix. They've changed labels. Even added and
> deleted line items from their statements.
>
> Updating the URL is the easy part, but you'd have to do it for each
> statement. For example:
>
> http://moneycentral
>
> ...would need to be changed to:
>
> http://investing.
>
> On Thu, Jun 27, 2013 at 10:43 PM, toms_mail_box <tom.s.davis1@
>
> > Can someone please post instructions on how to update the MSN links in
> > 'Financials Import' tab of the Aug. 21, 2010 version of 'Cash Flow_17S'
> >
> > I understand about MSN changing their links many times, but the URL nested
> > inside RCHGetTableCell command doesn't look sufficiently familiar for me to
> > do a search and replace with the new investing.money.
> >
>
Fri Jun 28, 2013 10:48 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The problem is getting to the old line items MSN had. It may not even be
possible. But I don't know if the workbook needs them either. Going to
another source still gives you the same problem -- determining what you
need to retrieve and how to retrieve it. It basically means going over it
line by line. The "Find and Replace All" can do a lot of the work, but you
still need to track down the exceptions.
In general, an RCHGetElementNumber() date element is just a "saved" version
of the RCHGetTableCell() function, or some other add-in function.
But I have no idea what you mean by "nested". Can you have an example?
On Fri, Jun 28, 2013 at 10:17 AM, toms_mail_box <tom.s.davis1@gmail.com >wrote:
> Thanks, Randy - Are there other options for workaround, such as using the
> RCHGetElementNumber with MSN or a different site? Or smfGetAdvFNElement at
> ADVFN.com? Does the RCHGetTableCell command have to be nested in the
> RCHGetElementNumber command to extract Annual and Quarterly financials from
> a web page? Tom
>
possible. But I don't know if the workbook needs them either. Going to
another source still gives you the same problem -- determining what you
need to retrieve and how to retrieve it. It basically means going over it
line by line. The "Find and Replace All" can do a lot of the work, but you
still need to track down the exceptions.
In general, an RCHGetElementNumber
of the RCHGetTableCell(
But I have no idea what you mean by "nested"
On Fri, Jun 28, 2013 at 10:17 AM, toms_mail_box <tom.s.davis1@
> Thanks, Randy - Are there other options for workaround, such as using the
> RCHGetElementNumber with MSN or a different site? Or smfGetAdvFNElement at
> ADVFN.com? Does the RCHGetTableCell command have to be nested in the
> RCHGetElementNumber command to extract Annual and Quarterly financials from
> a web page? Tom
>
Fri Jun 28, 2013 3:47 am (PDT) . Posted by:
"Thomas" tg.bruin
Thanks for the reply, but that isn't working...I still only get a result in cell I12.
--- In smf_addin@yahoogroups.com , "mguerreiro99" <matthew.guerreiro@...> wrote:
>
>
>
> I'm a newbie, but have the following observations.
>
> 1. Put a blank field ",," in front of the NOW() in your formula
> 2. Be sure you have selected the range I12:J36 before entering your formula in cell I12, then CTRL, SHFT, ENTER.
>
> I hope this works for you.
>
> Matt G
>
> --- In smf_addin@yahoogroups.com , "Thomas" <thos.bruin@> wrote:
> >
> > I have a list of tickers in range H12 to H36. I have elements "l1" and "p" in cells I11 and J11. I am using the following formula syntax:
> > RCHGetYahooQuotes(H12:H36,I11:J11,NOW()), then CTRL,SHFT,ENTER. This only returns a value in cell I12. What am I doing incorrectly? I would like to be able to update the prices during the day.
> >
>
--- In smf_addin@yahoogrou
>
>
>
> I'm a newbie, but have the following observations.
>
> 1. Put a blank field ",," in front of the NOW() in your formula
> 2. Be sure you have selected the range I12:J36 before entering your formula in cell I12, then CTRL, SHFT, ENTER.
>
> I hope this works for you.
>
> Matt G
>
> --- In smf_addin@yahoogrou
> >
> > I have a list of tickers in range H12 to H36. I have elements "l1" and "p" in cells I11 and J11. I am using the following formula syntax:
> > RCHGetYahooQuotes(
> >
>
Fri Jun 28, 2013 5:49 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
You need to define it as an array. I fought 4 hours yesterday with something
very similar.
I seldom use arrays and my memory isn't what it use to be. So it a
re-learning every time.
The sequence order is important in defining the array. Use Excel help and
search on array.
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Thomas
Sent: Friday, June 28, 2013 6:47 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: GetYahooQuotes in an array formula not working for
me
Thanks for the reply, but that isn't working...I still only get a result in
cell I12.
--- In smf_addin@yahoogroups.com , "mguerreiro99" <matthew.guerreiro@...>
wrote:
>
>
>
> I'm a newbie, but have the following observations.
>
> 1. Put a blank field ",," in front of the NOW() in your formula 2. Be
> sure you have selected the range I12:J36 before entering your formula in
cell I12, then CTRL, SHFT, ENTER.
>
> I hope this works for you.
>
> Matt G
>
> --- In smf_addin@yahoogroups.com , "Thomas" <thos.bruin@> wrote:
> >
> > I have a list of tickers in range H12 to H36. I have elements "l1" and
"p" in cells I11 and J11. I am using the following formula syntax:
> > RCHGetYahooQuotes(H12:H36,I11:J11,NOW()), then CTRL,SHFT,ENTER. This
only returns a value in cell I12. What am I doing incorrectly? I would
like to be able to update the prices during the day.
> >
>
------------------------------------
Yahoo! Groups Links
very similar.
I seldom use arrays and my memory isn't what it use to be. So it a
re-learning every time.
The sequence order is important in defining the array. Use Excel help and
search on array.
-----Original Message-----
From: smf_addin@yahoogrou
Of Thomas
Sent: Friday, June 28, 2013 6:47 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] Re: GetYahooQuotes in an array formula not working for
me
Thanks for the reply, but that isn't working...I still only get a result in
cell I12.
--- In smf_addin@yahoogrou
wrote:
>
>
>
> I'm a newbie, but have the following observations.
>
> 1. Put a blank field ",," in front of the NOW() in your formula 2. Be
> sure you have selected the range I12:J36 before entering your formula in
cell I12, then CTRL, SHFT, ENTER.
>
> I hope this works for you.
>
> Matt G
>
> --- In smf_addin@yahoogrou
> >
> > I have a list of tickers in range H12 to H36. I have elements "l1" and
"p" in cells I11 and J11. I am using the following formula syntax:
> > RCHGetYahooQuotes(
only returns a value in cell I12. What am I doing incorrectly? I would
like to be able to update the prices during the day.
> >
>
------------
Yahoo! Groups Links
Fri Jun 28, 2013 6:27 am (PDT) . Posted by:
"Tom Bruin" tg.bruin
Thanks for the tip.using help on excel and searching array, I found my
mistake.I was entering the formula in the first cell of my range and not the
formula bar. Case closed!
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Kermit W. Prather
Sent: Friday, June 28, 2013 7:49 AM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Re: GetYahooQuotes in an array formula not working
for me
You need to define it as an array. I fought 4 hours yesterday with something
very similar.
I seldom use arrays and my memory isn't what it use to be. So it a
re-learning every time.
The sequence order is important in defining the array. Use Excel help and
search on array.
-----Original Message-----
From: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
[mailto:smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ] On
Behalf
Of Thomas
Sent: Friday, June 28, 2013 6:47 AM
To: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
Subject: [smf_addin] Re: GetYahooQuotes in an array formula not working for
me
Thanks for the reply, but that isn't working...I still only get a result in
cell I12.
--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
"mguerreiro99" <matthew.guerreiro@...>
wrote:
>
>
>
> I'm a newbie, but have the following observations.
>
> 1. Put a blank field ",," in front of the NOW() in your formula 2. Be
> sure you have selected the range I12:J36 before entering your formula in
cell I12, then CTRL, SHFT, ENTER.
>
> I hope this works for you.
>
> Matt G
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
"Thomas" <thos.bruin@> wrote:
> >
> > I have a list of tickers in range H12 to H36. I have elements "l1" and
"p" in cells I11 and J11. I am using the following formula syntax:
> > RCHGetYahooQuotes(H12:H36,I11:J11,NOW()), then CTRL,SHFT,ENTER. This
only returns a value in cell I12. What am I doing incorrectly? I would
like to be able to update the prices during the day.
> >
>
------------------------------------
Yahoo! Groups Links
mistake.I was entering the formula in the first cell of my range and not the
formula bar. Case closed!
From: smf_addin@yahoogrou
Of Kermit W. Prather
Sent: Friday, June 28, 2013 7:49 AM
To: smf_addin@yahoogrou
Subject: RE: [smf_addin] Re: GetYahooQuotes in an array formula not working
for me
You need to define it as an array. I fought 4 hours yesterday with something
very similar.
I seldom use arrays and my memory isn't what it use to be. So it a
re-learning every time.
The sequence order is important in defining the array. Use Excel help and
search on array.
-----Original Message-----
From: smf_addin@yahoogrou
[mailto:smf_addin@yahoogrou
Behalf
Of Thomas
Sent: Friday, June 28, 2013 6:47 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] Re: GetYahooQuotes in an array formula not working for
me
Thanks for the reply, but that isn't working...I still only get a result in
cell I12.
--- In smf_addin@yahoogrou
"mguerreiro99&
wrote:
>
>
>
> I'm a newbie, but have the following observations.
>
> 1. Put a blank field ",," in front of the NOW() in your formula 2. Be
> sure you have selected the range I12:J36 before entering your formula in
cell I12, then CTRL, SHFT, ENTER.
>
> I hope this works for you.
>
> Matt G
>
> --- In smf_addin@yahoogrou
"Thomas" <thos.bruin@
> >
> > I have a list of tickers in range H12 to H36. I have elements "l1" and
"p" in cells I11 and J11. I am using the following formula syntax:
> > RCHGetYahooQuotes(
only returns a value in cell I12. What am I doing incorrectly? I would
like to be able to update the prices during the day.
> >
>
------------
Yahoo! Groups Links
Fri Jun 28, 2013 11:44 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. Did you only enter the formula in cell I12?
You would need to select the range (e.g. I12:J36) before typing in the
formula and hitting Ctrl+Shift+Enter.
If that is the problem, try this -- click on cell I12, hold down the shift
key and select the range, then hit F2 to edit the formula, and hit
Ctrl+Shift+Enter to array-enter it over the new range. This technique works
for increasing the size of the range, but doesn't work for reducing it. If
you need to reduce the size of the range, you're best off copying the text
of the formula, deleting the range, and then picking out the new range size
and re-entering the formula.
On Thu, Jun 27, 2013 at 2:42 PM, Thomas <thos.bruin@gmail.com > wrote:
> I have a list of tickers in range H12 to H36. I have elements "l1" and
> "p" in cells I11 and J11. I am using the following formula syntax:
> RCHGetYahooQuotes(H12:H36,I11:J11,NOW()), then CTRL,SHFT,ENTER. This only
> returns a value in cell I12. What am I doing incorrectly? I would like to
> be able to update the prices during the day.
>
You would need to select the range (e.g. I12:J36) before typing in the
formula and hitting Ctrl+Shift+Enter.
If that is the problem, try this -- click on cell I12, hold down the shift
key and select the range, then hit F2 to edit the formula, and hit
Ctrl+Shift+Enter to array-enter it over the new range. This technique works
for increasing the size of the range, but doesn't work for reducing it. If
you need to reduce the size of the range, you're best off copying the text
of the formula, deleting the range, and then picking out the new range size
and re-entering the formula.
On Thu, Jun 27, 2013 at 2:42 PM, Thomas <thos.bruin@gmail.
> I have a list of tickers in range H12 to H36. I have elements "l1" and
> "p" in cells I11 and J11. I am using the following formula syntax:
> RCHGetYahooQuotes(
> returns a value in cell I12. What am I doing incorrectly? I would like to
> be able to update the prices during the day.
>
Fri Jun 28, 2013 12:09 pm (PDT) . Posted by:
"schlange.meister" schlange.meister
I am originally from USA and still invest in US markets, but I am living in switzerland now. Whenever I visit ADVfn, I am ALWAYS redirected to ch.advfn.com. It does not matter if I click on the US flag at the bottom of the page or use a different computer - I always end up at the swiss site. As a result, none of the smf add-in elements will work for me.
Is there a solution that you know of without going via proxy server?
Alternatively, is there another source of all the same figures for 10 years worth of data?
Is there a solution that you know of without going via proxy server?
Alternatively, is there another source of all the same figures for 10 years worth of data?
Fri Jun 28, 2013 12:41 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
This should help:
http://finance.groups.yahoo.com/group/smf_addin/message/21069
On Fri, Jun 28, 2013 at 12:09 PM, schlange.meister <
schlange.meister@yahoo.com > wrote:
> I am originally from USA and still invest in US markets, but I am living
> in switzerland now. Whenever I visit ADVfn, I am ALWAYS redirected to
> ch.advfn.com. It does not matter if I click on the US flag at the
> bottom of the page or use a different computer - I always end up at the
> swiss site. As a result, none of the smf add-in elements will work for me.
>
> Is there a solution that you know of without going via proxy server?
>
> Alternatively, is there another source of all the same figures for 10
> years worth of data?
>
http://finance.
On Fri, Jun 28, 2013 at 12:09 PM, schlange.meister <
schlange.meister@
> I am originally from USA and still invest in US markets, but I am living
> in switzerland now. Whenever I visit ADVfn, I am ALWAYS redirected to
> ch.advfn.com. It does not matter if I click on the US flag at the
> bottom of the page or use a different computer - I always end up at the
> swiss site. As a result, none of the smf add-in elements will work for me.
>
> Is there a solution that you know of without going via proxy server?
>
> Alternatively, is there another source of all the same figures for 10
> years worth of data?
>
Fri Jun 28, 2013 12:45 pm (PDT) . Posted by:
"schlange.meister" schlange.meister
Cool Thanks Randy. You Rock. I read the post you linked to. In order to get the US site to load, do I need to put US instead of UK or purely WWW?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> This should help:
> http://finance.groups.yahoo.com/group/smf_addin/message/21069
>
> On Fri, Jun 28, 2013 at 12:09 PM, schlange.meister <
> schlange.meister@...> wrote:
>
> > I am originally from USA and still invest in US markets, but I am living
> > in switzerland now. Whenever I visit ADVfn, I am ALWAYS redirected to
> > ch.advfn.com. It does not matter if I click on the US flag at the
> > bottom of the page or use a different computer - I always end up at the
> > swiss site. As a result, none of the smf add-in elements will work for me.
> >
> > Is there a solution that you know of without going via proxy server?
> >
> > Alternatively, is there another source of all the same figures for 10
> > years worth of data?
> >
>
--- In smf_addin@yahoogrou
>
> This should help:
> http://finance.
>
> On Fri, Jun 28, 2013 at 12:09 PM, schlange.meister <
> schlange.meister@
>
> > I am originally from USA and still invest in US markets, but I am living
> > in switzerland now. Whenever I visit ADVfn, I am ALWAYS redirected to
> > ch.advfn.com. It does not matter if I click on the US flag at the
> > bottom of the page or use a different computer - I always end up at the
> > swiss site. As a result, none of the smf add-in elements will work for me.
> >
> > Is there a solution that you know of without going via proxy server?
> >
> > Alternatively, is there another source of all the same figures for 10
> > years worth of data?
> >
>
Fri Jun 28, 2013 1:05 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The file should be empty (or non-existent) if you don't need to override
the default of "www". But if you put "www" into the file, it would be the
same as the default.
I added that file so people wouldn't need to go in and edit VBA code with
each new release. The ZIP file doesn't update that file, so once set it
should be set until manually changed (if ever).
On Fri, Jun 28, 2013 at 12:45 PM, schlange.meister <
schlange.meister@yahoo.com > wrote:
> Cool Thanks Randy. You Rock. I read the post you linked to. In order to
> get the US site to load, do I need to put US instead of UK or purely WWW?
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > This should help:
> > http://finance.groups.yahoo.com/group/smf_addin/message/21069
> >
> > On Fri, Jun 28, 2013 at 12:09 PM, schlange.meister <
> > schlange.meister@...> wrote:
> >
> > > I am originally from USA and still invest in US markets, but I am
> living
> > > in switzerland now. Whenever I visit ADVfn, I am ALWAYS redirected to
> > > ch.advfn.com. It does not matter if I click on the US flag at the
> > > bottom of the page or use a different computer - I always end up at the
> > > swiss site. As a result, none of the smf add-in elements will work
> for me.
> > >
> > > Is there a solution that you know of without going via proxy server?
> > >
> > > Alternatively, is there another source of all the same figures for 10
> > > years worth of data?
>
the default of "www"
same as the default.
I added that file so people wouldn't need to go in and edit VBA code with
each new release. The ZIP file doesn't update that file, so once set it
should be set until manually changed (if ever).
On Fri, Jun 28, 2013 at 12:45 PM, schlange.meister <
schlange.meister@
> Cool Thanks Randy. You Rock. I read the post you linked to. In order to
> get the US site to load, do I need to put US instead of UK or purely WWW?
>
> --- In smf_addin@yahoogrou
> >
> > This should help:
> > http://finance.
> >
> > On Fri, Jun 28, 2013 at 12:09 PM, schlange.meister <
> > schlange.meister@
> >
> > > I am originally from USA and still invest in US markets, but I am
> living
> > > in switzerland now. Whenever I visit ADVfn, I am ALWAYS redirected to
> > > ch.advfn.com. It does not matter if I click on the US flag at the
> > > bottom of the page or use a different computer - I always end up at the
> > > swiss site. As a result, none of the smf add-in elements will work
> for me.
> > >
> > > Is there a solution that you know of without going via proxy server?
> > >
> > > Alternatively, is there another source of all the same figures for 10
> > > years worth of data?
>
Fri Jun 28, 2013 1:13 pm (PDT) . Posted by:
"schlange.meister" schlange.meister
Thank you Randy,
I tried it with a blank file, non-existant file, www in the file and US in the file. Unfortunately, I still get Error in all Advfn elements
For example =RCHGetElementNumbe
Should give me the Annual statement Operating income for FY1, but all I get is Error. ADVfn has never really worked for me and I guess it is because I am living in Europe. The webpage only shows the German and swiss sites.
What do you think?
--- In smf_addin@yahoogrou
>
> The file should be empty (or non-existent) if you don't need to override
> the default of "www"
> same as the default.
>
> I added that file so people wouldn't need to go in and edit VBA code with
> each new release. The ZIP file doesn't update that file, so once set it
> should be set until manually changed (if ever).
>
> On Fri, Jun 28, 2013 at 12:45 PM, schlange.meister <
> schlange.meister@
>
> > Cool Thanks Randy. You Rock. I read the post you linked to. In order to
> > get the US site to load, do I need to put US instead of UK or purely WWW?
> >
> > --- In smf_addin@yahoogrou
> > >
> > > This should help:
> > > http://finance.
> > >
> > > On Fri, Jun 28, 2013 at 12:09 PM, schlange.meister <
> > > schlange.meister@
> > >
> > > > I am originally from USA and still invest in US markets, but I am
> > living
> > > > in switzerland now. Whenever I visit ADVfn, I am ALWAYS redirected to
> > > > ch.advfn.com. It does not matter if I click on the US flag at the
> > > > bottom of the page or use a different computer - I always end up at the
> > > > swiss site. As a result, none of the smf add-in elements will work
> > for me.
> > > >
> > > > Is there a solution that you know of without going via proxy server?
> > > >
> > > > Alternatively, is there another source of all the same figures for 10
> > > > years worth of data?
> >
>
Fri Jun 28, 2013 12:37 pm (PDT) . Posted by:
"Don" dsellari
Would it be possible for you to add something along the lines of **** below, or add another variable, to be able to get Yahoo quotes for stocks like CX which has non-standard options such as CX4 in 2014? Unfortunately, the sURL and the Find1 are different.
'modGetOptionQuotes
'Function smfGetYahooOptionQuote
'------------------> Do primary search
Dim nLast As Variant
If sTicker = "VIX" Then sTicker = "^VIX"
**** If IsNumeric(Right(sTicker, 1)) Then sTicker = Left(sTicker, Len(sTicker) - 1)
sURL = "http://finance.yahoo.com/q/op?s= " & sTicker & "&m=" & Format(pExpiry, "yyyy-mm")
Thanks in advance.
'modGetOptionQu
'Function smfGetYahooOptionQu
'-------
Dim nLast As Variant
If sTicker = "VIX" Then sTicker = "^VIX"
**** If IsNumeric(Right(
sURL = "http://finance.
Thanks in advance.
Fri Jun 28, 2013 12:59 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just uploaded RCH_Stock_Market_Functions-2.1.2013.06.28.zip to the "Works
in Progress" folder. I just expanded the "mini" option coding I added at
the start of the month. It was specific for a "7" instead of any numeric.
Let me know if that works for you...
On Fri, Jun 28, 2013 at 12:37 PM, Don <don@cemero.com> wrote:
> Would it be possible for you to add something along the lines of ****
> below, or add another variable, to be able to get Yahoo quotes for stocks
> like CX which has non-standard options such as CX4 in 2014? Unfortunately,
> the sURL and the Find1 are different.
>
> 'modGetOptionQuotes
>
> 'Function smfGetYahooOptionQuote
>
> '------------------> Do primary search
> Dim nLast As Variant
> If sTicker = "VIX" Then sTicker = "^VIX"
>
> **** If IsNumeric(Right(sTicker, 1)) Then sTicker = Left(sTicker,
> Len(sTicker) - 1)
>
> sURL = "http://finance.yahoo.com/q/op?s= " & sTicker & "&m=" &
> Format(pExpiry, "yyyy-mm")
>
>
in Progress" folder. I just expanded the "mini" option coding I added at
the start of the month. It was specific for a "7" instead of any numeric.
Let me know if that works for you...
On Fri, Jun 28, 2013 at 12:37 PM, Don <don@cemero.com> wrote:
> Would it be possible for you to add something along the lines of ****
> below, or add another variable, to be able to get Yahoo quotes for stocks
> like CX which has non-standard options such as CX4 in 2014? Unfortunately,
> the sURL and the Find1 are different.
>
> 'modGetOptionQu
>
> 'Function smfGetYahooOptionQu
>
> '-------
> Dim nLast As Variant
> If sTicker = "VIX" Then sTicker = "^VIX"
>
> **** If IsNumeric(Right(
> Len(sTicker) - 1)
>
> sURL = "http://finance.
> Format(pExpiry, "yyyy-mm"
>
>
Tidak ada komentar:
Posting Komentar