|
kmcintyre
 Veteran
  Posts: 132
Joined: 9/12/2007
Location: Valley Center, CA
User Profile |
I am trying to compute the float for a stock.
This is the data I have available in OT2023.
in Focus List Columns (OmniData )
SharesOut
Shares(%Insiders)
Shares(%Instit)
ShortIntShares
ShortIntRatio
ShortIntFloat%
in OLang
SHRSQ (Shares Outstanding Quarterly Report)
I am guessing that the keyword finder in the OL IDE has not been updated in quite a while.
Does anyone know what identifiers I would use in OL to access the OmniData Fundamental values listed above?
Has anyone worked out an OLang formula for computing the float?
Thanks
|
|
kmcintyre
 Veteran
  Posts: 132
Joined: 9/12/2007
Location: Valley Center, CA
User Profile |
After talking with Barry, I learned Float was dropped in OmniData a while ago.
I found that BarChart.com has Float (from Zacks) as part of its database.
Using BarChart's Stock Screener I was able to create a screener and display template that gives me the information I need.
I can download the screener output in .csv format.
I created an indicator that parses and converts the Float data so I can use it in OT2023.
I am attaching a sample .csv and the indicator source code.
Why? Why not?
If I (or someone else) wants to import a per Symbol data value, this code might be a good place to start...
Cheers
Attached file : Float.csv (32KB - 211 downloads)
Attached file : indFloat.txt (3KB - 220 downloads)
|
|
kmcintyre
 Veteran
  Posts: 132
Joined: 9/12/2007
Location: Valley Center, CA
User Profile |
Updated source file...
Attached file : indFloat.txt (3KB - 222 downloads)
|
|
Jim Dean
 Sage
       Posts: 3433
Joined: 3/13/2006
Location: L'ville, GA
User Profile |
Nicely done!
How often is the raw data updated?
If you don’t plan to provide regular updates here, maybe a cookbook for updating the download might be helpful.
|
|
kmcintyre
 Veteran
  Posts: 132
Joined: 9/12/2007
Location: Valley Center, CA
User Profile |
I have BarChart email me an updated screener output every day.
I do not think float values change that frequently. Either the company or insiders must make significant changes to change the float.
I plan on updating weekly, but all I need to do is save an attachment to the right folder and OT2023 has the updated float values.
I pay $17 per month for BarChart.
I wish OmniData had this data.
It would be cheaper and easier.
Float / avg daily volume tells me how many days of inventory is on hand. If there is an increase in demand for a product that is low on inventory, price should escalate. (According to econ 101...)
Cheers
|