15 New Messages
Digest #2910
Messages
Mon Dec 30, 2013 1:47 am (PST) . Posted by:
"Ton Sieverding" amsiev
Just for my information Randy. Is the same function available for MorningStarHistory ? I did not find it ...
Kind regards, Ton.
----- Original Message -----
From: Randy Harmelink
To: smf_addin@yahoogroups.com
Sent: Sunday, December 29, 2013 9:46 PM
Subject: Re: [smf_addin] RCHGetYahooHistory for DOW
Yes, but note their is no "Download to Spreadsheet" link on the page, like you see here:
http://finance.yahoo.com/q/hp?s=%5EGSPC+Historical+Prices
That link is the CSV file that RCHGetYahooHistory() used to use for ^DJI, before it was removed when Dow Jone asserted their licensing on the DJIA quotes.
On Sun, Dec 29, 2013 at 1:25 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:
Hi Randy. But I have access to DJI historical prices when going to the Yahoo web page
http://finance.yahoo.com/q/hp?s=%5EDJI+Historical+Prices
Kind regards, Ton.
----- Original Message -----
From: Randy Harmelink
To: smf_addin@yahoogrou
Sent: Sunday, December 29, 2013 9:46 PM
Subject: Re: [smf_addin] RCHGetYahooHistory for DOW
Yes, but note their is no "Download to Spreadsheet" link on the page, like you see here:
http://finance.
That link is the CSV file that RCHGetYahooHistory(
On Sun, Dec 29, 2013 at 1:25 PM, Jacob Jose <pepecan47@yahoo.
Hi Randy. But I have access to DJI historical prices when going to the Yahoo web page
http://finance.
Mon Dec 30, 2013 1:50 am (PST) . Posted by:
"Randy Harmelink" rharmelink
No. Where is historical data available in CSV format on MorningStar?
On Mon, Dec 30, 2013 at 2:05 AM, Ton Sieverding
<ton.sieverding@scarlet.be>wrote:
>
> Just for my information Randy. Is the same function available for
> MorningStarHistory ? I did not find it ...
>
On Mon, Dec 30, 2013 at 2:05 AM, Ton Sieverding
<ton.sieverding@
>
> Just for my information Randy. Is the same function available for
> MorningStarHistory ? I did not find it ...
>
Mon Dec 30, 2013 3:07 am (PST) . Posted by:
"Ton Sieverding" amsiev
http://performance.morningstar.com/stock/performance-return.action?p=price_history_page&t=IBM®ion=usa&culture=en-US&ownerCountry=USA
With "Download"; - here "Export" - button to Excel ....
Regards, Ton.
----- Original Message -----
From: Randy Harmelink
To: smf_addin@yahoogroups.com
Sent: Monday, December 30, 2013 10:50 AM
Subject: Re: [smf_addin] RCHGetYahooHistory for DOW
No. Where is historical data available in CSV format on MorningStar?
On Mon, Dec 30, 2013 at 2:05 AM, Ton Sieverding <ton.sieverding@scarlet.be> wrote:
Just for my information Randy. Is the same function available for MorningStarHistory ? I did not find it ...
With "Download"
Regards, Ton.
----- Original Message -----
From: Randy Harmelink
To: smf_addin@yahoogrou
Sent: Monday, December 30, 2013 10:50 AM
Subject: Re: [smf_addin] RCHGetYahooHistory for DOW
No. Where is historical data available in CSV format on MorningStar?
On Mon, Dec 30, 2013 at 2:05 AM, Ton Sieverding <ton.sieverding@
Just for my information Randy. Is the same function available for MorningStarHistory ? I did not find it ...
Mon Dec 30, 2013 3:16 am (PST) . Posted by:
"Ton Sieverding" amsiev
http://performance.morningstar.com/stock/performance-return.action?p=price_history_page&t=IBM®ion=usa&culture=en-US&ownerCountry=USA
With "Download"; - here "Export" - button to Excel ....
Regards, Ton.
----- Original Message -----
From: Randy Harmelink
To: smf_addin@yahoogroups.com
Sent: Monday, December 30, 2013 10:50 AM
Subject: Re: [smf_addin] RCHGetYahooHistory for DOW
No. Where is historical data available in CSV format on MorningStar?
On Mon, Dec 30, 2013 at 2:05 AM, Ton Sieverding <ton.sieverding@scarlet.be> wrote:
Just for my information Randy. Is the same function available for MorningStarHistory ? I did not find it ...
With "Download"
Regards, Ton.
----- Original Message -----
From: Randy Harmelink
To: smf_addin@yahoogrou
Sent: Monday, December 30, 2013 10:50 AM
Subject: Re: [smf_addin] RCHGetYahooHistory for DOW
No. Where is historical data available in CSV format on MorningStar?
On Mon, Dec 30, 2013 at 2:05 AM, Ton Sieverding <ton.sieverding@
Just for my information Randy. Is the same function available for MorningStarHistory ? I did not find it ...
Mon Dec 30, 2013 4:10 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. Not adjusted data though. But you could retrieve the data with
something like:
=smfGetCSVFile("
http://performance.morningstar.com/Performance/stock/exportStockPrice.action?t=IBM&pd=custom&freq=m&sd=01/01/2012&ed=12/27/2013
")
On Mon, Dec 30, 2013 at 4:07 AM, Ton Sieverding
<ton.sieverding@scarlet.be>wrote:
>
>
> http://performance.morningstar.com/stock/performance-return.action?p=price_history_page&t=IBM®ion=usa&culture=en-US&ownerCountry=USA
>
> With "Download"; - here "Export" - button to Excel ....
>
something like:
=smfGetCSVFile(
http://performance.
")
On Mon, Dec 30, 2013 at 4:07 AM, Ton Sieverding
<ton.sieverding@
>
>
> http://performance.
>
> With "Download"
>
Mon Dec 30, 2013 6:16 am (PST) . Posted by:
"Ton Sieverding" amsiev
http://performance.morningstar.com/stock/performance-return.action?p=price_history_page&t=IBM®ion=usa&culture=en-US&ownerCountry=USA
With "Download"; - here "Export" - button to Excel ....
Regards, Ton.
----- Original Message -----
From: Randy Harmelink
To: smf_addin@yahoogroups.com
Sent: Monday, December 30, 2013 10:50 AM
Subject: Re: [smf_addin] RCHGetYahooHistory for DOW
No. Where is historical data available in CSV format on MorningStar?
On Mon, Dec 30, 2013 at 2:05 AM, Ton Sieverding <ton.sieverding@scarlet.be> wrote:
Just for my information Randy. Is the same function available for MorningStarHistory ? I did not find it ...
With "Download"
Regards, Ton.
----- Original Message -----
From: Randy Harmelink
To: smf_addin@yahoogrou
Sent: Monday, December 30, 2013 10:50 AM
Subject: Re: [smf_addin] RCHGetYahooHistory for DOW
No. Where is historical data available in CSV format on MorningStar?
On Mon, Dec 30, 2013 at 2:05 AM, Ton Sieverding <ton.sieverding@
Just for my information Randy. Is the same function available for MorningStarHistory ? I did not find it ...
Mon Dec 30, 2013 7:08 am (PST) . Posted by:
"Ton Sieverding" amsiev
Thanks Randy. "Not adjusted data though" ... that's correct. But should not be a problem with the dividends included in the file ...
Kind regards, Ton.
PS : Sorry for the "mirror" behavior of my Outlook ...
----- Original Message -----
From: Randy Harmelink
To: smf_addin@yahoogroups.com
Sent: Monday, December 30, 2013 1:10 PM
Subject: Re: [smf_addin] RCHGetYahooHistory for DOW
Hmmm. Not adjusted data though. But you could retrieve the data with something like:
=smfGetCSVFile("http://performance.morningstar.com/Performance/stock/exportStockPrice.action?t=IBM&pd=custom&freq=m&sd=01/01/2012&ed=12/27/2013")
On Mon, Dec 30, 2013 at 4:07 AM, Ton Sieverding <ton.sieverding@scarlet.be> wrote:
http://performance.morningstar.com/stock/performance-return.action?p=price_history_page&t=IBM®ion=usa&culture=en-US&ownerCountry=USA
With "Download"; - here "Export" - button to Excel ....
Kind regards, Ton.
PS : Sorry for the "mirror" behavior of my Outlook ...
----- Original Message -----
From: Randy Harmelink
To: smf_addin@yahoogrou
Sent: Monday, December 30, 2013 1:10 PM
Subject: Re: [smf_addin] RCHGetYahooHistory for DOW
Hmmm. Not adjusted data though. But you could retrieve the data with something like:
=smfGetCSVFile(
On Mon, Dec 30, 2013 at 4:07 AM, Ton Sieverding <ton.sieverding@
http://performance.
With "Download"
Mon Dec 30, 2013 2:06 pm (PST) . Posted by:
"Camile Rowe" jardon_32
Hi Randy,
I haven't used your add in since 2011. I had built some tools for automated stock selection using the addin but I tried using it again but a number of the links which worked previously is no longer working. Could you give me some suggestions to fix the problem?
Thanks,
Camile
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Monday, December 30, 2013 7:10 AM
Subject: Re: [smf_addin] RCHGetYahooHistory for DOW
Hmmm. Not adjusted data though. But you could retrieve the data with something like:
=smfGetCSVFile("http://performance.morningstar.com/Performance/stock/exportStockPrice.action?t=IBM&pd=custom&freq=m&sd=01/01/2012&ed=12/27/2013")
On Mon, Dec 30, 2013 at 4:07 AM, Ton Sieverding <ton.sieverding@scarlet.be> wrote:
>
>http://performance.morningstar.com/stock/performance-return.action?p=price_history_page&t=IBM®ion=usa&culture=en-US&ownerCountry=USA
>
>With "Download"; - here "Export" - button to Excel ....
>
I haven't used your add in since 2011. I had built some tools for automated stock selection using the addin but I tried using it again but a number of the links which worked previously is no longer working. Could you give me some suggestions to fix the problem?
Thanks,
Camile
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Monday, December 30, 2013 7:10 AM
Subject: Re: [smf_addin] RCHGetYahooHistory for DOW
Hmmm. Not adjusted data though. But you could retrieve the data with something like:
=smfGetCSVFile(
On Mon, Dec 30, 2013 at 4:07 AM, Ton Sieverding <ton.sieverding@
>
>http://performance.
>
>With "Download"
>
Mon Dec 30, 2013 2:10 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Take a look at the "Location Errors" item in the LINKS area of the Yahoo
group...
On Mon, Dec 30, 2013 at 3:06 PM, Camile Rowe <jardon_32@yahoo.com> wrote:
> I haven't used your add in since 2011. I had built some tools for
> automated stock selection using the addin but I tried using it again but a
> number of the links which worked previously is no longer working. Could you
> give me some suggestions to fix the problem?
>
group...
On Mon, Dec 30, 2013 at 3:06 PM, Camile Rowe <jardon_32@yahoo.
> I haven't used your add in since 2011. I had built some tools for
> automated stock selection using the addin but I tried using it again but a
> number of the links which worked previously is no longer working. Could you
> give me some suggestions to fix the problem?
>
Mon Dec 30, 2013 4:41 pm (PST) . Posted by:
63b31a65c9c738e4af34541b0710492f
Hi Randy,
I'm trying to use RCHGetTableCell to retrieve the Beta for German stocks from a German website, e. g.
=RCHGetTableCell("http://www.finanzen.net/risikoanalyse/BMW";5;"Alternativen";"Beta";;;1)
The result should be 1,2 - but RCHGetTableCell returns 12 as it seems to simply ignore the comma as the decimal separator. I would at least expect it to return a string "1,2" instead...
Changing the local system settings to use a dot as the decimal separator does not help.
Any chance to change the behavior of RCHGetTableCell to work with comma a the decimal separator?
Many thanks
Markus
I'm trying to use RCHGetTableCell to retrieve the Beta for German stocks from a German website, e. g.
=RCHGetTableCell(
The result should be 1,2 - but RCHGetTableCell returns 12 as it seems to simply ignore the comma as the decimal separator. I would at least expect it to return a string "1,2" instead...
Changing the local system settings to use a dot as the decimal separator does not help.
Any chance to change the behavior of RCHGetTableCell to work with comma a the decimal separator?
Many thanks
Markus
Mon Dec 30, 2013 4:45 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
That's how VBA converts the data -- that is:
CDec("1,2") = 12
It appears to ignore the comma unless followed by 3 digits.
You could use smfGetTagContent() to grab the raw data, then convert it
yourself...
On Mon, Dec 30, 2013 at 5:29 PM, <m.heritsch@gmail.com> wrote:
>
> I'm trying to use RCHGetTableCell to retrieve the Beta for German stocks
> from a German website, e. g.
>
> =RCHGetTableCell("http://www.finanzen.net/risikoanalyse/BMW
> ";5;"Alternativen";"Beta";;;1)
>
> The result should be 1,2 - but RCHGetTableCell returns 12 as it seems to
> simply ignore the comma as the decimal separator. I would at least expect
> it to return a string "1,2" instead...
>
> Changing the local system settings to use a dot as the decimal separator
> does not help.
>
> Any chance to change the behavior of RCHGetTableCell to work with comma a
> the decimal separator?
>
>
CDec("1,
It appears to ignore the comma unless followed by 3 digits.
You could use smfGetTagContent(
yourself...
On Mon, Dec 30, 2013 at 5:29 PM, <m.heritsch@gmail.
>
> I'm trying to use RCHGetTableCell to retrieve the Beta for German stocks
> from a German website, e. g.
>
> =RCHGetTableCell(
> ";5;"
>
> The result should be 1,2 - but RCHGetTableCell returns 12 as it seems to
> simply ignore the comma as the decimal separator. I would at least expect
> it to return a string "1,2" instead...
>
> Changing the local system settings to use a dot as the decimal separator
> does not help.
>
> Any chance to change the behavior of RCHGetTableCell to work with comma a
> the decimal separator?
>
>
Mon Dec 30, 2013 4:46 pm (PST) . Posted by:
63b31a65c9c738e4af34541b0710492f
... sorry, I found an issue with my local system settings - problem fixed!
Thanks
Markus
Thanks
Markus
Mon Dec 30, 2013 5:45 pm (PST) . Posted by:
lawrence.leesh
Hi Randy
Could you pls help me with the formula to extract "Currency in SGD." from http://sg.finance.yahoo.com/q/hp?s=b20.si http://sg.finance.yahoo.com/q/hp?s=b20.si?
thanks
LL
Could you pls help me with the formula to extract "Currency in SGD." from http://sg.finance.
thanks
LL
Mon Dec 30, 2013 9:31 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Try:
=smfGetTagContent("http://sg.finance.yahoo.com/q/hp?s=b20.si","p",-1,"Currency
in")
On Mon, Dec 30, 2013 at 6:45 PM, <lawrence.leesh@yahoo.com> wrote:
>
> Could you pls help me with the formula to extract "Currency in SGD." from
> http://sg.finance.yahoo.com/q/hp?s=b20.si?
>
=smfGetTagContent(
in")
On Mon, Dec 30, 2013 at 6:45 PM, <lawrence.leesh@
>
> Could you pls help me with the formula to extract "Currency in SGD." from
> http://sg.finance.
>
Tue Dec 31, 2013 12:17 am (PST) . Posted by:
lawrence.leesh
Thanks Randy.
Tidak ada komentar:
Posting Komentar