I had heard that it is possible to download segment match data from FTDNA now, so I thought that I might try it. I had downloaded this data previously into a spreadsheet that looked like this:
Actually, this is my brother’s match sheet. First I chose Chromosome Browser under my autosomal matches section. Then I choose download all segments:
There should be a lot of segment data there. However, when I check my downlike file, the file is not as large as expected:
There are about 10,000 lines and my old file has 86,000 lines. However, a lot of these may be from Gedmatch and a few other sources. I also have this file:
I need to merge the two files somehow. This file is helpful because it has the match date. This is the format I want:
If I can remember how to use MS Access, that would be helpful. FTNDA no longer downloads the kit number. Also, Access likes Excel Files, so I needed to convert the csv file to an excel file:
I stuck the first two tables into a database I already have. Next I need to perform a query on the two tables. Here is my query:
Next, I need to add fields. I tried to get them in the order of my master spreadsheet. I ran the query and got this:
I have two columns for Match Date. I will have to fix that. Also, the Match Dates are off. I was trying to get the match dates only past a certain date in January 2022. That means that I imported the wrong match list file from FTDNA. I re-checked and made a new file and then imported the right one:
The dates look better now. I notice that there is no email which is OK as I can always look that up at FTDNA. The Matching Bucket field could be useful. One more correction is that I do not see the end location:
This is a bit of trial and error. Next, I need to incorporate this information into my master segment list. Here I line up everything with my master spreadsheet:
Turned out I had the wrong master spreadsheet, so I had to do this again with the real master spreadsheet. The end result looks like this:
This is a random shot from my list. The arrows point to two matches that FTDNA think are maternal. Where I have another maternal match in this section as Rathfelder, the match could be on the Rathfelder side.
What is the Use of Segments?
Segments can be helpful in finding the side that your match is on, or in the ancestral line where your match should appear. For example, I have an unknown match from Ancestry named Lee. Lee has a Hartley Line that is from the same area that my Hartleys are from:
Lee’s match is shon in a shade of blue on my DNA Painter Profile:
This is on Chromosome 13:
Our match is between position 88 and 110 million. Here is my match list for Chromosome 13:
Any of the paternal matches in blue could be along the same line as Lee. I don’t have lee on the list, so I need to add him from Gedmatch.
Lee and Gedmatch
Gedmatch has a utility that will show me common matches between Lee and myself:
This is near the bottom of my list and the projected match is out to 5 generations. That means that they are potentially fourth cousins or further out. The first three columns of numbers are how these people match me. The fourth through sixth colums are how the matches match Lee. The last column is interesting to me as it includes genealogical information. In one tree, I saw the Clarke name. I also have Clarke ancestors, but they were from Ireland and this family was from England. Another tree had a Clarke from 1835 in England. So, the connection from genealogy is not clear. Lee also has Clark in his tree, so coincidence? I think that Clark is a common name. I would rule out Clark based on the fact that two of my father’s cousins are on the shared match list. Those cousins are on my paternal grandfather’s side and my Clarke ancestors are on my paternal grandmother’s side. However, I cannot rule out a second Clark line on my paternal grandfather’s side.
Unfortunately, I did not see any easy connections to Colne through this exercise.
Richard: A Match on My Frazer Side
I match Richard here:
The smaller match on Chromosome 17 is Richard’s brother. Here is the likely connection at MyHeritage:
Here, I just added Richard to my spreadsheet:
These are some matches that could overlap with Richard.
Summary and Conclusions
- I was able to download about two and a half years worth of FTDNA autosomal matches
- These matches I added to my spreadsheet with the help of MS Access
- I was able to add some key matches from other sources to my master match spreadsheet
- I could do this for my siblings, but it would make more sense to download the matches from my father’s first cousins and my mother’s matches. In other words, the matches from those who are a generation older than me.
- The exercise did not result in any new revelations, but may be helpful in the future.