Messages In This Digest (6 Messages)
- 1a.
- Re: Errors with RchGetYahooQuotes From: adam_sommers
- 1b.
- Re: Errors with RchGetYahooQuotes From: Martin Topper
- 1c.
- Re: Errors with RchGetYahooQuotes From: adam_sommers
- 2a.
- Re: London Stock Exchange - historical EPS data? From: kenyondj@ymail.com
- 3.1.
- New file uploaded to smf_addin From: smf_addin@yahoogroups.com
- 3.2.
- New file uploaded to smf_addin From: smf_addin@yahoogroups.com
Messages
- 1a.
-
Re: Errors with RchGetYahooQuotes
Posted by: "adam_sommers" adam@sommersfinancial.com adam_sommers
Wed Apr 11, 2012 9:36 am (PDT)
How do I use the "array-entered function" of RCHYahoogetquotes? I am having the same issue (I pull 100 prices on my worksheet) that others are: random "error" returns for quotes.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You can have the array-entered function input 200 ticker cells, even though
> only 50 are populated with ticker symbols. Then, instead of inserting a
> row, you just add it to the ticker symbol list...
>
> But it does depend on the process...
>
> On Tue, Apr 10, 2012 at 11:27 AM, Craig <craig.sander@...> wrote:
>
> >
> > Thanks for the reply. Unfortunately, my spreadsheet has automated
> > functions to insert new stocks (by adding rows) that would be difficult to
> > deal with in array mode. I’ve also noted that Yahoo is much slower than it
> > used to be.****
> >
> >
> >
>
- 1b.
-
Re: Errors with RchGetYahooQuotes
Posted by: "Martin Topper" mtopper@yahoo.com mtopper
Wed Apr 11, 2012 10:47 am (PDT)
The RCHYahooQuotes function can be used alone or as an array (much faster).
=RCHGetYahooQuotes(B5:B105,C4: h4)
where B5 through B105 can contain tickers or be blank
and c4 to h4 contain the parameters you want to retrieve such as l1 for last trade proce or c1 for change from provious close.
Copy the formula to C5
Then place a ' in front of it (to make it text)
Then highlight the region c5 to h105
Then remove the ' and hit (at the same time) Ctrl.Shift>Enter
and you now have an array 6 cols and 101 rows
change the tickers in col b or the parameters in row 4 as you desire
Marty
_____________________ _________ __
From: adam_sommers <adam@sommersfinancial.com >
To: smf_addin@yahoogroups.com
Sent: Wednesday, April 11, 2012 12:36 PM
Subject: [smf_addin] Re: Errors with RchGetYahooQuotes
How do I use the "array-entered function" of RCHYahoogetquotes? I am having the same issue (I pull 100 prices on my worksheet) that others are: random "error" returns for quotes.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You can have the array-entered function input 200 ticker cells, even though
> only 50 are populated with ticker symbols. Then, instead of inserting a
> row, you just add it to the ticker symbol list...
>
> But it does depend on the process...
>
> On Tue, Apr 10, 2012 at 11:27 AM, Craig <craig.sander@...> wrote:
>
> >
> > Thanks for the reply. Unfortunately, my spreadsheet has automated
> > functions to insert new stocks (by adding rows) that would be difficult to
> > deal with in array mode. I’ve also noted that Yahoo is much slower than it
> > used to be.****
> >
> >
> >
>
- 1c.
-
Re: Errors with RchGetYahooQuotes
Posted by: "adam_sommers" adam@sommersfinancial.com adam_sommers
Wed Apr 11, 2012 4:36 pm (PDT)
Thanks, Marty - that worked great...now if I can just remember the trick of control, shift, enter at once, I can use these in the future!
Adam
--- In smf_addin@yahoogroups.com , Martin Topper <mtopper@...> wrote:
>
> The RCHYahooQuotes function can be used alone or as an array (much faster).
>
> =RCHGetYahooQuotes(B5:B105,C4: h4)
>
> where B5 through B105 can contain tickers or be blank
>
> and c4 to h4 contain the parameters you want to retrieve such as l1 for last trade proce or c1 for change from provious close.
>
> Copy the formula to C5
> Then place a ' in front of it (to make it text)
> Then highlight the region c5 to h105
> Then remove the ' and hit (at the same time) Ctrl.Shift>Enter
>
> and you now have an array 6 cols and 101 rows
>
>
> change the tickers in col b or the parameters in row 4 as you desire
>
> Marty
>
>
>
>
>
> _____________________ _________ __
> From: adam_sommers <adam@...>
> To: smf_addin@yahoogroups.com
> Sent: Wednesday, April 11, 2012 12:36 PM
> Subject: [smf_addin] Re: Errors with RchGetYahooQuotes
>
>
> Â
> How do I use the "array-entered function" of RCHYahoogetquotes? I am having the same issue (I pull 100 prices on my worksheet) that others are: random "error" returns for quotes.
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > You can have the array-entered function input 200 ticker cells, even though
> > only 50 are populated with ticker symbols. Then, instead of inserting a
> > row, you just add it to the ticker symbol list...
> >
> > But it does depend on the process...
> >
> > On Tue, Apr 10, 2012 at 11:27 AM, Craig <craig.sander@> wrote:
> >
> > >
> > > Thanks for the reply. Unfortunately, my spreadsheet has automated
> > > functions to insert new stocks (by adding rows) that would be difficult to
> > > deal with in array mode. I’ve also noted that Yahoo is much slower than it
> > > used to be.****
> > >
> > >
> > >
> >
>
- 2a.
-
Re: London Stock Exchange - historical EPS data?
Posted by: "kenyondj@ymail.com" kenyondj@ymail.com kenyondj@ymail.com
Wed Apr 11, 2012 11:47 am (PDT)
That'll be it then - I was looking at a different page. Guess the data doesn't exist on ADVFN.
Thanks again for a great add-in though!
DK
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I don't see any quarterly or annual financial data web pages for LSE:PDL?
>
> On Tue, Apr 10, 2012 at 1:44 PM, kenyondj@... <kenyondj@...>wrote:
>
> >
> > I'm afraid that I'm still struggling.
> >
> > =smfGetAdvFNElement("LSE:PDL" ,"A",1,"> Year End Date<") for example returns
> > an error but I can get to the Financials webpage for LSE:PDL.
> >
> > Am I missing something obvious?
> >
>
- 3.1.
-
New file uploaded to smf_addin
Posted by: "smf_addin@yahoogroups.com" smf_addin@yahoogroups.com
Wed Apr 11, 2012 5:18 pm (PDT)
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Uploads by forum members/Money making worksheets/NASDAQ-DOW.xlsm
Uploaded by : digsupply <picsound@gmail.com >
Description : QueryTables NASDAQ 100 & Dow Industrials From Barchart
You can access this file at the URL:
http://groups.yahoo.com/ group/smf_ addin/files/ Uploads%20by% 20forum%20member s/Money%20making %20worksheets/ NASDAQ-DOW. xlsm
To learn more about file sharing for your group, please visit:
http://help.yahoo.com/ l/us/yahoo/ groups/original/ members/web/ index.html
Regards,
digsupply <picsound@gmail.com >
- 3.2.
-
New file uploaded to smf_addin
Posted by: "smf_addin@yahoogroups.com" smf_addin@yahoogroups.com
Wed Apr 11, 2012 8:54 pm (PDT)
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /1000 input tickers with RCHGetYahooQuotes function.xlsm
Uploaded by : digsupply <picsound@gmail.com >
Description : Get 1000 input tickers with RCHGetYahooQuotes function
You can access this file at the URL:
http://groups.yahoo.com/ group/smf_ addin/files/ 1000%20input% 20tickers% 20with%20RCHGetY ahooQuotes% 20function. xlsm
To learn more about file sharing for your group, please visit:
http://help.yahoo.com/ l/us/yahoo/ groups/original/ members/web/ index.html
Regards,
digsupply <picsound@gmail.com >
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar