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.
|
nibor100 1,099 posts msg #139668 - Ignore nibor100 |
11/30/2017 3:07:52 PM
@davesaint86,
Some tips based on my dealings with SS ASCII imports, I've imported successfully from 2 different sources resulting in learning the following:
a. Name the file you are importing with Yahoo prices as XIV
b. Save that file in its own folder in a Directory of your choice making sure its the only file in that folder.
c. Keep the file as an Excel CSV file with the rows of data in the same order that you got it from Yahoo
d. Delete the column entitled "Adj Close"
e. Delete the header row/first row of the file
f. the first row of data should be dated 11/30/2010
In SS, in the box that opens when you choose File, Import Prices
1. Make sure Multiply Volume by box is empty
2.For the Directory white box select Browse and go to the directory path your file is in
3. In the Symbol grey box choose From Filename
4. The Delimiter box should read Comma
5. In the record layout box have your fields in the following order:
Date MDY
Open Price
High Price
Low Price
Close Price
Volume
These tips are based on loading only XIV data Yahoo only as I have not tried any multiple symbol loads using the ASCII method in SS.
Future XIV data import tip:
I just open the XIV.csv file in Excel and enter the new day(s) data at the bottom and re-save it and close it in Excel before doing the next import.
Let me know if that works for you,
Ed S.
|
davesaint86 726 posts msg #139669 - Ignore davesaint86 |
11/30/2017 3:27:33 PM
Thank you for the instructions!
|