5 New Messages
Digest #2822
Messages
Mon Oct 21, 2013 11:30 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The documentation for the functions is in the "Documentation" folder of the
FILES area of the group. And there are several entries in the LINKS area of
the group for information on smfUpdateDownloadTable.
smfUpdateDownloadTable is actually less efficient than the related
functions because it not only has to calculate the function, but place the
value in a cell. But since it saves a value, it does save you recalculation.
The 1000 web pages per session will apply to smfUpdateDownloadTable. I get
a little nervous when you talk about a large download. That's not what the
add-in is intended for.
On Mon, Oct 21, 2013 at 11:18 PM, <schlange.meister@yahoo.com> wrote:
>
> I am thinking of using smfUpdateDownloadTable and/or RCHGetYahooQuotes for
> some larger sheets and large downloads. Currently I have access to
> bloomberg terminal at work and want to develop alternative data sources for
> fall back purposes (change of job).
>
> Where can I read more about how those functions work and the limitations
> on them? I currently use the GetElement function and refer to the
> excellent Excel list of all data elements, but I guess that is rather
> inefficient compared to Download table or YahooQuotes.
>
>
FILES area of the group. And there are several entries in the LINKS area of
the group for information on smfUpdateDownloadTa
smfUpdateDownloadTa
functions because it not only has to calculate the function, but place the
value in a cell. But since it saves a value, it does save you recalculation.
The 1000 web pages per session will apply to smfUpdateDownloadTa
a little nervous when you talk about a large download. That's not what the
add-in is intended for.
On Mon, Oct 21, 2013 at 11:18 PM, <schlange.meister@
>
> I am thinking of using smfUpdateDownloadTa
> some larger sheets and large downloads. Currently I have access to
> bloomberg terminal at work and want to develop alternative data sources for
> fall back purposes (change of job).
>
> Where can I read more about how those functions work and the limitations
> on them? I currently use the GetElement function and refer to the
> excellent Excel list of all data elements, but I guess that is rather
> inefficient compared to Download table or YahooQuotes.
>
>
Mon Oct 21, 2013 11:53 pm (PDT) . Posted by:
lchen257
Hi Randy,
First just want to say thank you for providing this superb tool for the public to use!
I just started using SMF and am having difficulties getting data from the datacodelist k1.
For example, instead of showing 522 as the share price, it shows this:
N/A - <b>522.00</b>
Thank you very much,
LY
First just want to say thank you for providing this superb tool for the public to use!
I just started using SMF and am having difficulties getting data from the datacodelist k1.
For example, instead of showing 522 as the share price, it shows this:
N/A - <b>522.
Thank you very much,
LY
Tue Oct 22, 2013 12:01 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, I don't think Yahoo is gets ECN data any more. So I'm not
sure how accurate or reliable the ECN data codes are..?
But it looks like they are putting HTML tags for a web page display of the
data, instead of returning raw data. Note that "k1" is supposed to return
time and last price, so the "N/A" is probably the time they put in when the
market is closed.
On Mon, Oct 21, 2013 at 11:33 PM, <lchen257@yahoo.ca> wrote:
>
> First just want to say thank you for providing this superb tool for the
> public to use!
>
> I just started using SMF and am having difficulties getting data from the
> datacodelist k1.
>
> For example, instead of showing 522 as the share price, it shows this:
>
> N/A - <b>522.00</b>
>
sure how accurate or reliable the ECN data codes are..?
But it looks like they are putting HTML tags for a web page display of the
data, instead of returning raw data. Note that "k1" is supposed to return
time and last price, so the "N/A" is probably the time they put in when the
market is closed.
On Mon, Oct 21, 2013 at 11:33 PM, <lchen257@yahoo.
>
> First just want to say thank you for providing this superb tool for the
> public to use!
>
> I just started using SMF and am having difficulties getting data from the
> datacodelist k1.
>
> For example, instead of showing 522 as the share price, it shows this:
>
> N/A - <b>522.
>
Tue Oct 22, 2013 12:22 am (PDT) . Posted by:
lchen257
Thank you for the quick reply.
Do you suggest any way to retrieve share price?
I tried to use RCHGetElementNumber("Ticker", 25) with no luck.
The first ticker worked, but all subsequent tickers showed "error" as its value.
Thanks again,
LY
LY
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Unfortunately, I don't think Yahoo is gets ECN data any more. So I'm not sure how accurate or reliable the ECN data codes are..?
But it looks like they are putting HTML tags for a web page display of the data, instead of returning raw data. Note that "k1" is supposed to return time and last price, so the "N/A" is probably the time they put in when the market is closed.
On Mon, Oct 21, 2013 at 11:33 PM, <lchen257@... mailto:lchen257@...> wrote:
First just want to say thank you for providing this superb tool for the public to use!
I just started using SMF and am having difficulties getting data from the datacodelist k1.
For example, instead of showing 522 as the share price, it shows this:
N/A - <b>522.00</b>
Do you suggest any way to retrieve share price?
I tried to use RCHGetElementNumber
The first ticker worked, but all subsequent tickers showed "error" as its value.
Thanks again,
LY
LY
---In smf_addin@yahoogrou
Unfortunately, I don't think Yahoo is gets ECN data any more. So I'm not sure how accurate or reliable the ECN data codes are..?
But it looks like they are putting HTML tags for a web page display of the data, instead of returning raw data. Note that "k1" is supposed to return time and last price, so the "N/A" is probably the time they put in when the market is closed.
On Mon, Oct 21, 2013 at 11:33 PM, <lchen257@
First just want to say thank you for providing this superb tool for the public to use!
I just started using SMF and am having difficulties getting data from the datacodelist k1.
For example, instead of showing 522 as the share price, it shows this:
N/A - <b>522.
Tue Oct 22, 2013 12:35 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You should use the "l1" data code:
=RCHGetYahooQuotes("MMM","l1")
I obsoleted element #25 because MSN has been populating "Last Price" with
the previous day's closing price for well over a year now.
On Tue, Oct 22, 2013 at 12:22 AM, <lchen257@yahoo.ca> wrote:
> Do you suggest any way to retrieve share price?
>
> I tried to use RCHGetElementNumber("Ticker", 25) with no luck.
>
> The first ticker worked, but all subsequent tickers showed "error" as its
> value.
>
=RCHGetYahooQuotes(
I obsoleted element #25 because MSN has been populating "Last Price" with
the previous day's closing price for well over a year now.
On Tue, Oct 22, 2013 at 12:22 AM, <lchen257@yahoo.
> Do you suggest any way to retrieve share price?
>
> I tried to use RCHGetElementNumber
>
> The first ticker worked, but all subsequent tickers showed "error" as its
> value.
>
Tidak ada komentar:
Posting Komentar