12 New Messages
Digest #2686
Messages
Mon Jul 8, 2013 1:00 pm (PDT) . Posted by:
"Fred Wright" fredwwright
I have been using Randy's great add-in with Excel 2013 with no problems.
Fred
Fred
Mon Jul 8, 2013 7:43 pm (PDT) . Posted by:
"Mac" mac_rmm
Thanks. I just tried it in Excel 2010 instead and it didn't work either for. My hard drive crapped out a few days ago so I had to do a clean install of Windows 8 with a fresh install of excel too.
Now for some reason, I can't get any of my old files that used this Add-in to work. I was able to get a few to run and update, but as soon as I try to save them, excel shuts down. Now, I can't even get them to update. Not sure what the problem is - I didn't change anything with what I was doing before my hard drive crapped out. Frustrating.
--- In smf_addin@yahoogrou
>
> I have been using Randy's great add-in with Excel 2013 with no problems.
>
> Fred
>
Mon Jul 8, 2013 7:58 pm (PDT) . Posted by:
"Mac" mac_rmm
I found part of the solution to my problem in this message http://finance.groups.yahoo.com/group/smf_addin/message/11346
Excel changed all of my formulas by adding the location of the Add-in which messed everything up.
However, I am still unable to save any changes to my spreadsheet without Excel crashing. This is in both 2013 and 2013 versions. Anyone have an idea of what I can do???? Thanks.
--- In smf_addin@yahoogroups.com , "Mac" <mac_rmm@...> wrote:
>
>
> Thanks. I just tried it in Excel 2010 instead and it didn't work either for. My hard drive crapped out a few days ago so I had to do a clean install of Windows 8 with a fresh install of excel too.
>
> Now for some reason, I can't get any of my old files that used this Add-in to work. I was able to get a few to run and update, but as soon as I try to save them, excel shuts down. Now, I can't even get them to update. Not sure what the problem is - I didn't change anything with what I was doing before my hard drive crapped out. Frustrating.
>
> --- In smf_addin@yahoogroups.com , Fred Wright <fredwwright@> wrote:
> >
> > I have been using Randy's great add-in with Excel 2013 with no problems.
> >
> > Fred
> >
>
Excel changed all of my formulas by adding the location of the Add-in which messed everything up.
However, I am still unable to save any changes to my spreadsheet without Excel crashing. This is in both 2013 and 2013 versions. Anyone have an idea of what I can do???? Thanks.
--- In smf_addin@yahoogrou
>
>
> Thanks. I just tried it in Excel 2010 instead and it didn't work either for. My hard drive crapped out a few days ago so I had to do a clean install of Windows 8 with a fresh install of excel too.
>
> Now for some reason, I can't get any of my old files that used this Add-in to work. I was able to get a few to run and update, but as soon as I try to save them, excel shuts down. Now, I can't even get them to update. Not sure what the problem is - I didn't change anything with what I was doing before my hard drive crapped out. Frustrating.
>
> --- In smf_addin@yahoogrou
> >
> > I have been using Randy's great add-in with Excel 2013 with no problems.
> >
> > Fred
> >
>
Mon Jul 8, 2013 1:34 pm (PDT) . Posted by:
"cgrablew" cgrablew
Where there changes made to the SMF Update Download Table? Field 13862 Stock Name no longer works. I've been using the SMF update download table for years and now some of the fields no longer work like 13862. It worked approximately 2 weeks ago. What has changed?
Mon Jul 8, 2013 3:09 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
See: http://finance.groups.yahoo.com/group/smf_addin/message/22683
On Mon, Jul 8, 2013 at 1:34 PM, cgrablew <cgrablew@gmail.com > wrote:
> Where there changes made to the SMF Update Download Table? Field 13862
> Stock Name no longer works. I've been using the SMF update download table
> for years and now some of the fields no longer work like 13862. It worked
> approximately 2 weeks ago. What has changed?
>
On Mon, Jul 8, 2013 at 1:34 PM, cgrablew <cgrablew@gmail.
> Where there changes made to the SMF Update Download Table? Field 13862
> Stock Name no longer works. I've been using the SMF update download table
> for years and now some of the fields no longer work like 13862. It worked
> approximately 2 weeks ago. What has changed?
>
Mon Jul 8, 2013 5:11 pm (PDT) . Posted by:
"Chester Grablewski" cgrablew
Randy
Thanks but that was only one example Fields 27 - 32 are also problems. Any idea of how to get them?
Chuck Grablewski
Sent from my iPhone
On Jul 8, 2013, at 6:09 PM, Randy Harmelink <rharmelink@gmail.com > wrote:
> See: http://finance.groups.yahoo.com/group/smf_addin/message/22683
>
>
> On Mon, Jul 8, 2013 at 1:34 PM, cgrablew <cgrablew@gmail.com > wrote:
>> Where there changes made to the SMF Update Download Table? Field 13862 Stock Name no longer works. I've been using the SMF update download table for years and now some of the fields no longer work like 13862. It worked approximately 2 weeks ago. What has changed?
>
>
Thanks but that was only one example Fields 27 - 32 are also problems. Any idea of how to get them?
Chuck Grablewski
Sent from my iPhone
On Jul 8, 2013, at 6:09 PM, Randy Harmelink <rharmelink@gmail.
> See: http://finance.
>
>
> On Mon, Jul 8, 2013 at 1:34 PM, cgrablew <cgrablew@gmail.
>> Where there changes made to the SMF Update Download Table? Field 13862 Stock Name no longer works. I've been using the SMF update download table for years and now some of the fields no longer work like 13862. It worked approximately 2 weeks ago. What has changed?
>
>
Mon Jul 8, 2013 5:16 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Different symptom, but same cause. MSN dropped those fields from the print
page in their redesign of the web page.
On Mon, Jul 8, 2013 at 5:11 PM, Chester Grablewski <cgrablew@gmail.com >wrote:
>
> Thanks but that was only one example Fields 27 - 32 are also problems.
> Any idea of how to get them?
>
>
page in their redesign of the web page.
On Mon, Jul 8, 2013 at 5:11 PM, Chester Grablewski <cgrablew@gmail.
>
> Thanks but that was only one example Fields 27 - 32 are also problems.
> Any idea of how to get them?
>
>
Mon Jul 8, 2013 2:55 pm (PDT) . Posted by:
"kraut102" kraut102
My friend Tom pointed me to you as a replacement for MSN Quotes in Excel. We are both running Excel from Office 2010 with the Windows 7 operating system. His computer has allowed your Add-In to upload, but mine will not. After opening your file and enabling Macros the Add-In does not show up in the File > Options > Add-Ins on my computer although it does on his. We are both working with the 12-2012 latest update. Any suggestions?
Thanks,
Kurt
Thanks,
Kurt
Mon Jul 8, 2013 3:13 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You shouldn't need to enable macros for an add-in.
You should be unzipping the archive file into a folder and adding it to
EXCEL via the add-in manager, not "opening" a file. So I'm not sure what
you're trying to do.
Did you check out the "Overview"; in the "Documentation" folder of the FILES
area of the group?
Also, there are a few installation related items in the LINKS area of the
group.
On Mon, Jul 8, 2013 at 1:49 PM, kraut102 <kraut102@yahoo.com > wrote:
> My friend Tom pointed me to you as a replacement for MSN Quotes in Excel.
> We are both running Excel from Office 2010 with the Windows 7 operating
> system. His computer has allowed your Add-In to upload, but mine will not.
> After opening your file and enabling Macros the Add-In does not show up in
> the File > Options > Add-Ins on my computer although it does on his. We
> are both working with the 12-2012 latest update. Any suggestions?
>
You should be unzipping the archive file into a folder and adding it to
EXCEL via the add-in manager, not "opening" a file. So I'm not sure what
you're trying to do.
Did you check out the "Overview"
area of the group?
Also, there are a few installation related items in the LINKS area of the
group.
On Mon, Jul 8, 2013 at 1:49 PM, kraut102 <kraut102@yahoo.
> My friend Tom pointed me to you as a replacement for MSN Quotes in Excel.
> We are both running Excel from Office 2010 with the Windows 7 operating
> system. His computer has allowed your Add-In to upload, but mine will not.
> After opening your file and enabling Macros the Add-In does not show up in
> the File > Options > Add-Ins on my computer although it does on his. We
> are both working with the 12-2012 latest update. Any suggestions?
>
Mon Jul 8, 2013 5:41 pm (PDT) . Posted by:
"racecar00" racecar00
Hi Randy,
Could you help me with the syntax for obtaining daily performance figures from the Morningstar "printreport" URL
Example: http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=
I am trying to pull data from the table subheaded "Trailing Total Returns." I would like to pull data ("Total Return %") for 1-month, 3-month, etc...
I have tried several combinations with no luck.
=RCHGetTableCell("http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol= "&$B65,1,">1-Month",">Trailing Total Returns")
Thank you in advance.
Could you help me with the syntax for obtaining daily performance figures from the Morningstar "printreport&q
Example: http://quicktake.
I am trying to pull data from the table subheaded "Trailing Total Returns." I would like to pull data ("Total Return %") for 1-month, 3-month, etc...
I have tried several combinations with no luck.
=RCHGetTableCell(
Thank you in advance.
Mon Jul 8, 2013 7:29 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try:
RCHGetTableCell("
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol= "&D5,
1,"Trailing Total Returns","1-Month")
On Mon, Jul 8, 2013 at 5:41 PM, racecar00 <agelhausen@gmail.com > wrote:
>
> Could you help me with the syntax for obtaining daily performance figures
> from the Morningstar "printreport" URL
>
> Example: http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=
>
> I am trying to pull data from the table subheaded "Trailing Total
> Returns." I would like to pull data ("Total Return %") for 1-month,
> 3-month, etc...
>
> I have tried several combinations with no luck.
>
> =RCHGetTableCell("
> http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol= "&$B65,1,">1-Month",">Trailing
> Total Returns")
>
RCHGetTableCell(
http://quicktake.
1,"Trailing Total Returns"
On Mon, Jul 8, 2013 at 5:41 PM, racecar00 <agelhausen@gmail.
>
> Could you help me with the syntax for obtaining daily performance figures
> from the Morningstar "printreport&q
>
> Example: http://quicktake.
>
> I am trying to pull data from the table subheaded "Trailing Total
> Returns." I would like to pull data ("Total Return %") for 1-month,
> 3-month, etc...
>
> I have tried several combinations with no luck.
>
> =RCHGetTableCell(
> http://quicktake.
> Total Returns"
>
Mon Jul 8, 2013 7:45 pm (PDT) . Posted by:
"sri yanto" sri.yanto
thank's alot randy
i forget to push "shift" to get tilda's,
it's work, i use WSJ now for my data, but for several menu they weren't available for temporary...may be if "error" still occur, i thought it's from the original website..
smf work excelence.
thanks after all randy
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Those five characters don't look like tildas, as in ~~~~~
>
> The process replaces five consecutive tildas with the value from the ticker
> column. So if you use a different character, you're going to get an error.
>
> On Mon, Jul 8, 2013 at 2:05 AM, sri yanto <sri.yanto@...> wrote:
>
> > since common approach to get data with massive link i am using before,
> >
> > smfUpdateDownloadTable, give great solution, so i think i don't need to
> > recalculate..
> >
> > straight to the problem,
> >
> > i try to retrieved data from WSJ
> >
> > RCHGetTableCell("
> > http://quotes.wsj.com/ID/XIDX/`````/financials/annual/income-statement
> > ",5,"sales/revenue")
> >
> > i'tried itu to apply with smfUpdateDownloadTable template-
> > but it return "ERROR",
> >
> > have any idea, where's wrong here?
> >
> > thank alot after all
> >
>
i forget to push "shift" to get tilda's,
it's work, i use WSJ now for my data, but for several menu they weren't available for temporary...
smf work excelence.
thanks after all randy
--- In smf_addin@yahoogrou
>
> Those five characters don't look like tildas, as in ~~~~~
>
> The process replaces five consecutive tildas with the value from the ticker
> column. So if you use a different character, you're going to get an error.
>
> On Mon, Jul 8, 2013 at 2:05 AM, sri yanto <sri.yanto@
>
> > since common approach to get data with massive link i am using before,
> >
> > smfUpdateDownloadTa
> > recalculate.
> >
> > straight to the problem,
> >
> > i try to retrieved data from WSJ
> >
> > RCHGetTableCell(
> > http://quotes.
> > ",5,"
> >
> > i'tried itu to apply with smfUpdateDownloadTa
> > but it return "ERROR"
> >
> > have any idea, where's wrong here?
> >
> > thank alot after all
> >
>
Tidak ada komentar:
Posting Komentar