11 Messages
Digest #4172
3b
Re: Newer data for table RCHGetElementNumber-Template-AdvFN-Financia by "Randy Harmelink" rharmelink
3d
Re: Newer data for table RCHGetElementNumber-Template-AdvFN-Financia by "Randy Harmelink" rharmelink
Messages
Sat Oct 14, 2017 7:55 pm (PDT) . Posted by:
ethanbond911
Hello Boys and Girls:
I am trying to find a volatility model that will change the option price with each tick. I have no idea where and how to start. I suck both in programming and math :) Perhaps some of you smart folks can brain storm and all of us can benefit from such a model.
Anyways, you guys take good care of yourself. Happy trading.
Regards
Ethan Marcotte.
I am trying to find a volatility model that will change the option price with each tick. I have no idea where and how to start. I suck both in programming and math :) Perhaps some of you smart folks can brain storm and all of us can benefit from such a model.
Anyways, you guys take good care of yourself. Happy trading.
Regards
Ethan Marcotte.
Sun Oct 15, 2017 9:19 am (PDT) . Posted by:
ehrlichk
Does smfGetYahooPortfolioView have a limit on the number of stock symbols that data can be retrieved? I am using smfGetYahooPortfolioView-example.xls. When I put in up to 38 stock symbols, it works great. If I add a 39th symbol, all cells show "--".
Sun Oct 15, 2017 10:57 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Dim aFieldName() As String: aFieldName =
Split("xx,symbol,longName,shortName,exchange,fullExchangeName,market,marketState,sourceInterval,exchangeTimezoneName,exchangeTimezoneShortName,gmtOffSetMilliseconds,language,quoteType,quoteSourceName,regularMarketPrice,regularMarketTime,regularMarketChange,regularMarketOpen,regularMarketDayHigh,regularMarketDayLow,regularMarketVolume,bid,ask,sharesOutstanding,marketCap,averageDailyVolume3Month,targetPriceMean,revenue,priceToSales,trailingPE,epsTrailingTwelveMonths,exDividendDate,dividendsPerShare,dividendYield",
",")
Dim aHeading() As String: aHeading = Split("xx,Symbol,Long Name,Short
Name,Exchange,Full Exchange Name,Market,Market State,Source
Interval,Exchange Timezone Name,Exchange Timezone Short Name,GMT Offset
Milliseconds,Language,Quote Type,Quote Source Name,Last Price,Last
Traded,Change,Open,High,Low,Volume,Bid,Ask,Shares Outstanding,Market
Cap,Average 3M Volume,Mean Target Price,Revenue,P/S,P/E,EPS TTM,Ex-Dividend
Date,Dividends Per Share,Dividend Yield", ",")
Split("
","
Dim aHeading() As String: aHeading = Split("
Name,Exchange,
Interval,Exchange Timezone Name,Exchange Timezone Short Name,GMT Offset
Milliseconds,
Traded,Change,
Cap,Average 3M Volume,Mean Target Price,Revenue,
Date,Dividends Per Share,Dividend Yield", ","
Sun Oct 15, 2017 2:16 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hmm. I'm surprised that still works. That was based on the old portfolio
view product that Yahoo had, before the massive website changes this year.
I know it stopped working, so they must have done some follow-up changes.
I had forgotten it even existed. :)
Interesting, the change log in the module says:
' 2017.05.02 -- Obsoleted because portfolio table was replaced by JSON
file
' 2017.06.21 -- Rewrite to extract fields from JSON file
...so I did update it for the new JSON file, and forgot I had done that.
The old version used to have a limit of around 400 tickers. Looks like the
current limit is based on the size of the JSON file. I'll have to consider
what to do about that. A field-by-field JSON extraction isn't very
efficient for a large file, so I may have to rewrite it to go sequentially
through the file instead of randomly.
On Sun, Oct 15, 2017 at 9:19 AM, ehrlichk@
...
wrote:
> Does smfGetYahooPortfolioView have a limit on the number of stock symbols
> that data can be retrieved? I am using smfGetYahooPortfolioView-example.xls.
> When I put in up to 38 stock symbols, it works great. If I add a 39th
> symbol, all cells show "--".
>
>
>
view product that Yahoo had, before the massive website changes this year.
I know it stopped working, so they must have done some follow-up changes.
I had forgotten it even existed. :)
Interesting, the change log in the module says:
' 2017.05.02 -- Obsoleted because portfolio table was replaced by JSON
file
' 2017.06.21 -- Rewrite to extract fields from JSON file
...so I did update it for the new JSON file, and forgot I had done that.
The old version used to have a limit of around 400 tickers. Looks like the
current limit is based on the size of the JSON file. I'll have to consider
what to do about that. A field-by-field JSON extraction isn't very
efficient for a large file, so I may have to rewrite it to go sequentially
through the file instead of randomly.
On Sun, Oct 15, 2017 at 9:19 AM, ehrlichk@
...
wrote:
> Does smfGetYahooPortfoli
> that data can be retrieved? I am using smfGetYahooPortfoli
> When I put in up to 38 stock symbols, it works great. If I add a 39th
> symbol, all cells show "--"
>
>
>
Sun Oct 15, 2017 9:36 am (PDT) . Posted by:
timdbui
Hi Randy,
It has been many years since I logged in this site. I am trying to relearn the system. I see the data item numbers in table GetElementNumber for AdvFN. However, this table has a date of 2006. Have you updated new data items? If you do, would you please point me to where I can get the complete list. Also, do you have a comprehensive list of all of the data item from different sources?
Thank you so much for your help!
Tim
It has been many years since I logged in this site. I am trying to relearn the system. I see the data item numbers in table GetElementNumber for AdvFN. However, this table has a date of 2006. Have you updated new data items? If you do, would you please point me to where I can get the complete list. Also, do you have a comprehensive list of all of the data item from different sources?
Thank you so much for your help!
Tim
Sun Oct 15, 2017 10:35 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'd suggest grabbing and unzipping the latest ZIP file from the web site:
http://ogres-crypt.com/SMF/
There have been a number of changes in the past few years, several for
AdvFN. Many to element definitions.
The documentation of the currently available elements is in that ZIP file.
On Sun, Oct 15, 2017 at 9:36 AM, timdbui@
...
wrote:
> It has been many years since I logged in this site. I am trying to relearn
> the system. I see the data item numbers in table GetElementNumber for
> AdvFN. However, this table has a date of 2006. Have you updated new data
> items? If you do, would you please point me to where I can get the complete
> list. Also, do you have a comprehensive list of all of the data item from
> different sources?
>
>
>
http://ogres-crypt.com/SMF/
There have been a number of changes in the past few years, several for
AdvFN. Many to element definitions.
The documentation of the currently available elements is in that ZIP file.
On Sun, Oct 15, 2017 at 9:36 AM, timdbui@
...
wrote:
> It has been many years since I logged in this site. I am trying to relearn
> the system. I see the data item numbers in table GetElementNumber for
> AdvFN. However, this table has a date of 2006. Have you updated new data
> items? If you do, would you please point me to where I can get the complete
> list. Also, do you have a comprehensive list of all of the data item from
> different sources?
>
>
>
Sun Oct 15, 2017 10:54 am (PDT) . Posted by:
timdbui
Thank you for your reply, Randy. I saw this spreadsheet RCHGetElementNumber-Element-Definitions.xls http://ogres-crypt.com/SMF/Elements/RCHGetElementNumber-Element-Definitions.xls that has a date of Sept 16, 2017. Is this the file that you referred to? Thank you
Sun Oct 15, 2017 10:59 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's it.
On Sun, Oct 15, 2017 at 10:54 AM, timdbui@
...
wrote:
>
> Thank you for your reply, Randy. I saw this spreadsheet RCHGetElementNumbe
> r-Element-Definitions.xls
> <http://ogres-crypt.com/SMF/Elements/RCHGetElementNumber-Element-Definitions.xls> that
> has a date of Sept 16, 2017. Is this the file that you referred to? Thank
> you
>
On Sun, Oct 15, 2017 at 10:54 AM, timdbui@
...
wrote:
>
> Thank you for your reply, Randy. I saw this spreadsheet RCHGetElementNumbe
> r-Element-Definitions.xls
> <http://ogres-crypt.com/SMF/Elements/RCHGetElementNumber-Element-Definitions.xls> that
> has a date of Sept 16, 2017. Is this the file that you referred to? Thank
> you
>
Sun Oct 15, 2017 10:09 am (PDT) . Posted by:
yujuch
Any one using "Trend Exhaustion market timing excel spreadsheet"
I can not add it on my excel.
I guess the problem might be I am using the excel 2010. How do I get a lower version to install the add-in? Or someone knows how to do it in excel 2010?
Thank You very much For any of your help!
YJ
Send
Cancel
Sun Oct 15, 2017 10:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Should work fine with EXCEL 2010. That's what I was using prior to getting
a new computer in May.
Why can't you add the add-in to EXCEL? What message is it giving you when
you try to add it in the add-in manager?
On Sun, Oct 15, 2017 at 9:06 AM, yujuch@
...
wrote:
>
>
> Any one using "Trend Exhaustion market timing excel spreadsheet". I
> would like to use this, but I have trouble to install the add-in SMF.
> I can not add it on my excel.
> I guess the problem might be I am using the excel 2010. How do I get a
> lower version to install the add-in? Or someone knows how to do it in
> excel 2010?
>
>
>
a new computer in May.
Why can't you add the add-in to EXCEL? What message is it giving you when
you try to add it in the add-in manager?
On Sun, Oct 15, 2017 at 9:06 AM, yujuch@
...
wrote:
>
>
> Any one using "Trend Exhaustion market timing excel spreadsheet"
> would like to use this, but I have trouble to install the add-in SMF.
> I can not add it on my excel.
> I guess the problem might be I am using the excel 2010. How do I get a
> lower version to install the add-in? Or someone knows how to do it in
> excel 2010?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar