| User | Post |
|
4:20 pm
January 5, 2012
|
luke17
| | |
| New Member | posts 2 |
|
|
It worked when I closed excel and restarted Windows. Thanks!
|
|
|
12:20 am
January 5, 2012
|
Jae Jun
| | |
| Admin
| posts 1336 |
|
|
It's quicker to make the code edit yourself. Could you try following the step by step guide in the manual?
There is a section titled "for non USA users"
|
|
|
11:55 pm
January 4, 2012
|
luke17
| | |
| New Member | posts 2 |
|
|
Could you send me the SMF file for Canada bec I don't see it from the folder. Thanks!
Jae Jun said:
i see.
There are two places where the code has to be updated.
Modcreatecomment has nothing to do with pulling data which is why it isn't working.
If you go to the protected URL go into the folder that is labeled Premium_v20100802/ and there is an exe file called SMF_Canada_Users_Only_setup.exe
Delete the current SMF folder on your computer, and just run the exe file again.
Then try again. That should do it.
Jae Jun said:
i see.
There are two places where the code has to be updated.
Modcreatecomment has nothing to do with pulling data which is why it isn't working.
If you go to the protected URL go into the folder that is labeled Premium_v20100802/ and there is an exe file called SMF_Canada_Users_Only_setup.exe
Delete the current SMF folder on your computer, and just run the exe file again.
Then try again. That should do it.
Jae Jun said:
i see.
There are two places where the code has to be updated.
Modcreatecomment has nothing to do with pulling data which is why it isn't working.
If you go to the protected URL go into the folder that is labeled Premium_v20100802/ and there is an exe file called SMF_Canada_Users_Only_setup.exe
Delete the current SMF folder on your computer, and just run the exe file again.
Then try again. That should do it.
Could you send me this exe file for Canada users. Thanks!
|
|
|
10:46 am
January 28, 2011
|
Jae Jun
| | |
| Admin
| posts 1336 |
|
|
This is not anadd-in issue but related to how you have your number system set up in windows.
Please refer to the manual FAQ section for european users.
|
|
|
1:19 am
January 28, 2011
|
mln2002
| | |
| New Member | posts 1 |
|
|
Hi,
I have Excell 2003 and I'm in Europe.
I''ve installed the
received SMF pack, named with 'US -users' and I have a problem with some
units, for example, for MDT ticker, the current price that appears on
the stock-valuation-excel is $3.799,00 while the correct is $37,99
Then, all the next analysis has wrong values.
Is there other version of the SMF package to solve this problem?
Thank you
Michael
|
|
|
12:19 pm
August 26, 2010
|
Jae Jun
| | |
| Admin
| posts 1336 |
|
|
i see.
There are two places where the code has to be updated.
Modcreatecomment has nothing to do with pulling data which is why it isn't working.
If you go to the protected URL go into the folder that is labeled Premium_v20100802/ and there is an exe file called SMF_Canada_Users_Only_setup.exe
Delete the current SMF folder on your computer, and just run the exe file again.
Then try again. That should do it.
|
|
|
12:13 pm
August 26, 2010
|
Shouclack
| | |
| Member | posts 5 |
|
|
modCreateComment have this line;
sURL = "http://ca.advfn.com/p.php?pid=financialgraphs" '&a0=13&a1=13&a2=10&a3=8&a4=8&a5=10"
Neither
NYSE:KO or just KO works
Also changed it to;
sURL = "http://ih.advfn.com/p.php?pid=financialgraphs" '&a0=13&a1=13&a2=10&a3=8&a4=8&a5=10"
Doesn't work neither. At each mod I do save the vbs project, close the file, reopen it and check if the mod still there.
|
|
|
12:05 pm
August 26, 2010
|
Jae Jun
| | |
| Admin
| posts 1336 |
|
|
Can you try entering "NYSE:KO" into the stock ticker?
If that doesn't work, then the changes to the code in the add-in hasn't been saved.
And the URL you changed it to has to be exactly the same as the URL you are directed to.
If you enter http://www.advfn.com and get directed to ca.advfn.com, then you need to change the code the redirected URL
|
|
|
12:00 pm
August 26, 2010
|
Shouclack
| | |
| Member | posts 5 |
|
|
I was only tested OSV_Financial_Statement_Analysis-v20100802… It still doesn't work.
However, OSV_Stock_Valuation-v20100821 works just fine!
|
|
|
11:55 am
August 26, 2010
|
Shouclack
| | |
| Member | posts 5 |
|
|
hmmm… nothing change, still same error. ie. "DLB is unsupported or a financial…"
|
|
|
11:40 am
August 26, 2010
|
Jae Jun
| | |
| Admin
| posts 1336 |
|
|
Open the spreadsheet.
1.Right click on the any of the tab and click "view code". This will bring up a window with code in it.
2. On the left side, navigate to a folder called RCH_Stock_market_function
3. Open up the subfolder called "modules"
4. right click "modCreateComment" and then click on the main body window
5. press CTRL+F to find
6. select Search Current Project
7. search for http://www.advfn.com and replace with the URL you got directed to. e.g. ca.advfn.com or ih.advfn.com etc |
|
|
11:36 am
August 26, 2010
|
Shouclack
| | |
| Member | posts 5 |
|
|
I found out that http://ih.advfn.com provide same info as advfn.com without redirect, if it might help.
As for your fix, would gladly like to know how to fix it myself if you don't mind…
thanks for your fast response!
Steeve
|
|
|
9:59 am
August 26, 2010
|
Jae Jun
| | |
| Admin
| posts 1336 |
|
|
If you can wait until later tonight, I can send you a canadian version of the addin that will access ca.advfn.com.
Or if you want to do it now, I can post the instructions here on how to make the change yourself.
|
|
|
9:51 am
August 26, 2010
|
Shouclack
| | |
| Member | posts 5 |
|
|
First, bravo for your great work! I know what it meant for work having done one myself. Unfortunately it became unreliable because I was pointing to reuters.com that is being screw up by Thomson (D@mn you Thomson)
Over with my ranting :) I have the same issue, where http://www.advfn.com is resolve in my case to http://ca.advfn.com/ thus leading the spreadsheet to give "Financial
statement line items Incorrect." . Do you have an idea when this will be fix?
Again wonderful work and keep on improving it!
Steeve
|
|
|
7:53 am
August 19, 2010
|
Jae Jun
| | |
| Admin
| posts 1336 |
|
|
Just sent out email for new updated files.
Please check your inbox.
|
|
|
6:15 pm
August 18, 2010
|
kisei
| | |
| Member | posts 3 |
|
|
I am directed to http://asia.advfn.com (I am located in Hong Kong)
|
|
|
1:48 pm
August 18, 2010
|
Jae Jun
| | |
| Admin
| posts 1336 |
|
|
if you go to http://www.advfn.com are you redirected to another URL? e.f. ca.advfn.com?
I've been getting this issue for a lot of people living outside the US so I'm make a fix and will send it out asap.
|
|
|
12:22 am
August 18, 2010
|
kisei
| | |
| Member | posts 3 |
|
|
I have just bought and installed the model and am having trouble pulling down data.
When using the "OSV_Financial_Statement_Analysis-v20100802" file, every ticker that I try results in a message which says that the company is unsupported (not trying financial company, just industrial companies). I have gone to Morningstar site and the financial data is there so that is not the problem. I am also in US settings with correct decimal setting so that is not problem either.
When using the "OSV_Stock_Valuation-v20100802" file I can pull down data for Balance Sheet and Cash Flow but not the Income statement.
What should I do?
Thanks,
Kisei
|
|
Home
