nibor100
1,099 posts
msg #139651
- Ignore nibor100 |
11/30/2017 11:45:13 AM
When I looked closer at my signals for 11/29 I noticed that my ASCII data from TC2007 was different than the Yahoo prices for the two HOLD Open prices, one by 1 cent and the other by 7 cents so I decided to do an ASCII import of data using a CSV file consisting of the Yahoo data just in case penny's count :).
I reran the signals for 11/29 and now I have the same 2 Holds but I have 5 Buys instead of 4, from strategy;s #3, 20, 33, 38, 40.
Now 1 Buy signal is different from Kevin and others, and I don't have 1 signal that Ferndave gets.
The mystery continues....
Ed S.
|
Eltonm45
19 posts
msg #139652
- Ignore Eltonm45 |
11/30/2017 12:31:24 PM
Hi Kevin
Any reason you chose XIV over other ETFs? I copied the XIV strategy signals for another ETF just to test it out ( BOTZ ) and it showed some impressive returns. Thank you very much for sharing this with the rest of us.
As for price update- yahoo is pretty good about updating prices if you do it by sector. I manually created a few different ETF sectors and update the prices without issue every night.
|
ferndave
65 posts
msg #139654
- Ignore ferndave |
11/30/2017 1:05:28 PM
davesaint86: I don't see SS losing its ability to give signals anytime soon. The only potential future issue is importing price data. Within the last six-months, Yahoo and Google have messed with the ability to fetch data, especially historical data. It sounds like they currently work, though as you can read in this thread, they sometimes have blips. Even if those two completely cut off their feeds, there is always the ascii import.
nibor100: I checked my signals again. I have #20, not #28, so I share three of your five. It isn't completely uncommon to have slight signal discrepancies. I've used the same signals on different SS installs using the same data, and had a signal trigger on one and not the other.
|
davesaint86
726 posts
msg #139657
- Ignore davesaint86 |
11/30/2017 1:15:06 PM
I haven't figure out how to import an ascii file. I tried last night but failed. I saved the .csv as a txt. I then moved over the symbol, name and I forgot what else. I selected the folder where the txt file resides and clicked ok. Prices did not import so I did something wrong.
|
ferndave
65 posts
msg #139658
- Ignore ferndave |
11/30/2017 1:26:18 PM
Importing ascii files can be tricky. I'd make sure that you're not changing the filetype to txt and keeping it as a .csv. After that, you need to make sure the Record Layout mirrors the columns in the csv, especially the date order.
|
davesaint86
726 posts
msg #139660
- Ignore davesaint86 |
11/30/2017 1:30:51 PM
What fields from the the from to box to you bring over if any?
|
davesaint86
726 posts
msg #139661
- Ignore davesaint86 |
11/30/2017 1:32:49 PM
Ok so we might be able to pull price info from a number of feeds. What if SS no longer works with newer versions of windows (maybe 5 years out)? I know I'm projecting risk and thinking of the worse case scenario.
|
ferndave
65 posts
msg #139663
- Ignore ferndave |
11/30/2017 1:48:31 PM
dave: it depends, each source may be a little different. Where you're getting the csv from?
As for longevity, if you're having years of success using SS, getting a laptop or old desktop that runs an old version of Windows shouldn't be a problem. The author of SS has tentative ideas on rewriting SS from the ground up. Not a sure thing, but a possibility.
|
Kevin_in_GA
4,599 posts
msg #139664
- Ignore Kevin_in_GA |
11/30/2017 1:49:33 PM
In the standard Yahoo historical data download (as a .csv) all you need to do is to delete the "adjusted close" column and save it as the ticker name. Then go into SS (File -> Import Prices ...) and select ACSII
The correct file import format is as follows:
Directory - wherever you put the .csv file
Delimiter is "comma"
Symbol - "from Filename"
Product - "Stocks"
Bypass Header - Yes
Record layout (make sure these are in the same order as I list them here:
Date MDY
Open Price
High Price
Low Price
Close Price
Volume
|
davesaint86
726 posts
msg #139665
- Ignore davesaint86 |
11/30/2017 1:53:44 PM
Thanks Kevin - I see why it did not work. My workaround - I copied the symbol data from the .csv and saved it to my hard drive. I just left xiv as the symbol. I then ran the Yahoo Import. It took about 20 seconds for the import to complete.
|