StockFetcher Forums · Filter Exchange · MY XIV TRADING SYSTEM USING STRATASEARCH FILTERS<< 1 ... 6 7 8 9 10 ... 40 >>Post Follow-up
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!

StockFetcher Forums · Filter Exchange · MY XIV TRADING SYSTEM USING STRATASEARCH FILTERS<< 1 ... 6 7 8 9 10 ... 40 >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2022 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.