5 Messages
Digest #3040
Messages
Thu Apr 10, 2014 4:14 am (PDT) . Posted by:
lawleesh
Hi Randy
When I key in this formula
=RCHGetTableCell("http://www.marketwatch.com/investing/Stock/ASII/financials/cash-flow/quarter",4,"Cash Dividends Paid - Total")
Why does it give -1,000,000 when it should give -1B when I look at Page Source?
thanks
LL
When I key in this formula
=RCHGetTableCell("http://www.marketwatch.com/investing/Stock/ASII/financials/cash-flow/quarter",4,"
Why does it give -1,000,000 when it should give -1B when I look at Page Source?
thanks
LL
Thu Apr 10, 2014 7:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Because all amounts with a "B" or "M" suffix are converted into thousands
of dollars. That was the typical display amount when I did processing of
several financial statements early on.
You can always retrieve the raw data with smfGetTagContent() and convert
yourself, as needed.
On Thu, Apr 10, 2014 at 4:14 AM, <lawrence.leesh@gmail.com> wrote:
>
> When I key in this formula
> =RCHGetTableCell("
> http://www.marketwatch.com/investing/Stock/ASII/financials/cash-flow/quarter",4,"Cash
> Dividends Paid - Total")
> Why does it give -1,000,000 when it should give -1B when I look at Page
> Source?
>
>
of dollars. That was the typical display amount when I did processing of
several financial statements early on.
You can always retrieve the raw data with smfGetTagContent() and convert
yourself, as needed.
On Thu, Apr 10, 2014 at 4:14 AM, <lawrence.leesh@gmail.com> wrote:
>
> When I key in this formula
> =RCHGetTableCell("
> http://www.marketwatch.com/investing/Stock/ASII/financials/cash-flow/quarter",4,"
> Dividends Paid - Total")
> Why does it give -1,000,000 when it should give -1B when I look at Page
> Source?
>
>
Thu Apr 10, 2014 9:06 am (PDT) . Posted by:
lawleesh
May I trouble you to give me the formula that will return -1B like I see it on the screen?
thanks
LL
thanks
LL
Thu Apr 10, 2014 9:33 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try:
=smfstrExtr(smfGetTagContent("
http://www.marketwatch.com/investing/Stock/ASII/financials/cash-flow/quarter","td",4,"Cash
Dividends Paid - Total"),">","<")
To do the full conversion:
=smfConvertData(SUBSTITUTE(smfstrExtr(smfGetTagContent("
http://www.marketwatch.com/investing/Stock/ASII/financials/cash-flow/quarter","td",4,"Cash
Dividends Paid - Total"),">","<"),"B","000000000"))
On Thu, Apr 10, 2014 at 9:06 AM, <lawrence.leesh@gmail.com> wrote:
>
> May I trouble you to give me the formula that will return -1B like I see
> it on the screen?
>
=smfstrExtr(smfGetTagContent("
http://www.marketwatch.com/investing/Stock/ASII/financials/cash-flow/quarter","td",4,"Cash
Dividends Paid - Total"),">","<")
To do the full conversion:
=smfConvertData(SUBSTITUTE(smfstrExtr(smfGetTagContent("
http://www.marketwatch.com/investing/Stock/ASII/financials/cash-flow/quarter","td",4,"Cash
Dividends Paid - Total"),">","<"),"B","000000000"))
On Thu, Apr 10, 2014 at 9:06 AM, <lawrence.leesh@gmail.com> wrote:
>
> May I trouble you to give me the formula that will return -1B like I see
> it on the screen?
>
Tidak ada komentar:
Posting Komentar