4 New Messages
Digest #2341
| |
Messages
Sun Sep 9, 2012 8:37 am (PDT) . Posted by:
"Rosendo Manuel" rosendojose
Problem solved. :)
However I still have a doubt about the information of RCHGetElementNumber (regarding of MSN). For example, information of the price is always from the previous day. Now, for example, RCHGetElementNumber 25 still shows the closing price on Thursday. It is possible to do something to update this information?
Or, alternatively, have we another number to get more timely quotations?
Thanks for your usual great help
Rosendo José
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I suspect you just need the updated element definitions for MSN, since they
> have changed their web page structure since the last official release of
> the add-in -- see:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/18529
>
> Best practice:
>
> 1. Exit EXCEL
> 2. Download the new version of the element definition file
> 3. Replace the older version of this file in your add-in's file folder
> with the newer downloaded version
> 4. Restart EXCEL
>
> Element #877 works fine here, if I make sure to visit the Morningstar
> website first with the EXCEL Web Query process or with IE (not with
> FireFox). MorningStar does some advertising redirections upon the first
> visit of the day, so you need to create an IE cookie so it knows you've
> already visited the site that day.
> On Sat, Sep 8, 2012 at 9:07 AM, Rosendo Manuel <rosendo.jose@...>wrote:
>
> > Well, it seems to be a problem of MSN (and also of Morningstar example
> > number 877), because the references to Yahoo (example number 562) or Zacks
> > (example number 848)work well.
> >
> > What'd be wrong?
> >
> > Rosendo José
> >
> >
> > --- In smf_addin@yahoogroups.com , "Rosendo Manuel" <rosendo.jose@>
> > wrote:
> > >
> > > Despite being an old user of SMF add-in I'm having a strange problem
> > > after doing an update with the latest version of 2 February (certainly
> > > for my mistake).For your reference, firstly, I have the add-in files in
> > > the folder C: \ SMF and have Excel configured in accordance Options \
> > > Suiplementos.As you can see from the Excel image, the formulas
> > > RCHGetElementNumber (and others) have all "Error".Can you help identify
> > > the possible error? I do not know what more to try ...
> >
>
However I still have a doubt about the information of RCHGetElementNumber (regarding of MSN). For example, information of the price is always from the previous day. Now, for example, RCHGetElementNumber 25 still shows the closing price on Thursday. It is possible to do something to update this information?
Or, alternatively, have we another number to get more timely quotations?
Thanks for your usual great help
Rosendo José
--- In smf_addin@yahoogrou
>
> I suspect you just need the updated element definitions for MSN, since they
> have changed their web page structure since the last official release of
> the add-in -- see:
>
> http://finance.
>
> Best practice:
>
> 1. Exit EXCEL
> 2. Download the new version of the element definition file
> 3. Replace the older version of this file in your add-in's file folder
> with the newer downloaded version
> 4. Restart EXCEL
>
> Element #877 works fine here, if I make sure to visit the Morningstar
> website first with the EXCEL Web Query process or with IE (not with
> FireFox). MorningStar does some advertising redirections upon the first
> visit of the day, so you need to create an IE cookie so it knows you've
> already visited the site that day.
> On Sat, Sep 8, 2012 at 9:07 AM, Rosendo Manuel <rosendo.jose@
>
> > Well, it seems to be a problem of MSN (and also of Morningstar example
> > number 877), because the references to Yahoo (example number 562) or Zacks
> > (example number 848)work well.
> >
> > What'd be wrong?
> >
> > Rosendo José
> >
> >
> > --- In smf_addin@yahoogrou
> > wrote:
> > >
> > > Despite being an old user of SMF add-in I'm having a strange problem
> > > after doing an update with the latest version of 2 February (certainly
> > > for my mistake).For your reference, firstly, I have the add-in files in
> > > the folder C: \ SMF and have Excel configured in accordance Options \
> > > Suiplementos.
> > > RCHGetElementNumber (and others) have all "Error".Can you help identify
> > > the possible error? I do not know what more to try ...
> >
>
Sun Sep 9, 2012 8:39 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, the previous day's closing price is what MSN is posting for
"Last Price".
You should use the RCHGetYahooQuotes() function for current quotes data...
On Sun, Sep 9, 2012 at 8:36 AM, Rosendo Manuel <rosendo.jose@gmail.com >wrote:
>
> However I still have a doubt about the information of RCHGetElementNumber
> (regarding of MSN). For example, information of the price is always from
> the previous day. Now, for example, RCHGetElementNumber 25 still shows the
> closing price on Thursday. It is possible to do something to update this
> information?
> Or, alternatively, have we another number to get more timely quotations?
> Thanks for your usual great help
>
"Last Price".
You should use the RCHGetYahooQuotes(
On Sun, Sep 9, 2012 at 8:36 AM, Rosendo Manuel <rosendo.jose@
>
> However I still have a doubt about the information of RCHGetElementNumber
> (regarding of MSN). For example, information of the price is always from
> the previous day. Now, for example, RCHGetElementNumber 25 still shows the
> closing price on Thursday. It is possible to do something to update this
> information?
> Or, alternatively, have we another number to get more timely quotations?
> Thanks for your usual great help
>
Sun Sep 9, 2012 10:48 am (PDT) . Posted by:
"Rosendo Manuel" rosendojose
Ok. Thanks again.
Rosendo José
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Unfortunately, the previous day's closing price is what MSN is posting for
> "Last Price".
>
> You should use the RCHGetYahooQuotes() function for current quotes data...
>
> On Sun, Sep 9, 2012 at 8:36 AM, Rosendo Manuel <rosendo.jose@...>wrote:
>
> >
> > However I still have a doubt about the information of RCHGetElementNumber
> > (regarding of MSN). For example, information of the price is always from
> > the previous day. Now, for example, RCHGetElementNumber 25 still shows the
> > closing price on Thursday. It is possible to do something to update this
> > information?
> > Or, alternatively, have we another number to get more timely quotations?
> > Thanks for your usual great help
> >
>
Rosendo José
--- In smf_addin@yahoogrou
>
> Unfortunately, the previous day's closing price is what MSN is posting for
> "Last Price".
>
> You should use the RCHGetYahooQuotes(
>
> On Sun, Sep 9, 2012 at 8:36 AM, Rosendo Manuel <rosendo.jose@
>
> >
> > However I still have a doubt about the information of RCHGetElementNumber
> > (regarding of MSN). For example, information of the price is always from
> > the previous day. Now, for example, RCHGetElementNumber 25 still shows the
> > closing price on Thursday. It is possible to do something to update this
> > information?
> > Or, alternatively, have we another number to get more timely quotations?
> > Thanks for your usual great help
> >
>
Sun Sep 9, 2012 11:41 pm (PDT) . Posted by:
"ajtalukdar" ajtalukdar
Thanks for the quick reply Randy.
You are right. I am getting the correct data now. So I will make a note to use the ForecRecalc macro next time!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I'm getting 770770 and 769640 right now. Is it possible you are extracting
> data from a web page that was saved when the data was different? The
> extracted data will reflect what is on the saved copy of the web page, not
> the current page on the web site.
>
> See the writeup on the smfForceRecalculation macro in the LINKS area of the
> group for more info.
>
> On Fri, Sep 7, 2012 at 11:52 PM, ajtalukdar <ajtalukdar@...> wrote:
>
> > I am making the following calls for getting float info
> >
> > RCHGetElementNumber(AMGN, 981)
> > RCHGetElementNumber(AMGN, 982)
> >
> > and getting the folllowing data respectively
> >
> > 770770
> > 776490
> >
> > A cross check with the Yahoo KS page (
> > http://finance.yahoo.com/q/ks?s=AMGN+Key+Statistics ) shows that the first
> > data fetched is correct while the second one is incorrect. It should have
> > fetched
> >
> > 769640
> >
> > Can someone help me with this discrepancy please?
> >
>
You are right. I am getting the correct data now. So I will make a note to use the ForecRecalc macro next time!
--- In smf_addin@yahoogrou
>
> I'm getting 770770 and 769640 right now. Is it possible you are extracting
> data from a web page that was saved when the data was different? The
> extracted data will reflect what is on the saved copy of the web page, not
> the current page on the web site.
>
> See the writeup on the smfForceRecalculati
> group for more info.
>
> On Fri, Sep 7, 2012 at 11:52 PM, ajtalukdar <ajtalukdar@
>
> > I am making the following calls for getting float info
> >
> > RCHGetElementNumber
> > RCHGetElementNumber
> >
> > and getting the folllowing data respectively
> >
> > 770770
> > 776490
> >
> > A cross check with the Yahoo KS page (
> > http://finance.
> > data fetched is correct while the second one is incorrect. It should have
> > fetched
> >
> > 769640
> >
> > Can someone help me with this discrepancy please?
> >
>
Tidak ada komentar:
Posting Komentar