9 Messages
Digest #4062
1a
Re: Stockcharts pulled into Excel for Daily Weekly and Monthly Chart by "Randy Harmelink" rharmelink
1c
Re: Stockcharts pulled into Excel for Daily Weekly and Monthly Chart by "Randy Harmelink" rharmelink
Messages
Sat Jun 17, 2017 8:13 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Next time it doesn't work, use the image URL that didn't work as your
address for alt+d+d+w and see if there is a message being provided...
When it fails, are you failing same-day, same-session, or between days? It
could be that the security cookie only has a short expiration period? Or,
are you using your account on another browser in between? I know IBD used
to log me out of one browser if I used a different browser to access the
data.
On Sat, Jun 17, 2017 at 6:51 PM, lutherkinchen@
...
wrote:
>
> I have been using the Alt+d+d+w to login to Stockcharts.com, and the
> process sometimes will pulls in the charts correctly. However, more
> often it does not. Really about a 20% success rate, at best.
>
> I keep going through the process of using the steps Alt+d+d+w hoping excel
> would somehow remember that I want it to remember to pull in the charts, I
> have set up correctly, but its seems to be hit and miss.
>
> More miss than correct.
>
> Any ideas on what I could be doing wrong, for it to work once in a while
> and not every time.
>
> Just hoping you or someone else would have run across these type issues
> before when using the comment formula like this one:
>
> =RCHCreateComment("
>
> http://stockcharts.com/c-sc/sc?s="&B1&"&p=M&yr=10&mn=0&dy=
> 0&i=p83276748253&a=529543242&r=1497528728185",99,,,)
>
> This site has been a true blessing. I realize you cannot fix everyone's
> issues, but I have seen you fix a ton of them. Hope all is well.
>
>
>
address for alt+d+d+w and see if there is a message being provided...
When it fails, are you failing same-day, same-session, or between days? It
could be that the security cookie only has a short expiration period? Or,
are you using your account on another browser in between? I know IBD used
to log me out of one browser if I used a different browser to access the
data.
On Sat, Jun 17, 2017 at 6:51 PM, lutherkinchen@
...
wrote:
>
> I have been using the Alt+d+d+w to login to Stockcharts.com, and the
> process sometimes will pulls in the charts correctly. However, more
> often it does not. Really about a 20% success rate, at best.
>
> I keep going through the process of using the steps Alt+d+d+w hoping excel
> would somehow remember that I want it to remember to pull in the charts, I
> have set up correctly, but its seems to be hit and miss.
>
> More miss than correct.
>
> Any ideas on what I could be doing wrong, for it to work once in a while
> and not every time.
>
> Just hoping you or someone else would have run across these type issues
> before when using the comment formula like this one:
>
> =RCHCreateComment("
>
> http://stockcharts.com/c-sc/sc?s="&B1&"
> 0&i=p83276748253&a=
>
> This site has been a true blessing. I realize you cannot fix everyone'
> issues, but I have seen you fix a ton of them. Hope all is well.
>
>
>
Sat Jun 17, 2017 9:22 pm (PDT) . Posted by:
lutherkinchen
Next time it doesn't work, use the image URL that didn't work as your address for alt+d+d+w and see if there is a message being provided...
It could be that the security cookie only has a short expiration period? (yes, all of these) Or, are you using your account on another browser in between? (I look at Stockcharts with another browser while the download is happening in excel using IE) I know IBD used to log me out of one browser if I used a different browser to access the data.
Answer:
When I log into Stockcharts, I think when I select the arrow at the top of the members area selection, it trys to download everything. Maybe that's too much data at once. Should I be trying to narrow down what gets pulled into excel.
I'm thinking though. What happened to you with IBD could possibly be my problem as well. I'll check that out first and see if it works.
Thank you,
Luther
It could be that the security cookie only has a short expiration period? (yes, all of these) Or, are you using your account on another browser in between? (I look at Stockcharts with another browser while the download is happening in excel using IE) I know IBD used to log me out of one browser if I used a different browser to access the data.
Answer:
When I log into Stockcharts, I think when I select the arrow at the top of the members area selection, it trys to download everything. Maybe that's too much data at once. Should I be trying to narrow down what gets pulled into excel.
I'm thinking though. What happened to you with IBD could possibly be my problem as well. I'll check that out first and see if it works.
Thank you,
Luther
Sat Jun 17, 2017 9:53 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not following and of these comments:
-- "...select the arrow at the top..."
-- "...download everything..."
-- "...too much data at once..."
On Sat, Jun 17, 2017 at 9:22 PM, lutherkinchen@
...
wrote:
>
> Next time it doesn't work, use the image URL that didn't work as your
> address for alt+d+d+w and see if there is a message being provided...
>
> It could be that the security cookie only has a short expiration period? *(yes,
> all of these)* Or, are you using your account on another browser in
> between? (*I look at Stockcharts with another browser while the download
> is happening in excel using IE) * I know IBD used to log me out of one
> browser if I used a different browser to access the data.
>
> Answer:
> When I log into Stockcharts, I think when I select the arrow at the top of
> the members area selection, it trys to download everything. Maybe that's
> too much data at once. Should I be trying to narrow down what gets pulled
> into excel.
>
> I'm thinking though. What happened to you with IBD could possibly be my
> problem as well. I'll check that out first and see if it works.
>
>
-- "...select the arrow at the top..."
-- "...download everything..
-- "...too much data at once..."
On Sat, Jun 17, 2017 at 9:22 PM, lutherkinchen@
...
wrote:
>
> Next time it doesn't work, use the image URL that didn't work as your
> address for alt+d+d+w and see if there is a message being provided...
>
> It could be that the security cookie only has a short expiration period? *(yes,
> all of these)* Or, are you using your account on another browser in
> between? (*I look at Stockcharts with another browser while the download
> is happening in excel using IE) * I know IBD used to log me out of one
> browser if I used a different browser to access the data.
>
> Answer:
> When I log into Stockcharts, I think when I select the arrow at the top of
> the members area selection, it trys to download everything. Maybe that's
> too much data at once. Should I be trying to narrow down what gets pulled
> into excel.
>
> I'm thinking though. What happened to you with IBD could possibly be my
> problem as well. I'll check that out first and see if it works.
>
>
Sat Jun 17, 2017 11:51 pm (PDT) . Posted by:
rimanda1
Passing excel serial values did the trick! I substituted
=RCHGetYahooHistory("aapl";, 2016, 6,27,2016,7, 8,"d")
with
=SMFGetYahooHistory("AAPL";,DATE(2016,6,27),DATE(2016,7,8),"d")
and my "down under" issues went away - works fine.
Thanks as always
=RCHGetYahooHistory
with
=SMFGetYahooHistory
and my "down under" issues went away - works fine.
Thanks as always
Sun Jun 18, 2017 7:40 am (PDT) . Posted by:
nlavery
This new version worked well for me using Excel 2003, but not with Excel 2013. Any suggestions?
Toby
Toby
Sun Jun 18, 2017 9:55 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
How was it not working well? Did you verify the version?
On Sun, Jun 18, 2017 at 7:40 AM, toby.avery@
...
wrote:
>
> This new version worked well for me using Excel 2003, but not with Excel
> 2013. Any suggestions?
>
>
>
On Sun, Jun 18, 2017 at 7:40 AM, toby.avery@
...
wrote:
>
> This new version worked well for me using Excel 2003, but not with Excel
> 2013. Any suggestions?
>
>
>
Sun Jun 18, 2017 10:50 am (PDT) . Posted by:
"Allan" aprivoisermoi2005
I'm interested in company financial data like:
RCHGetTableCell("http://finance.yahoo.com/q/is?s="&Ticker,1,"Period
Ending","Total Revenue",,,,"Add to Portfolio")
which quit working a few weeks ago using Stock Market Functions add-in,
Version 2.1.2017.05.01
I understand these updates are for various historical prices (not of
interest to me).
Is this permanently unavailable or in the future work pile?
Thanks for all you're doing Randy,
Allan
RCHGetTableCell("http://finance.yahoo.com/q/is?s="&Ticker,
Ending"
which quit working a few weeks ago using Stock Market Functions add-in,
Version 2.1.2017.05.
I understand these updates are for various historical prices (not of
interest to me).
Is this permanently unavailable or in the future work pile?
Thanks for all you're doing Randy,
Allan
Sun Jun 18, 2017 1:31 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
At the moment, the financial statements items can be retrieved from their
JSON feeds. For example, something like:
=smfGetYahooJSONField("MMM","incomeStatementHistory","quoteSummary.result.0.
incomeStatementHistory.incomeStatementHistory.0.totalRevenue.raw")
...which is:
=smfGetYahooJSONField(ticker,module,field-name)
I've identified a number of module and field name combinations:
http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-
Stock-Keyname-Database.xls
http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-
Mutual-Fund-Keyname-Database.xls
Eventually, I'll post a template using these types of formulas, but it's
just one more thing in that "work pile".
On Sun, Jun 18, 2017 at 10:19 AM, Allan allanhasmail@
...
wrote:
> I'm interested in company financial data like:
>
> RCHGetTableCell("http://finance.yahoo.com/q/is?s="&Ticker,1,"Period
> Ending","Total Revenue",,,,"Add to Portfolio")
>
> which quit working a few weeks ago using Stock Market Functions add-in,
> Version 2.1.2017.05.01
>
> I understand these updates are for various historical prices (not of
> interest to me).
>
> Is this permanently unavailable or in the future work pile?
>
> Thanks for all you're doing Randy,
>
>
JSON feeds. For example, something like:
=smfGetYahooJSONField("MMM","incomeStatementHistory","quoteSummary.result.0.
incomeStatementHistory.incomeStatementHistory.0.totalRevenue.raw")
...which is:
=smfGetYahooJSONField(ticker,module,field-name)
I've identified a number of module and field name combinations:
http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-
Stock-Keyname-Database.xls
http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-
Mutual-Fund-Keyname-Database.xls
Eventually, I'll post a template using these types of formulas, but it's
just one more thing in that "work pile".
On Sun, Jun 18, 2017 at 10:19 AM, Allan allanhasmail@
...
wrote:
> I'm interested in company financial data like:
>
> RCHGetTableCell("http://finance.yahoo.com/q/is?s="&Ticker,
> Ending"
>
> which quit working a few weeks ago using Stock Market Functions add-in,
> Version 2.1.2017.05.
>
> I understand these updates are for various historical prices (not of
> interest to me).
>
> Is this permanently unavailable or in the future work pile?
>
> Thanks for all you're doing Randy,
>
>
Sun Jun 18, 2017 3:10 pm (PDT) . Posted by:
"Allan" aprivoisermoi2005
Thank you Randy! That seems to work great.
On 06/18/2017 03:24 PM, Randy Harmelink rharmelink@gmail.com [smf_addin]
wrote:
> At the moment, the financial statements items can be retrieved from
> their JSON feeds. For example, something like:
>
> =smfGetYahooJSONField("MMM","incomeStatementHistory","quoteSummary.result.0.incomeStatementHistory.incomeStatementHistory.0.totalRevenue.raw")
>
> ...which is:
>
> =smfGetYahooJSONField(ticker,module,field-name)
>
> I've identified a number of module and field name combinations:
>
> http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Stock-Keyname-Database.xls
> <http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Stock-Keyname-Database.xls>
> http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Mutual-Fund-Keyname-Database.xls
> <http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Mutual-Fund-Keyname-Database.xls>
>
> Eventually, I'll post a template using these types of formulas, but
> it's just one more thing in that "work pile".
>
On 06/18/2017 03:24 PM, Randy Harmelink rharmelink@gmail.com [smf_addin]
wrote:
> At the moment, the financial statements items can be retrieved from
> their JSON feeds. For example, something like:
>
> =smfGetYahooJSONField("MMM","incomeStatementHistory","quoteSummary.result.0.incomeStatementHistory.incomeStatementHistory.0.totalRevenue.raw")
>
> ...which is:
>
> =smfGetYahooJSONField(ticker,module,field-name)
>
> I've identified a number of module and field name combinations:
>
> http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Stock-Keyname-Database.xls
> <http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Stock-Keyname-Database.xls>
> http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Mutual-Fund-Keyname-Database.xls
> <http://ogres-crypt.com/SMF/Elements/smfGetYahooJSONField-Mutual-Fund-Keyname-Database.xls>
>
> Eventually, I'll post a template using these types of formulas, but
> it's just one more thing in that "work pile".
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar