Messages In This Digest (24 Messages)
- 1a.
- Re: RCHGetYahooQuotes Array with Autofilter From: Randy Harmelink
- 1b.
- Re: RCHGetYahooQuotes Array with Autofilter From: back
- 1c.
- Re: RCHGetYahooQuotes Array with Autofilter From: Randy Harmelink
- 1d.
- Re: RCHGetYahooQuotes Array with Autofilter From: back
- 1e.
- Re: RCHGetYahooQuotes Array with Autofilter From: Randy Harmelink
- 2a.
- Re: magicformulainvesting.com From: carmine288
- 2b.
- Re: magicformulainvesting.com From: carmine288
- 2c.
- Re: magicformulainvesting.com From: Randy Harmelink
- 2d.
- Re: magicformulainvesting.com From: carmine288
- 2e.
- Re: magicformulainvesting.com From: Randy Harmelink
- 3a.
- Re: Getting Chart data to excel ( Reuters) From: R Marshal
- 4a.
- Re: Same RCHGetTableCell formula works in one Excel instance but not From: dwstelsel
- 5a.
- RCHGetElementNumber Error From: stepuptome229
- 5b.
- Re: RCHGetElementNumber Error From: Randy Harmelink
- 5c.
- Re: RCHGetElementNumber Error From: Bo Sutton
- 5d.
- Re: RCHGetElementNumber Error From: Randy Harmelink
- 6a.
- Quick Start From: sophoclessophocleous
- 6b.
- Re: Quick Start From: Randy Harmelink
- 7a.
- General From: april_joie26
- 7b.
- Re: General From: Randy Harmelink
- 8a.
- Re: Some Element Numbers Not Working From: ro.valen
- 8b.
- Re: Some Element Numbers Not Working From: Randy Harmelink
- 8c.
- Re: Some Element Numbers Not Working From: ro.valen
- 9a.
- Re: Company Description From: juranek54
Messages
- 1a.
-
Re: RCHGetYahooQuotes Array with Autofilter
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jun 19, 2012 3:24 am (PDT)
I just tried it without any problems...what issues are you having?
On Tue, Jun 19, 2012 at 12:03 AM, back <backmehl@yahoo.de > wrote:
> Hi Randy do you have any idea, how to use the RCHgetYahooQuotes-Array
> Formula with Autofilter.
>
- 1b.
-
Re: RCHGetYahooQuotes Array with Autofilter
Posted by: "back" backmehl@yahoo.de backmehl
Tue Jun 19, 2012 6:54 am (PDT)
Hi,
if i start the Autofilter and insert the Formula - only visible cells -, i get an error message ...
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I just tried it without any problems...what issues are you having?
>
> On Tue, Jun 19, 2012 at 12:03 AM, back <backmehl@...> wrote:
>
> > Hi Randy do you have any idea, how to use the RCHgetYahooQuotes-Array
> > Formula with Autofilter.
> >
>
- 1c.
-
Re: RCHGetYahooQuotes Array with Autofilter
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jun 19, 2012 9:17 am (PDT)
I do the formula first, then apply the filter to the results...
On Tue, Jun 19, 2012 at 6:54 AM, back <backmehl@yahoo.de > wrote:
>
> if i start the Autofilter and insert the Formula - only visible cells -, i
> get an error message ...
>
- 1d.
-
Re: RCHGetYahooQuotes Array with Autofilter
Posted by: "back" backmehl@yahoo.de backmehl
Tue Jun 19, 2012 11:53 pm (PDT)
Hi,
yes ok, but in my list there are nearer to 20000 symbols, so i only need the actual quotes if the filter is on ...
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I do the formula first, then apply the filter to the results...
>
> On Tue, Jun 19, 2012 at 6:54 AM, back <backmehl@...> wrote:
>
> >
> > if i start the Autofilter and insert the Formula - only visible cells -, i
> > get an error message ...
> >
>
- 1e.
-
Re: RCHGetYahooQuotes Array with Autofilter
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Jun 20, 2012 12:34 am (PDT)
I have no idea what "actual quotes" means. Besides, if you have 20000
symbols, you're going to need to have at least 100 invocations of the
function.
On Tue, Jun 19, 2012 at 11:49 PM, back <backmehl@yahoo.de > wrote:
>
> yes ok, but in my list there are nearer to 20000 symbols, so i only need
> the actual quotes if the filter is on ...
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > I do the formula first, then apply the filter to the results...
> >
> > On Tue, Jun 19, 2012 at 6:54 AM, back <backmehl@...> wrote:
> > >
> > > if i start the Autofilter and insert the Formula - only visible cells
> -, i
> > > get an error message ...
>
- 2a.
-
Re: magicformulainvesting.com
Posted by: "carmine288" carmine.nicoletta@gmail.com carmine288
Tue Jun 19, 2012 6:30 am (PDT)
FireFox (Tools -> Web Developer -> Page Source or CTRL-U)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I'm using FireFox. What are you using?
>
> On Mon, Jun 18, 2012 at 8:25 PM, carmine288 <carmine.nicoletta@...>wrote:
>
> > Maybe I'm doung something wrong, but the screened data isn't get saved.
> > Even when I tried to view the source, the data isn't there either.
> >
>
- 2b.
-
Re: magicformulainvesting.com
Posted by: "carmine288" carmine.nicoletta@gmail.com carmine288
Tue Jun 19, 2012 8:40 am (PDT)
FireFox (Tools -> Web Developer -> Page Source or CTRL-U)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I'm using FireFox. What are you using?
>
> On Mon, Jun 18, 2012 at 8:25 PM, carmine288 <carmine.nicoletta@...>wrote:
>
> > Maybe I'm doung something wrong, but the screened data isn't get saved.
> > Even when I tried to view the source, the data isn't there either.
> >
>
- 2c.
-
Re: magicformulainvesting.com
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jun 19, 2012 9:23 am (PDT)
Hmmm. What I did was Ctrl+A to select everything on the page, then use the
right mouse button to bring up the context menu, then chose "View Selection
Source".
Ctrl+U is probably giving you the DELIVERED source code of the web page, so
it won't contain the dynamically generated data portion of the web page.
On Tue, Jun 19, 2012 at 6:30 AM, carmine288 <carmine.nicoletta@gmail.com >wrote:
> FireFox (Tools -> Web Developer -> Page Source or CTRL-U)
>
- 2d.
-
Re: magicformulainvesting.com
Posted by: "carmine288" carmine.nicoletta@gmail.com carmine288
Tue Jun 19, 2012 2:18 pm (PDT)
Ctrl-A and "View Selection Source" does work. Thanks! But with FireFox, I can copy/paste just the screen selection into a spreadsheet. I just wish there is a way to automate this for multiple screens. Is there?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Hmmm. What I did was Ctrl+A to select everything on the page, then use the
> right mouse button to bring up the context menu, then chose "View Selection
> Source".
>
> Ctrl+U is probably giving you the DELIVERED source code of the web page, so
> it won't contain the dynamically generated data portion of the web page.
>
> On Tue, Jun 19, 2012 at 6:30 AM, carmine288 <carmine.nicoletta@...>wrote:
>
> > FireFox (Tools -> Web Developer -> Page Source or CTRL-U)
> >
>
- 2e.
-
Re: magicformulainvesting.com
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jun 19, 2012 2:29 pm (PDT)
I would bet there is a way to automate it, but I haven't used anything like
that for nearly 20 years. Back then, I used a product called WinBatch. Or,
if you Google "windows scripting", you may find some alternatives.
On Tue, Jun 19, 2012 at 2:18 PM, carmine288 <carmine.nicoletta@gmail.com >wrote:
> Ctrl-A and "View Selection Source" does work. Thanks! But with FireFox, I
> can copy/paste just the screen selection into a spreadsheet. I just wish
> there is a way to automate this for multiple screens. Is there?
>
- 3a.
-
Re: Getting Chart data to excel ( Reuters)
Posted by: "R Marshal" rmarshal78@yahoo.com rmarshal78
Tue Jun 19, 2012 7:17 am (PDT)
Hi Randy,
Essentially looking to get the Open High Low CLose VOlume data points into the excel for the time period selected .
http://charts.reuters.com/ reuters/enhancem ents/US/interact iveChart/ chart.asp? symbol=MSFT. OQ
regards,
Marshal.
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Tuesday, 19 June 2012 12:53 PM
Subject: Re: [smf_addin] Getting Chart data to excel ( Reuters)
What data in particular are you trying to extract?
On Mon, Jun 18, 2012 at 11:45 PM, Viju Joseph <josephviju@gmail.com > wrote:
>How do i go about extracting data from the frame. Can you guide plz ?
>
>
>On Tue, Jun 19, 2012 at 12:12 PM, Randy Harmelink <rharmelink@gmail.com > wrote:
>
>
>>I'm not quite sure exactly what you're after, but you'd need to extract the data from the frame. Not a trivial task:
>>
>>http://charts.reuters.com/ reuters/enhancem ents/US/interact iveChart/ chart.asp? symbol=MSFT. OQ
>>
- 4a.
-
Re: Same RCHGetTableCell formula works in one Excel instance but not
Posted by: "dwstelsel" dwstelsel@yahoo.com dwstelsel
Tue Jun 19, 2012 7:53 am (PDT)
For whatever reason it worked on all positions when I opened it up on Monday and then again this morning.
Thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Do you know if the FINRA website has any kind of mechanism to limit access?
> I had one person get errors from The Motley Fool after 13 or so accesses.
> When I tried it, it was because they started returning a web page that said
> "You appear to be an automated process instead of a person." instead of
> returning the normal data.
>
> I found that by visiting the URL of one of the errored out pages using the
> EXCEL Web Query dialog.
>
> The second instance could somehow look like a different person, so it
> returned the data?
>
> Otherwise, I would have suggested maybe you just got a bad web page, or
> timed out. That could be fixed with the smfForceRecalculation, but since
> you already did that...
>
> On Fri, Jun 15, 2012 at 11:05 AM, dwstelsel <dwstelsel@...> wrote:
>
> > I am using RCHGetTableCell to extract the Maturity Date: from bonds on the
> > FINRA website
> >
> > Example
> >
> > =RCHGetTableCell("
> > http://cxa.marketwatch.com/finra/ ",1,"MaturityBondCenter/ BondDetail. aspx?ID=Njc3NTZC Uks4
> > Date:")
> >
> > I get "Error" for this bond in the workbook in which I have 20 bonds I am
> > looking up. It works for the 19 others.
> >
> > I opened a second instance of Excel (while the other instance is still
> > open) and pasted this formula in a new workbook and it returns the correct
> > Maturity Date: of 04/01/2014
> >
> > Why would the exact same formula work in one Excel book and not another
> > separate instance of Excel?
> >
> > I added smForceRecalculation in the VBA for the tab but it did not help(if
> > that matters at all)
> >
>
- 5a.
-
RCHGetElementNumber Error
Posted by: "stepuptome229" stepuptome229@yahoo.com stepuptome229
Tue Jun 19, 2012 9:14 am (PDT)
Hello,
I am new to this tool but so far I think it is fantastic. I am having a few issues learning this and specifically I have run into a problem that perhaps somebody can help me with. I am using the 10 year financial summary template, which works fantastic. If I plug in a ticker like AAPL or IBM, everything works great. However, my end goal is to gather some data for ticker PCC. Whenever I plug this in, I just get a bunch of "error" messages. Can anyone tell me why this is happening, or the best way to get historical financial statements for PCC? Is there something special I have to do to get info for a small cap stock?
Thanks so much!
- 5b.
-
Re: RCHGetElementNumber Error
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jun 19, 2012 9:26 am (PDT)
Which template, specifically? There are several that have 10 years of data.
On Tue, Jun 19, 2012 at 6:59 AM, stepuptome229 <stepuptome229@yahoo.com >wrote:
>
> I am new to this tool but so far I think it is fantastic. I am having a
> few issues learning this and specifically I have run into a problem that
> perhaps somebody can help me with. I am using the 10 year financial summary
> template, which works fantastic. If I plug in a ticker like AAPL or IBM,
> everything works great. However, my end goal is to gather some data for
> ticker PCC. Whenever I plug this in, I just get a bunch of "error"
> messages. Can anyone tell me why this is happening, or the best way to get
> historical financial statements for PCC? Is there something special I have
> to do to get info for a small cap stock?
>
- 5c.
-
Re: RCHGetElementNumber Error
Posted by: "Bo Sutton" stepuptome229@yahoo.com stepuptome229
Tue Jun 19, 2012 9:35 am (PDT)
Files>templates and examples> uploaded by forum members> 10 year financial summary
Sent from my iPhone
On Jun 19, 2012, at 11:26 AM, Randy Harmelink <rharmelink@gmail.com > wrote:
> Which template, specifically? There are several that have 10 years of data.
>
>
> On Tue, Jun 19, 2012 at 6:59 AM, stepuptome229 <stepuptome229@yahoo.com > wrote:
>
> I am new to this tool but so far I think it is fantastic. I am having a few issues learning this and specifically I have run into a problem that perhaps somebody can help me with. I am using the 10 year financial summary template, which works fantastic. If I plug in a ticker like AAPL or IBM, everything works great. However, my end goal is to gather some data for ticker PCC. Whenever I plug this in, I just get a bunch of "error" messages. Can anyone tell me why this is happening, or the best way to get historical financial statements for PCC? Is there something special I have to do to get info for a small cap stock?
>
>
>
>
>
>
> - 5d.
-
Re: RCHGetElementNumber Error
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jun 19, 2012 9:39 am (PDT)
The reason PCC doesn't work is that it's a financial institution. They have
different line items than normal companies.
On Tue, Jun 19, 2012 at 9:35 AM, Bo Sutton <stepuptome229@yahoo.com > wrote:
>
> Files>templates and examples> uploaded by forum members> 10 year financial
> summary
>
- 6a.
-
Quick Start
Posted by: "sophoclessophocleous" sophoclessophocleous@yahoo.com sophoclessophocleous
Tue Jun 19, 2012 9:14 am (PDT)
Hi,
I discovered this yty and I would like to both thank you and congratulate you. What you have done is absolutely amazing!
My only question is regarding sources. I have been looking through some of the spreadsheets and one I found from a different site and it appears that some sources have changed. For example, I understand that morningstar income statement figures return an error.
What are the current most reliable sources? And is there a list of elements to reference?
Also, I would appreciate it if you could please give me an example of a code that works in excel for the income statement. For example, Sales.
I need something in place of
RCHGetTableCell("http://quicktake. morningstar. "&Ticker, 2, "Fiscal Year-End:", ">Revenue")com/Stock/ Income10. asp?Symbol=
I have gone through the various files but am still having some trouble.
This project is amazing and very helpful. My only comment is that a quick start guide is needed with a) current best sources, b)codes/elements, c) a couple of examples.
Thank you and all the best!!!
- 6b.
-
Re: Quick Start
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jun 19, 2012 9:32 am (PDT)
The issue with MorningStar is that they have converted several pages to
dynamic loading of the data onto the page. However, the add-in extracts
data from the source code of the web page. So there is no data to extract
from the source code of the web page if the data is presented dynamically.
I considered the installation documentation to be the quick start guide. It
summarizes several of the more common functions and points to their
documentation, each of which have examples. The available elements are
documented in the XLS file that was in the ZIP archive.
Most people tend to go to AdvFN for data, simply because it has a wider
breadth of data available -- both in number of time periods and line items
for each time period.
On Tue, Jun 19, 2012 at 5:11 AM, sophoclessophocleous <
sophoclessophocleous@yahoo.com > wrote:
>
> I discovered this yty and I would like to both thank you and congratulate
> you. What you have done is absolutely amazing!
>
> My only question is regarding sources. I have been looking through some
> of the spreadsheets and one I found from a different site and it appears
> that some sources have changed. For example, I understand that morningstar
> income statement figures return an error.
>
> What are the current most reliable sources? And is there a list of
> elements to reference?
>
> Also, I would appreciate it if you could please give me an example of a
> code that works in excel for the income statement. For example, Sales.
> I need something in place of
>
> RCHGetTableCell("
> http://quicktake.morningstar. "&Ticker, 2,com/Stock/ Income10. asp?Symbol=
> "Fiscal Year-End:", ">Revenue")
>
> I have gone through the various files but am still having some trouble.
>
> This project is amazing and very helpful. My only comment is that a quick
> start guide is needed with a) current best sources, b)codes/elements, c) a
> couple of examples.
>
> Thank you and all the best!!!
>
- 7a.
-
General
Posted by: "april_joie26" april_joie26@yahoo.com april_joie26
Tue Jun 19, 2012 9:15 am (PDT)
Dear Randy,
I am new to all this. Is there a fee associated with all the data that is available? For a portfolio of stocks do I have to make the portfolio with the data provider or on Excel?
Thanks so much...
April
- 7b.
-
Re: General
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jun 19, 2012 9:34 am (PDT)
The fees would be dependent on the web sites you are getting data from. For
example, I subscribe to investors.com in order to get IBD data. But most of
the data sources are free.
For a portfolio worksheet, play around with the RCHGetYahooQuotes()
function.
On Tue, Jun 19, 2012 at 3:28 AM, april_joie26 <april_joie26@yahoo.com >wrote:
>
> I am new to all this. Is there a fee associated with all the data that is
> available? For a portfolio of stocks do I have to make the portfolio with
> the data provider or on Excel?
>
- 8a.
-
Re: Some Element Numbers Not Working
Posted by: "ro.valen" ro.valen@yahoo.com ro.valen
Tue Jun 19, 2012 9:21 am (PDT)
Thank you for sending me the link, Randy.
The element numbers to which I am referring correspond to the numbers on the link, but how do I incorporate these changes into my spreadsheet? Or is it that the changes made by MSN cannot be incorporated into the "ADVFN" data that I get using the SMF Add-in?
Thanks again for your help.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It was a big topic of discussion about a month ago. See:
>
> http://finance.groups.yahoo. com/group/ smf_addin/ message/18529
>
> On Sat, Jun 9, 2012 at 11:28 PM, ro.valen <ro.valen@...> wrote:
>
> >
> > For the last couple weeks I have noticed that a few Element Numbers have
> > been producing error results. Below is a list of the elements with their
> > corresponding numbers. They used to work, but perhaps they have changed.
> > Has anyone else had similar issues? If so, can you please suggest a fix?
> >
> > Field Name Element Number
> > "Last Price" 25
> > "200 Day Moving Average" 36
> > "52 Week Low" 33
> > "52 Week High" 34
> > "Dividend Rate" 46
> >
> >
> > Thanks in advance for your help.
> >
> > Ro
> >
> >
> >
> > --------------------- --------- ------
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
>
- 8b.
-
Re: Some Element Numbers Not Working
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jun 19, 2012 9:36 am (PDT)
You need to replace that file in the add-in folder on your computer. So:
1. Exit EXCEL
2. Replace the existing smf-elements-1.txt file with the new one
3. Restart EXCEL
The new element definitions will be picked up when you restart EXCEL.
On Tue, Jun 19, 2012 at 9:21 AM, ro.valen <ro.valen@yahoo.com > wrote:
> Thank you for sending me the link, Randy.
>
> The element numbers to which I am referring correspond to the numbers on
> the link, but how do I incorporate these changes into my spreadsheet? Or is
> it that the changes made by MSN cannot be incorporated into the "ADVFN"
> data that I get using the SMF Add-in?
>
> Thanks again for your help.
>
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > It was a big topic of discussion about a month ago. See:
> >
> > http://finance.groups.yahoo. com/group/ smf_addin/ message/18529
>
- 8c.
-
Re: Some Element Numbers Not Working
Posted by: "ro.valen" ro.valen@yahoo.com ro.valen
Tue Jun 19, 2012 11:24 am (PDT)
Got it. It worked. Thank you for your help, Randy, and of course for sharing this wonderful tool with us.
Gratefully,
Rovalen
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You need to replace that file in the add-in folder on your computer. So:
>
> 1. Exit EXCEL
> 2. Replace the existing smf-elements-1.txt file with the new one
> 3. Restart EXCEL
>
> The new element definitions will be picked up when you restart EXCEL.
> On Tue, Jun 19, 2012 at 9:21 AM, ro.valen <ro.valen@...> wrote:
>
> > Thank you for sending me the link, Randy.
> >
> > The element numbers to which I am referring correspond to the numbers on
> > the link, but how do I incorporate these changes into my spreadsheet? Or is
> > it that the changes made by MSN cannot be incorporated into the "ADVFN"
> > data that I get using the SMF Add-in?
> >
> > Thanks again for your help.
> >
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > It was a big topic of discussion about a month ago. See:
> > >
> > > http://finance.groups.yahoo. com/group/ smf_addin/ message/18529
> >
>
- 9a.
-
Re: Company Description
Posted by: "juranek54" chad.juranek@gmail.com juranek54
Tue Jun 19, 2012 5:40 pm (PDT)
gracias
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I just use:
>
> =RCHGetElementNumber("MMM",1)
>
> However, you do need updates that occurred in May:
>
> http://finance.groups.yahoo. com/group/ smf_addin/ message/18529
>
> On Mon, Jun 18, 2012 at 5:31 PM, juranek54 <chad.juranek@...> wrote:
>
> > For a couple of my reports I like having the company description. For some
> > reason I can't find one that works. Is anyone else having problems with
> > this?
> >
>
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