Messages In This Digest (7 Messages)
- 1a.
- Google share price data From: Steven
- 1b.
- Re: Google share price data From: Randy Harmelink
- 3.
- Currency Pair Quotes From: lexstar
- 4a.
- Odd error message From: Deborah
- 4b.
- Re: Odd error message From: Randy Harmelink
Messages
- 1a.
-
Google share price data
Posted by: "Steven" stevenletzer@yahoo.com stevenletzer
Thu Sep 1, 2011 8:21 am (PDT)
I am trying to capture the price, change and percent change for stocks that trade outside of the USA. For examples:
Hutchison Telecommunications Hong Kong Holdings Ltd., symbol HKG:0215
SmarTone Telecommunications Holdings Ltd. symbol HKG:0315
Tokyo Broadcasting System Incorporated symbol TYO:9401
These stocks trade in their domestic currency, so I most interested in the percent change.
Any ideas?
- 1b.
-
Re: Google share price data
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Sep 1, 2011 8:31 am (PDT)
Take a look at the SMF-Template-Yahoo-Google- Pre-Market- Quotes.xls template.
You'll need to expand the collapsed columns to get to the necessary
formulas.
On Thu, Sep 1, 2011 at 8:21 AM, Steven <stevenletzer@yahoo.com > wrote:
> I am trying to capture the price, change and percent change for stocks that
> trade outside of the USA. For examples:
> Hutchison Telecommunications Hong Kong Holdings Ltd., symbol HKG:0215
> SmarTone Telecommunications Holdings Ltd. symbol HKG:0315
> Tokyo Broadcasting System Incorporated symbol TYO:9401
>
> These stocks trade in their domestic currency, so I most interested in the
> percent change.
>
> Any ideas?
>
- 2a.
-
PDF
Posted by: "gz_cp" gz_cp@yahoo.com gz_cp
Thu Sep 1, 2011 11:08 am (PDT)
Does the plug-in has abilility to read a cell from a pdf like this?
http://www.tse.or.jp/english/ market/data/ short/b7gje60000 00h1n2-att/ 110901-me. pdf
Thanks.
- 2b.
-
Re: PDF
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Sep 1, 2011 11:34 am (PDT)
Nope, sorry. It all depends on how they create the PDF though. But I've only
seen a very few that are text-based enough to be able to interpret the data.
On Thu, Sep 1, 2011 at 11:08 AM, gz_cp <gz_cp@yahoo.com > wrote:
>
> Does the plug-in has abilility to read a cell from a pdf like this?
>
>
> http://www.tse.or.jp/english/ market/data/ short/b7gje60000 00h1n2-att/ 110901-me. pdf
>
>
- 3.
-
Currency Pair Quotes
Posted by: "lexstar" lexstar@yahoo.com lexstar
Thu Sep 1, 2011 7:05 pm (PDT)
Does anyone know where I can extract currency pair quotes? I thought about Yahoo, but I think Yahoo only has only a limited set of pairs.
Anything helps.
THanks.
- 4a.
-
Odd error message
Posted by: "Deborah" dcharlotte99@yahoo.com dcharlotte99
Thu Sep 1, 2011 8:16 pm (PDT)
Sent working file to a friend, he is receiving the following error message when trying for first time, using Excel in Office 11:
"This file was created in a newer version of Microsoft Excel. The file has been converted to a format you can work with, but the following issues were encountered. The file has been opened in Read-only mode to protect the original file.
Some cells contain multiple conditional formatting rules that should all be evaluated and shown. This version of Excel does not have that option, and will stop evaluation after the first true condition."
I've never seen this and not sure how to diagnose. Anyone have experience with this? I've used the file for over a year no problem on Excel 2003, 2007 and 2010.
Many thanks -
- 4b.
-
Re: Odd error message
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Sep 1, 2011 8:25 pm (PDT)
Since it's not related to the add-in, that question really should have been
directed to an EXCEL help group.
However, I think the message is self-explanatory -- EXCEL for Office 11 is a
different version of EXCEL that doesn't have all the features that you used
when you created the file.
On Thu, Sep 1, 2011 at 8:16 PM, Deborah <dcharlotte99@yahoo.com > wrote:
> Sent working file to a friend, he is receiving the following error message
> when trying for first time, using Excel in Office 11:
>
> "This file was created in a newer version of Microsoft Excel. The file has
> been converted to a format you can work with, but the following issues were
> encountered. The file has been opened in Read-only mode to protect the
> original file.
>
> Some cells contain multiple conditional formatting rules that should all be
> evaluated and shown. This version of Excel does not have that option, and
> will stop evaluation after the first true condition."
>
> I've never seen this and not sure how to diagnose. Anyone have experience
> with this? I've used the file for over a year no problem on Excel 2003,
> 2007 and 2010.
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar