15 New Messages
Digest #2942
Messages
Sun Jan 26, 2014 6:48 am (PST) . Posted by:
5626ab246680da11c468b726d6775461
I'm trying to build a sceener for AIM stocks on the London Stock Exchange. It seems only the LondonStockExchange website and Morningstar has financial statements for these firms. So using the page below I can figure out how to get 3 out of the four parts of the fourwaykey but I am not sure how to look up fourth - the segment. Do you have any idea how to do that?
http://www.londonstockexchange.com/exchange/companies-and-advisors/companies/stock-screener.html#result
http://www.londonst
Sun Jan 26, 2014 12:17 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You URL just gives me the front-end of the screener. No results to extract
from.
On Sun, Jan 26, 2014 at 7:48 AM, <stefan.schmidt296@gmail.com> wrote:
> I'm trying to build a sceener for AIM stocks on the London Stock
> Exchange. It seems only the LondonStockExchange website and Morningstar has
> financial statements for these firms. So using the page below I can figure
> out how to get 3 out of the four parts of the fourwaykey but I am not sure
> how to look up fourth - the segment. Do you have any idea how to do that?
>
from.
On Sun, Jan 26, 2014 at 7:48 AM, <stefan.schmidt296@
> I'm trying to build a sceener for AIM stocks on the London Stock
> Exchange. It seems only the LondonStockExchange website and Morningstar has
> financial statements for these firms. So using the page below I can figure
> out how to get 3 out of the four parts of the fourwaykey but I am not sure
> how to look up fourth - the segment. Do you have any idea how to do that?
>
Sun Jan 26, 2014 6:58 am (PST) . Posted by:
mikemcq802
Randy, I saw in some old posts you were bothered by having to "wake up" M* each day to get past its one-time redirection screen.
I recently ran into the same thing and found the redirection times out on its own. So, I wrote a short Powershell script to invoke IE and wait for that to clear. I run this in my morning bootup sequence so the rest of the day I can use M* without that nag.
Here's the script:
$ie = new-object -comobject "InternetExplorer.Application"
$ie.visible=$True # set to $False to hide IE window
$ie.navigate("www.morningstar.com")
while ($ie.Busy) {write-host "Waiting..." -fore yellow; start-sleep -s 2;}
$ie.quit()
If you have never run Powershell scripts on a machine, you must set the PS security to allow it. This MS page describes it well:
http://technet.microsoft.com/en-us/library/ee176949.aspx
Just trying to pay back all the work you've done. Cheers
I recently ran into the same thing and found the redirection times out on its own. So, I wrote a short Powershell script to invoke IE and wait for that to clear. I run this in my morning bootup sequence so the rest of the day I can use M* without that nag.
Here's the script:
$ie = new-object -comobject "InternetExplo
$ie.visible=
$ie.navigate(
while ($ie.Busy) {write-host "Waiting.
$ie.quit()
If you have never run Powershell scripts on a machine, you must set the PS security to allow it. This MS page describes it well:
http://technet.
Just trying to pay back all the work you've done. Cheers
Sun Jan 26, 2014 2:47 pm (PST) . Posted by:
andrewhills97
What is the RCH Element Number for 'Upcoming Events'?
Once a ticker has been entered in website front page, the data (which is a date and event description) is found in "NEWS & INFO" => "COMPANY EVENTS" => "UPCOMING EVENTS"
Once a ticker has been entered in website front page, the data (which is a date and event description) is found in "NEWS & INFO" => "COMPANY EVENTS" => "UPCOMING EVENTS"
Sun Jan 26, 2014 3:40 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
URL please. I don't even have a clue of which website you're talking about.
I'm sure there will not be an element. You'll have to use other SMF
functions to extract. And the "text" may contain HTML markup language, for
things like links.
On Sun, Jan 26, 2014 at 3:47 PM, <andrewhills97@yahoo.com> wrote:
>
> What is the RCH Element Number for 'Upcoming Events'?
>
> Once a ticker has been entered in website front page, the data (which is a
> date and event description) is found in "NEWS & INFO" => "COMPANY EVENTS"
> => "UPCOMING EVENTS"
>
I'm sure there will not be an element. You'll have to use other SMF
functions to extract. And the "text" may contain HTML markup language, for
things like links.
On Sun, Jan 26, 2014 at 3:47 PM, <andrewhills97@
>
> What is the RCH Element Number for 'Upcoming Events'?
>
> Once a ticker has been entered in website front page, the data (which is a
> date and event description) is found in "NEWS & INFO" => "COMPANY EVENTS"
> => "UPCOMING EVENTS"
>
Sun Jan 26, 2014 5:46 pm (PST) . Posted by:
andrewhills97
http://au.finance.yahoo.com/q/ce?s=WSM
If retrieving the text into Excel is difficult, just the date would be good.
Thanks Randy
If retrieving the text into Excel is difficult, just the date would be good.
Thanks Randy
Sun Jan 26, 2014 5:58 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Easy peasy. This should grab the whole table:
=RCHGetHTMLTable("http://au.finance.yahoo.com/q/ce?s=WSM",">Event",-1,"",1)
On Sun, Jan 26, 2014 at 6:46 PM, <andrewhills97@yahoo.com> wrote:
> http://au.finance.yahoo.com/q/ce?s=WSM
>
> If retrieving the text into Excel is difficult, just the date would be
> good.
>
=RCHGetHTMLTable(
On Sun, Jan 26, 2014 at 6:46 PM, <andrewhills97@
> http://au.finance.
>
> If retrieving the text into Excel is difficult, just the date would be
> good.
>
Sun Jan 26, 2014 6:37 pm (PST) . Posted by:
andrewhills97
this retrieves the word "Date". ??
thanks
thanks
Sun Jan 26, 2014 8:21 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You need to array-enter the function over a range. EXCEL functions can only
return values to cells they have been given access to.
On Sun, Jan 26, 2014 at 7:37 PM, <andrewhills97@yahoo.com> wrote:
> this retrieves the word "Date". ??
>
return values to cells they have been given access to.
On Sun, Jan 26, 2014 at 7:37 PM, <andrewhills97@
> this retrieves the word "Date"
>
Sun Jan 26, 2014 4:36 pm (PST) . Posted by:
thelancour
My apologies. I gave you the wrong link. I was referring to this link http://investing.money.msn.com/investments/key-ratios?symbol=aapl&page=TenYearSummary
In which I could not use the GetHTML function because I had no way to TAG the table. This is the one im stuck on.
In which I could not use the GetHTML function because I had no way to TAG the table. This is the one im stuck on.
Sun Jan 26, 2014 5:55 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Just as easy. This will grab both tables at the same time:
=RCHGetHTMLTable("
http://investing.money.msn.com/investments/key-ratios?symbol=aapl&page=TenYearSummary
","Industry:",1,"",2)
On Sun, Jan 26, 2014 at 5:36 PM, <thelancour@yahoo.com> wrote:
> My apologies. I gave you the wrong link. I was referring to this link
> http://investing.money.msn.com/investments/key-ratios?symbol=aapl&page=TenYearSummary
>
> In which I could not use the GetHTML function because I had no way to TAG
> the table. This is the one im stuck on.
>
=RCHGetHTMLTable(
http://investing.
","
On Sun, Jan 26, 2014 at 5:36 PM, <thelancour@yahoo.
> My apologies. I gave you the wrong link. I was referring to this link
> http://investing.
>
> In which I could not use the GetHTML function because I had no way to TAG
> the table. This is the one im stuck on.
>
Sun Jan 26, 2014 5:52 pm (PST) . Posted by:
whichwaytobeach
Hello,
For some of the call-outs the add-on Source brings back the data, for others it does not. For instance, I am trying to pull-in the Last Price (MSN, item 25 from the Element), but, it comes back with an Error message. In fact, many (all?) of the MSN call-outs bring back an Error message. Whereas, when I pull data from Google (say, 3007), it brings back the number.
Is there something I am doing wrong, or is there a way to remap the MSN call-outs to make them work again?
Regards & Thanks!
Marc
For some of the call-outs the add-on Source brings back the data, for others it does not. For instance, I am trying to pull-in the Last Price (MSN, item 25 from the Element), but, it comes back with an Error message. In fact, many (all?) of the MSN call-outs bring back an Error message. Whereas, when I pull data from Google (say, 3007), it brings back the number.
Is there something I am doing wrong, or is there a way to remap the MSN call-outs to make them work again?
Regards & Thanks!
Marc
Sun Jan 26, 2014 6:06 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
There have been a number of updates to element definitions since the last
official release of the add-in. Also, the "beta" version of the add-in has
some updates as well. You'll find the new files, including a change log, in
the "Works in Progress" folder of the FILES area. The element definitions
are the smf-element-*.txt files. Best practice is to exit EXCEL before
updating files.
For element #25, I obsoleted it, because MSN updated their stock print page
last year (which is why a number of other MSN elements don't work). They
were populating the "Last Price" field with the previous day's closing
price (and still are). For current quotes, take a look at the
RCHGetYahooQuotes() function. It can get a number of data items on up to
200 ticker symbols in a single Internet access.
Be sure to browse over the LINKS area of the group. There are a lot of
pointers to tips and answers to FAQs there.
I probably should update the "official release" with all current files, but
I've been waiting for AdvFN to go their new beta format first. Maybe it's
time to give up on them doing it in a timely fashion.
On Sun, Jan 26, 2014 at 5:58 PM, <WHICHWAYTOBEACH@hotmail.com> wrote:
>
> For some of the call-outs the add-on Source brings back the data, for
> others it does not. For instance, I am trying to pull-in the Last Price
> (MSN, item 25 from the Element), but, it comes back with an Error message.
> In fact, many (all?) of the MSN call-outs bring back an Error message.
> Whereas, when I pull data from Google (say, 3007), it brings back the
> number.
>
> Is there something I am doing wrong, or is there a way to remap the MSN
> call-outs to make them work again?
>
>
official release of the add-in. Also, the "beta" version of the add-in has
some updates as well. You'll find the new files, including a change log, in
the "Works in Progress" folder of the FILES area. The element definitions
are the smf-element-
updating files.
For element #25, I obsoleted it, because MSN updated their stock print page
last year (which is why a number of other MSN elements don't work). They
were populating the "Last Price" field with the previous day's closing
price (and still are). For current quotes, take a look at the
RCHGetYahooQuotes(
200 ticker symbols in a single Internet access.
Be sure to browse over the LINKS area of the group. There are a lot of
pointers to tips and answers to FAQs there.
I probably should update the "official release" with all current files, but
I've been waiting for AdvFN to go their new beta format first. Maybe it's
time to give up on them doing it in a timely fashion.
On Sun, Jan 26, 2014 at 5:58 PM, <WHICHWAYTOBEACH@
>
> For some of the call-outs the add-on Source brings back the data, for
> others it does not. For instance, I am trying to pull-in the Last Price
> (MSN, item 25 from the Element), but, it comes back with an Error message.
> In fact, many (all?) of the MSN call-outs bring back an Error message.
> Whereas, when I pull data from Google (say, 3007), it brings back the
> number.
>
> Is there something I am doing wrong, or is there a way to remap the MSN
> call-outs to make them work again?
>
>
Sun Jan 26, 2014 8:41 pm (PST) . Posted by:
"Marc ." whichwaytobeach
Thanks, but, I looked at the documentation for the yahoo function and I don't know how to use it; it looks very confusing to me. For now, I will just type it in. And, I will go to the Works in Progress folder to pick up the latest version of the add-on.
Thanks,
Marc
To: smf_addin@yahoogrou
From: rharmelink@gmail.
Date: Sun, 26 Jan 2014 19:06:02 -0700
Subject: Re: [smf_addin] Thanks for making! A question...
There have been a number of updates to element definitions since the last official release of the add-in. Also, the "beta" version of the add-in has some updates as well. You'll find the new files, including a change log, in the "Works in Progress" folder of the FILES area. The element definitions are the smf-element-
For element #25, I obsoleted it, because MSN updated their stock print page last year (which is why a number of other MSN elements don't work). They were populating the "Last Price" field with the previous day's closing price (and still are). For current quotes, take a look at the RCHGetYahooQuotes(
Be sure to browse over the LINKS area of the group. There are a lot of pointers to tips and answers to FAQs there.
I probably should update the "official release" with all current files, but I've been waiting for AdvFN to go their new beta format first. Maybe it's time to give up on them doing it in a timely fashion.
On Sun, Jan 26, 2014 at 5:58 PM, <WHICHWAYTOBEACH@
For some of the call-outs the add-on Source brings back the data, for others it does not. For instance, I am trying to pull-in the Last Price (MSN, item 25 from the Element), but, it comes back with an Error message. In fact, many (all?) of the MSN call-outs bring back an Error message. Whereas, when I pull data from Google (say, 3007), it brings back the number.
Is there something I am doing wrong, or is there a way to remap the MSN call-outs to make them work again?
Sun Jan 26, 2014 5:52 pm (PST) . Posted by:
whichwaytobeach
Yes! That is what brought me here.
I hope this works. I just downloaded the Add-on now. This will be so awesome if I can create auto-fill-ins.
Thanks!
Marc
I hope this works. I just downloaded the Add-on now. This will be so awesome if I can create auto-fill-ins.
Thanks!
Marc
Tidak ada komentar:
Posting Komentar