15 New Messages
Digest #2952
Messages
Sat Feb 1, 2014 4:21 am (PST) . Posted by:
ssztaba
Dear Randy,
I've been asked to help someone install the smf add-in -- no problem, glad to do it.
HOWEVER, now I'm told that he has a MAC and is using VM software, running Windows 7 Professional, and Excel 2007.
Is there any way smf will run correctly with this configuration ??
I'm sure that I'm not the first to ask such a question. I don't see any folders relating to the MAC in the files -- perhaps it would be useful to have such a folder, even if only to say, "won't work", if that is the case.
Best wishes,
Stan Sztaba
I've been asked to help someone install the smf add-in -- no problem, glad to do it.
HOWEVER, now I'm told that he has a MAC and is using VM software, running Windows 7 Professional, and Excel 2007.
Is there any way smf will run correctly with this configuration ??
I'm sure that I'm not the first to ask such a question. I don't see any folders relating to the MAC in the files -- perhaps it would be useful to have such a folder, even if only to say, "won'
Best wishes,
Stan Sztaba
Sat Feb 1, 2014 7:18 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The general disclaimer on the front page of the group says, "No Mac. No
Open Office."
However, some Mac users have chimed in to say they can used it within a
Windows environment on their Mac. I'm not familiar with the Mac, so don't
know the details. You can search the group archives for "mac vm" and see
what discussion threads come up.
On Sat, Feb 1, 2014 at 5:21 AM, <ssjurik@optonline.net> wrote:
>
> I've been asked to help someone install the smf add-in -- no problem, glad
> to do it.
>
> HOWEVER, now I'm told that he has a MAC and is using VM software, running
> Windows 7 Professional, and Excel 2007.
>
> Is there any way smf will run correctly with this configuration ??
>
> I'm sure that I'm not the first to ask such a question. I don't see any
> folders relating to the MAC in the files -- perhaps it would be useful to
> have such a folder, even if only to say, "won't work", if that is the case.
>
Open Office."
However, some Mac users have chimed in to say they can used it within a
Windows environment on their Mac. I'm not familiar with the Mac, so don't
know the details. You can search the group archives for "mac vm" and see
what discussion threads come up.
On Sat, Feb 1, 2014 at 5:21 AM, <ssjurik@optonline.
>
> I've been asked to help someone install the smf add-in -- no problem, glad
> to do it.
>
> HOWEVER, now I'm told that he has a MAC and is using VM software, running
> Windows 7 Professional, and Excel 2007.
>
> Is there any way smf will run correctly with this configuration ??
>
> I'm sure that I'm not the first to ask such a question. I don't see any
> folders relating to the MAC in the files -- perhaps it would be useful to
> have such a folder, even if only to say, "won'
>
Sat Feb 1, 2014 7:26 am (PST) . Posted by:
bradleystipp@ymail.com
I have used it without issue for a year on the Windows side of my Mac using Parallels. I use Excel 2007 with Windows 7 Professional. Ignore the Mac and just install under Windows as if it were a PC. I don't know why VM would be any different than Parallels.
Sat Feb 1, 2014 6:36 am (PST) . Posted by:
rho49m
I understand I should use an array to download data for multiple tickers at the same time, what is the maximum number of tickers Yahoo will allow at once? If I need a greater number of tickers than allowed should I use two or more arrays on the same sheet of spreadsheet, put one array on sheet 1 of the workbook and array 2 on sheet 2 etc, or would I have to create separate files (workbooks) for each array?
2) I am sure I have missed it somewhere, is it possible to set the workbook to update automatically say every 10 min if so how?
Thank you!
2) I am sure I have missed it somewhere, is it possible to set the workbook to update automatically say every 10 min if so how?
Thank you!
Sat Feb 1, 2014 7:20 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Yahoo limits usage to 200 ticker symbols per request. So if you need more,
you need to do multiple function invocations. They can be on the same
worksheet.
If you want an auto-update, you'll need to write the VBA to do that. There
is a template in the FILES area.
On Sat, Feb 1, 2014 at 7:36 AM, <rho49m@yahoo.it> wrote:
>
> I understand I should use an array to download data for multiple tickers
> at the same time, what is the maximum number of tickers Yahoo will allow at
> once? If I need a greater number of tickers than allowed should I use two
> or more arrays on the same sheet of spreadsheet, put one array on sheet 1
> of the workbook and array 2 on sheet 2 etc, or would I have to create
> separate files (workbooks) for each array?
>
> 2) I am sure I have missed it somewhere, is it possible to set the
> workbook to update automatically say every 10 min if so how?
>
>
you need to do multiple function invocations. They can be on the same
worksheet.
If you want an auto-update, you'll need to write the VBA to do that. There
is a template in the FILES area.
On Sat, Feb 1, 2014 at 7:36 AM, <rho49m@yahoo.
>
> I understand I should use an array to download data for multiple tickers
> at the same time, what is the maximum number of tickers Yahoo will allow at
> once? If I need a greater number of tickers than allowed should I use two
> or more arrays on the same sheet of spreadsheet, put one array on sheet 1
> of the workbook and array 2 on sheet 2 etc, or would I have to create
> separate files (workbooks) for each array?
>
> 2) I am sure I have missed it somewhere, is it possible to set the
> workbook to update automatically say every 10 min if so how?
>
>
Sat Feb 1, 2014 7:22 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
Please don't misuse Randy's terrific tool
It is not meant to be a mass download tool.
I suggest you setup a scan on www.Freestockcharts.com to cull the entire stock market to a useable list of potential candidates. Then use SMF-ADDIN to select the information you want.
If you need help with the scan based on your criteria, I'll be happy to help you develop the scan but you will need to define the criteria.
For example, a very simple scan for the top 5% dividend stocks shows 228 stock instead of 8,000+ stocks
Scans can be as simple or complex as you want to make them. If you make the scan to complex you miss some potential candidates.
<http://www.Freestockcharts.com> www.Freestockcharts.com Real-Time data
U.S. stock data streams in real time from the BATS exchange. Trades from all other exchanges are delayed by 15 minutes.
Canadian TSX and Venture exchange data is delayed 15 minutes.
Forex currency pairs from CMS Forex stream in real-time from 5pm ET on Sundays until 5pm ET on Fridays.
I should tell you I am a reseller of Worden.com products which are available on my website. Tradingourway.com
but first start with the free product.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of rho49m@yahoo.it
Sent: Saturday, February 01, 2014 9:36 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] How many tickers can I download from Yahoo at once?
I understand I should use an array to download data for multiple tickers at the same time, what is the maximum number of tickers Yahoo will allow at once? If I need a greater number of tickers than allowed should I use two or more arrays on the same sheet of spreadsheet, put one array on sheet 1 of the workbook and array 2 on sheet 2 etc, or would I have to create separate files (workbooks) for each array?
2) I am sure I have missed it somewhere, is it possible to set the workbook to update automatically say every 10 min if so how?
Thank you!
It is not meant to be a mass download tool.
I suggest you setup a scan on www.Freestockcharts
If you need help with the scan based on your criteria, I'll be happy to help you develop the scan but you will need to define the criteria.
For example, a very simple scan for the top 5% dividend stocks shows 228 stock instead of 8,000+ stocks
Scans can be as simple or complex as you want to make them. If you make the scan to complex you miss some potential candidates.
<http://www.Freestoc
U.S. stock data streams in real time from the BATS exchange. Trades from all other exchanges are delayed by 15 minutes.
Canadian TSX and Venture exchange data is delayed 15 minutes.
Forex currency pairs from CMS Forex stream in real-time from 5pm ET on Sundays until 5pm ET on Fridays.
I should tell you I am a reseller of Worden.com products which are available on my website. Tradingourway.
but first start with the free product.
Kermit
From: smf_addin@yahoogrou
Sent: Saturday, February 01, 2014 9:36 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] How many tickers can I download from Yahoo at once?
I understand I should use an array to download data for multiple tickers at the same time, what is the maximum number of tickers Yahoo will allow at once? If I need a greater number of tickers than allowed should I use two or more arrays on the same sheet of spreadsheet, put one array on sheet 1 of the workbook and array 2 on sheet 2 etc, or would I have to create separate files (workbooks) for each array?
2) I am sure I have missed it somewhere, is it possible to set the workbook to update automatically say every 10 min if so how?
Thank you!
Sat Feb 1, 2014 7:27 am (PST) . Posted by:
"Dannyrussell53" udelfb92
Also, finviz.com has a screener which allows you to download all the tickers into excel. Programmatically, investexcel.com has a spreadsheet that allows you to just click a button.
Another way to download mass data is using another programming language (python) to pull all stocks by ticker into dataframes and then outputting to excel.
Hope this helps.
Cheers,
Danny
OsoCapitalResearch.com
Sent from my iPhone
> On Feb 1, 2014, at 10:22 AM, "Kermit W. Prather" <kermitp@tampabay.rr.com> wrote:
>
> Please don't misuse Randy's terrific tool
>
>
>
> It is not meant to be a mass download tool.
>
>
>
> I suggest you setup a scan on www.Freestockcharts.com to cull the entire stock market to a useable list of potential candidates. Then use SMF-ADDIN to select the information you want.
>
>
>
> If you need help with the scan based on your criteria, I'll be happy to help you develop the scan but you will need to define the criteria.
>
> For example, a very simple scan for the top 5% dividend stocks shows 228 stock instead of 8,000+ stocks
>
> Scans can be as simple or complex as you want to make them. If you make the scan to complex you miss some potential candidates.
>
>
>
> www.Freestockcharts.com Real-Time data
>
> U.S. stock data streams in real time from the BATS exchange. Trades from all other exchanges are delayed by 15 minutes.
>
> Canadian TSX and Venture exchange data is delayed 15 minutes.
>
> Forex currency pairs from CMS Forex stream in real-time from 5pm ET on Sundays until 5pm ET on Fridays.
>
>
>
> I should tell you I am a reseller of Worden.com products which are available on my website. Tradingourway.com
>
>
>
> but first start with the free product.
>
>
>
> Kermit
>
>
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of rho49m@yahoo.it
> Sent: Saturday, February 01, 2014 9:36 AM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] How many tickers can I download from Yahoo at once?
>
>
>
>
>
> I understand I should use an array to download data for multiple tickers at the same time, what is the maximum number of tickers Yahoo will allow at once? If I need a greater number of tickers than allowed should I use two or more arrays on the same sheet of spreadsheet, put one array on sheet 1 of the workbook and array 2 on sheet 2 etc, or would I have to create separate files (workbooks) for each array?
>
> 2) I am sure I have missed it somewhere, is it possible to set the workbook to update automatically say every 10 min if so how?
>
> Thank you!
>
>
>
>
>
>
>
Another way to download mass data is using another programming language (python) to pull all stocks by ticker into dataframes and then outputting to excel.
Hope this helps.
Cheers,
Danny
OsoCapitalResearch.
Sent from my iPhone
> On Feb 1, 2014, at 10:22 AM, "Kermit W. Prather" <kermitp@tampabay.
>
> Please don't misuse Randy's terrific tool
>
>
>
> It is not meant to be a mass download tool.
>
>
>
> I suggest you setup a scan on www.Freestockcharts
>
>
>
> If you need help with the scan based on your criteria, I'll be happy to help you develop the scan but you will need to define the criteria.
>
> For example, a very simple scan for the top 5% dividend stocks shows 228 stock instead of 8,000+ stocks
>
> Scans can be as simple or complex as you want to make them. If you make the scan to complex you miss some potential candidates.
>
>
>
> www.Freestockcharts
>
> U.S. stock data streams in real time from the BATS exchange. Trades from all other exchanges are delayed by 15 minutes.
>
> Canadian TSX and Venture exchange data is delayed 15 minutes.
>
> Forex currency pairs from CMS Forex stream in real-time from 5pm ET on Sundays until 5pm ET on Fridays.
>
>
>
> I should tell you I am a reseller of Worden.com products which are available on my website. Tradingourway.
>
>
>
> but first start with the free product.
>
>
>
> Kermit
>
>
>
> From: smf_addin@yahoogrou
> Sent: Saturday, February 01, 2014 9:36 AM
> To: smf_addin@yahoogrou
> Subject: [smf_addin] How many tickers can I download from Yahoo at once?
>
>
>
>
>
> I understand I should use an array to download data for multiple tickers at the same time, what is the maximum number of tickers Yahoo will allow at once? If I need a greater number of tickers than allowed should I use two or more arrays on the same sheet of spreadsheet, put one array on sheet 1 of the workbook and array 2 on sheet 2 etc, or would I have to create separate files (workbooks) for each array?
>
> 2) I am sure I have missed it somewhere, is it possible to set the workbook to update automatically say every 10 min if so how?
>
> Thank you!
>
>
>
>
>
>
>
Sat Feb 1, 2014 9:22 am (PST) . Posted by:
rho49m
thanks
Sat Feb 1, 2014 10:45 am (PST) . Posted by:
"PC_BABE" cs.holdings
What would the basic code look like to pull JNJ in python, then to export it to excel?
Thanks
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Dannyrussell53
Sent: Saturday, February 1, 2014 10:27 AM
To: smf_addin@yahoogroups.com
Cc: <smf_addin@yahoogroups.com>
Subject: Re: [smf_addin] How many tickers can I download from Yahoo at once?
Also, finviz.com <http://finviz.com> has a screener which allows you to download all the tickers into excel. Programmatically, investexcel.com <http://investexcel.com> has a spreadsheet that allows you to just click a button.
Another way to download mass data is using another programming language (python) to pull all stocks by ticker into dataframes and then outputting to excel.
Hope this helps.
Cheers,
Danny
OsoCapitalResearch.com <http://OsoCapitalResearch.com>
Sent from my iPhone
On Feb 1, 2014, at 10:22 AM, "Kermit W. Prather" <kermitp@tampabay.rr.com <mailto:kermitp@tampabay.rr.com> > wrote:
Please don't misuse Randy's terrific tool
It is not meant to be a mass download tool.
I suggest you setup a scan on www.Freestockcharts.com <http://www.Freestockcharts.com> to cull the entire stock market to a useable list of potential candidates. Then use SMF-ADDIN to select the information you want.
If you need help with the scan based on your criteria, I'll be happy to help you develop the scan but you will need to define the criteria.
For example, a very simple scan for the top 5% dividend stocks shows 228 stock instead of 8,000+ stocks
Scans can be as simple or complex as you want to make them. If you make the scan to complex you miss some potential candidates.
<http://www.Freestockcharts.com> www.Freestockcharts.com Real-Time data
U.S. stock data streams in real time from the BATS exchange. Trades from all other exchanges are delayed by 15 minutes.
Canadian TSX and Venture exchange data is delayed 15 minutes.
Forex currency pairs from CMS Forex stream in real-time from 5pm ET on Sundays until 5pm ET on Fridays.
I should tell you I am a reseller of Worden.com <http://Worden.com> products which are available on my website. Tradingourway.com <http://Tradingourway.com>
but first start with the free product.
Kermit
From: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> [mailto:smf_addin@yahoogroups.com] On Behalf Of rho49m@yahoo.it <mailto:rho49m@yahoo.it>
Sent: Saturday, February 01, 2014 9:36 AM
To: smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com>
Subject: [smf_addin] How many tickers can I download from Yahoo at once?
I understand I should use an array to download data for multiple tickers at the same time, what is the maximum number of tickers Yahoo will allow at once? If I need a greater number of tickers than allowed should I use two or more arrays on the same sheet of spreadsheet, put one array on sheet 1 of the workbook and array 2 on sheet 2 etc, or would I have to create separate files (workbooks) for each array?
2) I am sure I have missed it somewhere, is it possible to set the workbook to update automatically say every 10 min if so how?
Thank you!
Thanks
From: smf_addin@yahoogrou
Sent: Saturday, February 1, 2014 10:27 AM
To: smf_addin@yahoogrou
Cc: <smf_addin@yahoogrou
Subject: Re: [smf_addin] How many tickers can I download from Yahoo at once?
Also, finviz.com <http://finviz.
Another way to download mass data is using another programming language (python) to pull all stocks by ticker into dataframes and then outputting to excel.
Hope this helps.
Cheers,
Danny
OsoCapitalResearch.
Sent from my iPhone
On Feb 1, 2014, at 10:22 AM, "Kermit W. Prather" <kermitp@tampabay.
Please don't misuse Randy's terrific tool
It is not meant to be a mass download tool.
I suggest you setup a scan on www.Freestockcharts
If you need help with the scan based on your criteria, I'll be happy to help you develop the scan but you will need to define the criteria.
For example, a very simple scan for the top 5% dividend stocks shows 228 stock instead of 8,000+ stocks
Scans can be as simple or complex as you want to make them. If you make the scan to complex you miss some potential candidates.
<http://www.Freestoc
U.S. stock data streams in real time from the BATS exchange. Trades from all other exchanges are delayed by 15 minutes.
Canadian TSX and Venture exchange data is delayed 15 minutes.
Forex currency pairs from CMS Forex stream in real-time from 5pm ET on Sundays until 5pm ET on Fridays.
I should tell you I am a reseller of Worden.com <http://Worden.
but first start with the free product.
Kermit
From: smf_addin@yahoogrou
Sent: Saturday, February 01, 2014 9:36 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] How many tickers can I download from Yahoo at once?
I understand I should use an array to download data for multiple tickers at the same time, what is the maximum number of tickers Yahoo will allow at once? If I need a greater number of tickers than allowed should I use two or more arrays on the same sheet of spreadsheet, put one array on sheet 1 of the workbook and array 2 on sheet 2 etc, or would I have to create separate files (workbooks) for each array?
2) I am sure I have missed it somewhere, is it possible to set the workbook to update automatically say every 10 min if so how?
Thank you!
Sat Feb 1, 2014 7:39 am (PST) . Posted by:
jeffk279
First, I apologize if this is a redundant question. I tried searching for the answer, but could not find it. My question is in regards to the RCHGetElementNumber
Sat Feb 1, 2014 9:21 am (PST) . Posted by:
mikemcq802
Two part answer.
One. The GE annual report on their corporate website shows $156,783 as the revenue figure. I could not find MSN's figure of 155,278 in that report anywhere. It is not unusual for summarized data on free websites to vary. Sometimes they show the numbers right from the 10K and other times they show totals of specific line items within categories. For example, the "total segment earnings" is close to what MSN reports but the $156,783 figure includes that plus a small corporate adjustment to derive the complete total. See page 34 of the annual report:
http://www.ge.com/ar2009/pdf/ge_ar_2009.pdf
Two. There are many posts related to unreliable AdvFN data. They are in the process of converting to a new website format but still allow access to the old format. In the "old format" the quarterly numbers have been nearly useless for months. And, I started seeing errors in the "old format" annual data a few weeks ago as well. Since SMF can currently only use the old format data I converted my spreadsheets to use Morningstar data and I subscribed to get access to 10 years of history. I have found M* data to be fairly well scrubbed and consistent. I don't plan to go back to AdvFN even if they ever get their new format working and if SMF will be able to access it.
One. The GE annual report on their corporate website shows $156,783 as the revenue figure. I could not find MSN's figure of 155,278 in that report anywhere. It is not unusual for summarized data on free websites to vary. Sometimes they show the numbers right from the 10K and other times they show totals of specific line items within categories. For example, the "total segment earnings" is close to what MSN reports but the $156,783 figure includes that plus a small corporate adjustment to derive the complete total. See page 34 of the annual report:
http://www.ge.
Two. There are many posts related to unreliable AdvFN data. They are in the process of converting to a new website format but still allow access to the old format. In the "old format" the quarterly numbers have been nearly useless for months. And, I started seeing errors in the "old format" annual data a few weeks ago as well. Since SMF can currently only use the old format data I converted my spreadsheets to use Morningstar data and I subscribed to get access to 10 years of history. I have found M* data to be fairly well scrubbed and consistent. I don't plan to go back to AdvFN even if they ever get their new format working and if SMF will be able to access it.
Sat Feb 1, 2014 9:22 am (PST) . Posted by:
jeffk279
Thank you. I really appreciate the information.
Sat Feb 1, 2014 9:25 am (PST) . Posted by:
climbermel
For some time I 've had trouble with the hard coding issue of Excel. It only takes a second to fix now, but I would still like to try and resolve WHY it still does it. The problem is when I open a sheet that was opened on a different computer, it can't find the addin. Is there something in the code that picks which drive to look for the AddIn? It resides in C:\Program Files\SMF Add-in on both machines, but it used to be in U:\Program Files\SMF Add-in (my User drive). I opens fine every time on the other machine, but frequently it still seems to be looking for U:\Program Files\SMF Add-in. I could place a copy there, but I'd rather understand WHY it is doing this. When I open a sheet, I can just point it to the C: folder and continue. I have also used the replace all to remove the hard coded location and that works as well.
I have also looked through the registry and can't find why it keeps thinking it should be on U:
Thanks, Mel
Sat Feb 1, 2014 9:32 am (PST) . Posted by:
freefaller6
This just happened to me and it drove me crazy. Not sure what version of Excel you're using, but I have 2013, which is similar to 2010. Try this. Open Excel>File>Options>Addins, select the smf addin, hit go, deselect the addin, click ok.
Make sure you don't have a copy of it on the U: drive, and only in the C: drive where you want it.
Close Excel.
Open Excel>File>Options>Addins, select the smf addin, hit go, then browse, select the folder and addin in the C: drive where you want it. Hit ok. Close Excel.
That should do it.
Make sure you don't have a copy of it on the U: drive, and only in the C: drive where you want it.
Close Excel.
Open Excel>File>
That should do it.
Sat Feb 1, 2014 10:55 am (PST) . Posted by:
adam_sommers
Thank you - I will update my sheet and cross my fingers this works!
Adam
Adam
Tidak ada komentar:
Posting Komentar