2 New Messages
Digest #2347
| |
Messages
Mon Sep 17, 2012 1:21 pm (PDT) . Posted by:
"thomas91112" thomas91112
MSN no longer provides real time quotes, believe they are 15-20 minutes delayed. Google is the only source that appears to be providing real time quotes for free.
--- In smf_addin@yahoogroups.com , sudhir agarwal <Agarwal.sudhir@...> wrote:
>
> Hi,
> I have a created a sheet in which you can enter multiple symbols and it
> will give you the real time quote through MSN.
> You can also set teh refresh frequency(1 min, 2 min 5 mins etc) and data
> will be refreshed automatically.
> I hope this helps you.
> Sudhir
>
> On Thu, Aug 30, 2012 at 11:36 PM, leiliao78@...
> <liaolei78@...>wrote:
>
> > **
> >
> >
> >
> > Thanks Randy,I tried the RCHGetYahooQuotes(), and it works perfect.
> >
> > By the way, I want to automate this process by creating a ticker, so that
> > every time I change the ticker's symbol ( e.g. from AAPL to GOOG), the
> > current price of that ticker will show up accordingly.
> >
> > So I wrote this code: =RCHGetYahooQuotes("Ticker","l1"), and it returns me
> > the value of "0" for some reason. But if I write e.g. "GOOG" instead of
> > "ticker", it returns me the correct value.
> >
> > I don't know where I went wrong, could you tell me the problem with it?
> >
> > Thanks,
> >
> > Lei
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > For some reason, MSN is citing the previous day's closing price as the
> > > "Last Price". For current quotes, I suggest using the RCHGetYahooQuotes()
> > > function -- it can return numerous items on up to 200 ticker symbols in a
> > > single Internet access. Which can speed things up significantly from
> > > getting data items one web page at a time.
> > >
> > > On Thu, Aug 30, 2012 at 7:09 PM, leiliao78@ <liaolei78@>wrote:
> >
> > >
> > > >
> > > > I tried to get the last price of specific stock by using the function:
> > > > RCHGetElementNumber(),( # 25, source from MSN), and it seems it does
> > not
> > > > work any more.
> > > >
> > > > Do you know what the problem is? or is there another way to get the
> > last
> > > > price of specific stock?
> > > >
> > >
> >
> >
> >
>
--- In smf_addin@yahoogrou
>
> Hi,
> I have a created a sheet in which you can enter multiple symbols and it
> will give you the real time quote through MSN.
> You can also set teh refresh frequency(1 min, 2 min 5 mins etc) and data
> will be refreshed automatically.
> I hope this helps you.
> Sudhir
>
> On Thu, Aug 30, 2012 at 11:36 PM, leiliao78@..
> <liaolei78@.
>
> > **
> >
> >
> >
> > Thanks Randy,I tried the RCHGetYahooQuotes(
> >
> > By the way, I want to automate this process by creating a ticker, so that
> > every time I change the ticker's symbol ( e.g. from AAPL to GOOG), the
> > current price of that ticker will show up accordingly.
> >
> > So I wrote this code: =RCHGetYahooQuotes(
> > the value of "0" for some reason. But if I write e.g. "GOOG" instead of
> > "ticker", it returns me the correct value.
> >
> > I don't know where I went wrong, could you tell me the problem with it?
> >
> > Thanks,
> >
> > Lei
> >
> > --- In smf_addin@yahoogrou
> > >
> > > For some reason, MSN is citing the previous day's closing price as the
> > > "Last Price". For current quotes, I suggest using the RCHGetYahooQuotes(
> > > function -- it can return numerous items on up to 200 ticker symbols in a
> > > single Internet access. Which can speed things up significantly from
> > > getting data items one web page at a time.
> > >
> > > On Thu, Aug 30, 2012 at 7:09 PM, leiliao78@ <liaolei78@>
> >
> > >
> > > >
> > > > I tried to get the last price of specific stock by using the function:
> > > > RCHGetElementNumber
> > not
> > > > work any more.
> > > >
> > > > Do you know what the problem is? or is there another way to get the
> > last
> > > > price of specific stock?
> > > >
> > >
> >
> >
> >
>
Mon Sep 17, 2012 1:32 pm (PDT) . Posted by:
"Steven" stevenletzer
Fidelitr's public website with public bond information is quite simple to use. the address is https://fixedincome.fidelity.com/ftgw/fi/FIIndividualBondsSearch?cusip= For the CUSIP the address is https://fixedincome.fidelity.com/ftgw/fi/FIIndividualBondsSearch?cusip=404280AE9. The headers returned appear to be in table format, but I an having difficulty capturing the data. The table headers are:
Description, Coupon, Maturity Date, Moody's S&P Bid, Ask and so on. The first column of the table is Description. I have not found a word to amchor to. It would be easier if the CUSIP was the first (or any column).
Any ideas?
Description, Coupon, Maturity Date, Moody's S&P Bid, Ask and so on. The first column of the table is Description. I have not found a word to amchor to. It would be easier if the CUSIP was the first (or any column).
Any ideas?
Tidak ada komentar:
Posting Komentar