13 Messages
Digest #3920
Messages
Mon Feb 13, 2017 11:54 pm (PST) . Posted by:
rjemery7
Using the SMF add-ins:
1) Is there any way to download technical data from StockCharts.com? I seek historical values for RSI-14 and the various Stochastics (Full, Fast, Slow). If one is a PRO subscriber, presumably it is possible, but I just need this data once for a study.
2) How about another source for the same historical data?
1) Is there any way to download technical data from StockCharts.
2) How about another source for the same historical data?
Tue Feb 14, 2017 5:54 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I don't see a way to extract the technical analysis data from
StockCharts.com.
I've used the ta-lib add-in in the past to generate technical analysis data
items:
http://www.ta-lib.org/
On Tue, Feb 14, 2017 at 12:54 AM, rjemery@
...wrote:
>
> Using the SMF add-ins:
>
> 1) Is there any way to download technical data from StockCharts.com? I
> seek historical values for RSI-14 and the various Stochastics (Full, Fast,
> Slow). If one is a PRO subscriber, presumably it is possible, but I just
> need this data once for a study.
>
> 2) How about another source for the same historical data?
>
StockCharts.com.
I've used the ta-lib add-in in the past to generate technical analysis data
items:
http://www.ta-lib.org/
On Tue, Feb 14, 2017 at 12:54 AM, rjemery@
...wrote:
>
> Using the SMF add-ins:
>
> 1) Is there any way to download technical data from StockCharts.
> seek historical values for RSI-14 and the various Stochastics (Full, Fast,
> Slow). If one is a PRO subscriber, presumably it is possible, but I just
> need this data once for a study.
>
> 2) How about another source for the same historical data?
>
Tue Feb 14, 2017 9:08 am (PST) . Posted by:
rjemery7
Thanks for the StockCharts confirmation and the reference to ta_lib. Much appreciated.
Tue Feb 14, 2017 10:04 am (PST) . Posted by:
john_hoel
I am using Excel 2013 on Windows 10. My version of the SMF add-in is 2.1.2016.09.02
I tried to turn on logging, using the SMF contest menu SMF => Logging => Open Log File. Windows 10 immediately says that Excel is no longer responding and terminates Excel.
I tried to turn on logging, using the SMF contest menu SMF => Logging => Open Log File. Windows 10 immediately says that Excel is no longer responding and terminates Excel.
Tue Feb 14, 2017 11:30 am (PST) . Posted by:
"Randy Harmelink" rharmelink
"Open Log File" doesn't turn on logging, it opens the existing log file.
You want to use the "Enable" option to turn on logging.
It could be the file doesn't exist yet and is causing your crash?
Otherwise, no clue as to what the cause might be for the crash...?
On Tue, Feb 14, 2017 at 10:58 AM, john@
...wrote:
>
> I am using Excel 2013 on Windows 10. My version of the SMF add-in is
> 2.1.2016.09.02
>
> I tried to turn on logging, using the SMF contest menu SMF => Logging =>
> Open Log File. Windows 10 immediately says that Excel is no longer
> responding and terminates Excel.
>
You want to use the "Enable" option to turn on logging.
It could be the file doesn't exist yet and is causing your crash?
Otherwise, no clue as to what the cause might be for the crash...?
On Tue, Feb 14, 2017 at 10:58 AM, john@
...wrote:
>
> I am using Excel 2013 on Windows 10. My version of the SMF add-in is
> 2.1.2016.09.
>
> I tried to turn on logging, using the SMF contest menu SMF => Logging =>
> Open Log File. Windows 10 immediately says that Excel is no longer
> responding and terminates Excel.
>
Tue Feb 14, 2017 11:38 am (PST) . Posted by:
john_hoel
I selected Enable, then tried to open the log file. Same crash. How do I determine if it exists? Where is it and what is its name?
Tue Feb 14, 2017 12:03 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Just enabling it won't create it. It just allows the add-in to append log
entries. You would need to actually use a function that gets data from the
Internet. For example:
=RCHGetYahooQuotes("MMM","l1")
...allows this to show up when I open my log file:
Time Stamp Duration Called URL
2017-02-14 12:59:54 0.0898
http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1&e=.ignore
Enabling logging should append data to this file in the SMF add-in folder:
smf-log.csv
...and that's the file that would be opened.
On Tue, Feb 14, 2017 at 12:38 PM, john@
...wrote:
>
> I selected Enable, then tried to open the log file. Same crash. How do I
> determine if it exists? Where is it and what is its name?
>
entries. You would need to actually use a function that gets data from the
Internet. For example:
=RCHGetYahooQuotes("MMM","l1")
...allows this to show up when I open my log file:
Time Stamp Duration Called URL
2017-02-14 12:59:54 0.0898
http://download.finance.yahoo.com/d/quotes.csv?s=MMM&f=sl1&e=.ignore
Enabling logging should append data to this file in the SMF add-in folder:
smf-log.csv
...and that's the file that would be opened.
On Tue, Feb 14, 2017 at 12:38 PM, john@
...wrote:
>
> I selected Enable, then tried to open the log file. Same crash. How do I
> determine if it exists? Where is it and what is its name?
>
Tue Feb 14, 2017 12:59 pm (PST) . Posted by:
john_hoel
There was text in that file but it was not created by the add-in. The text format broke Excel. I deleted it, did some logging, and opened it (via the context menu). That worked. Thanks for the help!
Tue Feb 14, 2017 10:31 am (PST) . Posted by:
cs190liv
Thank you so much. Please excuse my ignorance, the file, RCH_Stock_Market_Functions, locating at http://ogres-crypt.com/SMF http://ogres-crypt.com/SMF has the same RCH_Stock_Market_Functions-2.1.2016.12.03.zi http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2016.12.03.zipp. By any chance you have it in a different location?
Tue Feb 14, 2017 10:55 am (PST) . Posted by:
"Omar Jaleel" saanajaleel
It's in the top level files
http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2017.02.13.zip
On Feb 14, 2017 12:32 PM, "cs190liv@yahoo.com [smf_addin]" <
smf_addin@yahoogroups.com> wrote:
Thank you so much. Please excuse my ignorance, the file,
RCH_Stock_Market_Functions, locating at http://ogres-crypt.com/SMF has the
same RCH_Stock_Market_Functions-2.1.2016.12.03.zi
<http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2016.12.03.zip>p.
By any chance you have it in a different location?
http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2017.02.13.zip
On Feb 14, 2017 12:32 PM, "cs190liv@yahoo.com [smf_addin]" <
smf_addin@yahoogroups.com> wrote:
Thank you so much. Please excuse my ignorance, the file,
RCH_Stock_Market_Functions, locating at http://ogres-crypt.com/SMF has the
same RCH_Stock_Market_Functions-2.1.2016.12.03.zi
<http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2016.12.03.zip>p.
By any chance you have it in a different location?
Tue Feb 14, 2017 3:42 pm (PST) . Posted by:
garyhartling
Randy,
Is there a way to get option quotes like we can get Yahoo quotes that doesn't cause the entire spreadsheet to have to be updated?
--Gary H.
Is there a way to get option quotes like we can get Yahoo quotes that doesn't cause the entire spreadsheet to have to be updated?
--Gary H.
Tue Feb 14, 2017 4:39 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry, no. All of the options are done by extracting data from web pages,
instead of being provided via a CSV file.
On Tue, Feb 14, 2017 at 4:42 PM, Gary.Hartling@
...wrote:
> Is there a way to get option quotes like we can get Yahoo quotes that
> doesn't cause the entire spreadsheet to have to be updated?
>
>
instead of being provided via a CSV file.
On Tue, Feb 14, 2017 at 4:42 PM, Gary.Hartling@
...wrote:
> Is there a way to get option quotes like we can get Yahoo quotes that
> doesn't cause the entire spreadsheet to have to be updated?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar