6 New Messages
Digest #2476
Messages
Tue Jan 22, 2013 5:09 am (PST) . Posted by:
"cesarcrivelli" cesarcrivelli
Folks,
Need some help with another thing
I am trying to retrieve data from 4-traders
I create a name for the cell where the correspondent ticker data is, and in this case this cell name is "traders"
So, I need the folowing adress http://www.4-
Tried this, but I got a message error from excel. I think its something wrong after "&traders
=RCHGetTableCell(
Thanks,
Cesar
Tue Jan 22, 2013 6:59 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The string (i.e. /"):
"http://www.4-traders.com/ "&traders/"quotes"
...should be (i.e. &"/):
"http://www.4-traders.com/ "&traders&"/quotes"
On Tue, Jan 22, 2013 at 6:08 AM, cesarcrivelli cesarcrivelli@yahoo.com >wrote:
>
> Need some help with another thing
>
> I am trying to retrieve data from 4-traders
>
> I create a name for the cell where the correspondent ticker data is, and
> in this case this cell name is "traders"
>
> So, I need the folowing adress http://www.4-traders.com + ticker data (in
> this case traders) + /quotes
>
> Tried this, but I got a message error from excel. I think its something
> wrong after "&traders
>
> =RCHGetTableCell("http://www.4-traders.com/ "&traders/"quotes";1;"20 day"))
>
"http://www.4-
...should be (i.e. &"/):
"http://www.4-
On Tue, Jan 22, 2013 at 6:08 AM, cesarcrivelli cesarcrivelli@
>
> Need some help with another thing
>
> I am trying to retrieve data from 4-traders
>
> I create a name for the cell where the correspondent ticker data is, and
> in this case this cell name is "traders"
>
> So, I need the folowing adress http://www.4-
> this case traders) + /quotes
>
> Tried this, but I got a message error from excel. I think its something
> wrong after "&traders
>
> =RCHGetTableCell(
>
Tue Jan 22, 2013 6:25 am (PST) . Posted by:
"bagzigingahouse" bagzigingahouse
Hi Randy,
i have a question in regards to smfGetOptionStrikes function. It can only draw strikes for next available expiration? I tried to put some dates of prior expirations and all i get as a result is an empty cells.
Thanks,
Igor
i have a question in regards to smfGetOptionStrikes function. It can only draw strikes for next available expiration? I tried to put some dates of prior expirations and all i get as a result is an empty cells.
Thanks,
Igor
Tue Jan 22, 2013 7:04 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The data sources won't have any data for prior expiration dates.
On Tue, Jan 22, 2013 at 7:25 AM, bagzigingahouse
bagzigingahouse@gmail.com >wrote:
>
> i have a question in regards to smfGetOptionStrikes function. It can only
> draw strikes for next available expiration? I tried to put some dates of
> prior expirations and all i get as a result is an empty cells.
>
On Tue, Jan 22, 2013 at 7:25 AM, bagzigingahouse
bagzigingahouse@
>
> i have a question in regards to smfGetOptionStrikes function. It can only
> draw strikes for next available expiration? I tried to put some dates of
> prior expirations and all i get as a result is an empty cells.
>
Tue Jan 22, 2013 6:52 am (PST) . Posted by:
"Stephen Williams" smhwilliams41
hi Randy, firstly, thanks for the amazing work. I am having issues
downloading ohlc data with prices sometimes randomly changing from pence to
pounds (eg for the blackrock ftse100 etf, ISF.L : Price 578.9 on 10th Oct,
then 5.78 and similar to 29th Oct, then 581 and 586 on 29 and 30th Oct,
then back to 5.x for a few days- just wondering if there are any parameters
and/or alternative functions/sources that might force results into £ or
pence, and/or any mechanism for getting yahoo data cleaned.
(excel2010/W7x64). Many thanks
downloading ohlc data with prices sometimes randomly changing from pence to
pounds (eg for the blackrock ftse100 etf, ISF.L : Price 578.9 on 10th Oct,
then 5.78 and similar to 29th Oct, then 581 and 586 on 29 and 30th Oct,
then back to 5.x for a few days- just wondering if there are any parameters
and/or alternative functions/sources that might force results into £ or
pence, and/or any mechanism for getting yahoo data cleaned.
(excel2010/W7x64)
Tue Jan 22, 2013 6:56 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The data isn't in a table, so RCHGetTableCell() won't get it. Also, they
have additional junk in the "span" tag that holds the data, so you'll need
to parse the results that come back with something like:
=smfGetTagContent("
http://www.reuters.com/finance/stocks/overview?symbol=PETR4.SA ","span",1,">Prev
Close")
On Tue, Jan 22, 2013 at 5:18 AM, cesarcrivelli cesarcrivelli@yahoo.com >wrote:
>
> Leveraging from this topic, I am trying to get the Close, Open, High, Low,
> Vol, Avg Vol, 52 wk high, 52 wk low, from Reuters, trough the following
> address
>
> http://www.reuters.com/finance/stocks/overview?symbol=PETR4.SA
>
> I am using this formula
>
> =RCHGetTableCell("
> http://www.reuters.com/finance/stocks/overview?symbol=PETR4.SA ";1;"overview";"Prev
> Close")
>
> But instead of getting the close price I receive "beta:"
>
> Any help?
>
have additional junk in the "span" tag that holds the data, so you'll need
to parse the results that come back with something like:
=smfGetTagContent(
http://www.reuters.
Close")
On Tue, Jan 22, 2013 at 5:18 AM, cesarcrivelli cesarcrivelli@
>
> Leveraging from this topic, I am trying to get the Close, Open, High, Low,
> Vol, Avg Vol, 52 wk high, 52 wk low, from Reuters, trough the following
> address
>
> http://www.reuters.
>
> I am using this formula
>
> =RCHGetTableCell(
> http://www.reuters.
> Close")
>
> But instead of getting the close price I receive "beta:"
>
> Any help?
>
Tidak ada komentar:
Posting Komentar